Topic
No replies
Takreem
Takreem
1 Post
ACCEPTED ANSWER

Pinned topic Need to know best use of queries in customization

‏2012-10-14T07:18:35Z |
Hi
I wanted to know best use of queries in customization for good database performance.
Suppose I am using the below statement

String personid=mbo.getMboSet("ALLOCATION").getMbo(0).getString("PERSONID");
MboSetRemote womboset=mbo.getThisMboSet();
womboset.setWhere("WORKORDER.WONUM in (select wonum from allocation where personid = '"personid"') " +
"AND WORKORDER.CLASSSTRUCTUREID in (select classstructureid from classancestor where ancestorclassid = 'PNLMOVE')" );

should i use that way or some other for good database performance.
Plz clarify my doubts.