Project:
| View Revisions: Issue #33198 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0033198: Wrong Organization in treenode | ||
| Revision | 2016-06-23 20:04 by caristu | ||
| Steps To Reproduce | 1 - Log in the ERP and check (by clicking in the name) that the organization you are using is "F&B España - Región Norte" 2 - Go to "Account Tree" window 3 - Select the tree "F&B International Group Account Account 4 - Switch to "Element Value" tab and add a new element with name = 'Test' and a NUMERIC value for the search key, for example 10001 5 - Execute this query in the database: Select e.c_elementvalue_id elementID, t.ad_treenode_id treenodeID, oe.name elementOrg, ot.name treenodeOrg from c_elementvalue e join ad_org oe on e.ad_org_id = oe.ad_org_id join ad_treenode t on t.node_id = e.c_elementvalue_id join ad_org ot on ot.ad_org_id = t.ad_org_id where e.name = 'test' 6 - Realize that elementOrg is F&B International Group (The Account tree's organization --> OK) and the treenodeOrg is F&B España - Región Norte (The actual user's organization --> wrong, it should be the same as elementOrg) |
||
| Revision | 2016-06-23 19:28 by caristu | ||
| Steps To Reproduce | 1 - Log in the ERP and check (by clicking in the name) that the organization you are using is "F&B España - Región Norte" 2 - Go to "Account Tree" window 3 - Select the tree "F&B International Group Account Account 4 - Switch to "Element Value" tab and add a new element with name = 'Test' 5 - Execute this query in the database: Select e.c_elementvalue_id elementID, t.ad_treenode_id treenodeID, oe.name elementOrg, ot.name treenodeOrg from c_elementvalue e join ad_org oe on e.ad_org_id = oe.ad_org_id join ad_treenode t on t.node_id = e.c_elementvalue_id join ad_org ot on ot.ad_org_id = t.ad_org_id where e.name = 'test' 6 - Realize that elementOrg is F&B International Group (The Account tree's organization --> OK) and the treenodeOrg is F&B España - Región Norte (The actual user's organization --> wrong, it should be the same as elementOrg) |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |