Create RLS via X++

// Sample code of how to create RLS via X++
static void mydSXP_TestInsertRLS(Args _args)
{
    Query                   q;
    SysQueryRun             queryRun;
    sysRecordLevelSecurity  sysRecordLevelSecurity,sysRecordLevelSecurity_old;
    ;

    q = new Query();

    q.addDataSource(tablenum(CustTable));
    SysQuery::findOrCreateRange(q.dataSourceNo(1),fieldnum(CustTable,CustGroup)).value(queryValue(10) +','+queryValue(20)+','+queryValue(30));

    queryRun    =   new SysQueryRun(q);

    // Need to have a RecordSortList and insert will happen for one time only, loop of companies is needed
    sysRecordLevelSecurity.clear();
    sysRecordLevelSecurity.TabId        =   77;
    sysRecordLevelSecurity.companyId    =   'SJH';
    sysRecordLevelSecurity.groupId      =   'SJH_TEST';
    sysRecordLevelSecurity.restriction  =   queryRun.pack();

    // TODO - Check how to update
    // Need to check for the primark key combination
    // TabId,groupId,companyId
    if(sysRecordLevelSecurity.validateWrite())
    {
        select firstonly sysRecordLevelSecurity_old
        where sysRecordLevelSecurity_old.tabId  ==  sysRecordLevelSecurity.tabId    &&
        sysRecordLevelSecurity_old.companyId    ==  sysRecordLevelSecurity.companyId    &&
        sysRecordLevelSecurity_old.groupId      ==  sysRecordLevelSecurity.groupId;

        if(sysRecordLevelSecurity_old)
        {
            ttsbegin;
            sysRecordLevelSecurity_old.selectForUpdate(true);
            sysRecordLevelSecurity_old.restriction  =   sysRecordLevelSecurity.restriction;
            sysRecordLevelSecurity_old.write();
            ttscommit;
        }
        else
        {
            sysRecordLevelSecurity.selectForUpdate(true);
            sysRecordLevelSecurity.write();
        }
    }

}

RLS - Record level security

Record level security (RLS) is automatically handled by the kernel when a form or report is opened
RLS need to be configured for each company

RLS - Works
- RLS on any table
- RLS also restricts the information that is sent from Application Integration Framework (AIF) to external by default
- Excel export will follow RLS
- Report Builder (based on AOT Perspective -> Report Model)
- Visio Studio Reporting tool for AX (based on AOT queries)
- RLS for "save data per company" No
- In shared Tables (virtual company)
- Document handling - If a person have access to a record, then he will able to see the documents attached to it also?

RLS - won't works In
- In display and edit methods
- In FormListControl, FormTreeControl or TableListControl
- In temporary table as a data source
- Table joins won't work
- Any code level calculation by default won't follow the RLS unless un-till it is specified explicitly
- In Table View does not follow RLS

10 MorphX tricks in 10 minutes

Click here

Sales Order posting via X++

static void SalesOrderPosting(Args _args)
{
SalesFormletter SalesFormletter;
SalesTable SalesTable;
;

SalesFormletter = SalesFormletter::construct(DocumentStatus::Confirmation,true); // Needed status

SalesTable.clear();
SalesTable = SalesTable::find('');
SalesFormletter.update(SalesTable, systemDateGet(), SalesUpdate::All, AccountOrder::None, false, false);
}