/**
* Get Tree ID for role
*
* @return AD_Tree_ID as int
*/
private int getTreeID() {
int AD_Role_ID = m_context.getAD_Role_ID();
// Load Menu Structure ----------------------
int AD_Tree_ID =
QueryUtil.getSQLValue(
null,
"SELECT COALESCE(r.AD_Tree_Menu_ID, ci.AD_Tree_Menu_ID)"
+ "FROM AD_ClientInfo ci"
+ " INNER JOIN AD_Role r ON (ci.AD_Client_ID=r.AD_Client_ID) "
+ "WHERE AD_Role_ID=?",
AD_Role_ID);
if (AD_Tree_ID <= 0) AD_Tree_ID = 10; // Menu
return AD_Tree_ID;
} // getTreeID
