Showing posts with label XDS. Show all posts
Showing posts with label XDS. Show all posts

Sunday, September 19, 2021

Extensible Data Security (XDS) Framework In D365FO

 

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 !!