These are the object I am using to full fill the XDS concept. I have a requirement like I have to show only transfer line records which have the same 'from site' and 'to site'.
- All objects
- Query
- Role
- Policy
In the above concept, I am using Table relations. We can apply the range in the static query. Just check the below example.
Here I am applying the range in the 'InventDimId' field.
Create a new class and write the below method.
[QueryRangeFunction] public static str GetSite() { InventDim inventDim1,inventDim2; InventJournalTrans inventJournalTrans; str text; int i = 1; container c; while select inventJournalTrans where inventJournalTrans.InventDimId && inventJournalTrans.ToInventDimId { InventSiteId siteid, Tositeid; siteid = InventDim::find(inventJournalTrans.InventDimId).InventSiteId; Tositeid = InventDim::find(inventJournalTrans.ToInventDimId).InventSiteId; if(siteid == Tositeid && !conFind(c, inventJournalTrans.InventDimId)) { //c += strfmt('(InventJournalTrans.InventDimId == "%1")',inventJournalTrans.InventDimId); c = conIns(c,i,inventJournalTrans.InventDimId); i++; } } //text = con2str(c,"||"); text = con2str(c,","); return text; }
In the static query drag the required field to ranges node. In the value property apply like this
"(XDSClass::getSite())".
Apply the range like the below screenshot.
Keep Daxing !!