Saturday, September 5, 2020

COC for form datasource Execute query

 [ExtensionOf(formDataSourceStr(LedgerJournalTable,LedgerJournalTable))]
final class LedgerJournalTableForm_Extension
{
    public void executeQuery()
    {
        FormDataSource   ledgerJournal_ds = this;
        UserGroupList    userGroupList,userGroupListLoc;
         
        str              currentUser;
        select userGroupList
            where userGroupList.userId == curUserId()
               && userGroupList.groupId like "LOC*";
        if(userGroupList)
        {
            while select userGroupListLoc
                    where userGroupListLoc.groupId == userGroupList.groupId
            {
                ledgerJournal_ds.query().dataSourceTable(tableNum(LedgerJournalTable)).addRange(fieldNum(LedgerJournalTable,CreatedBy)).value(SysQuery::value(userGroupListLoc.userId));
            }
        }
        next executeQuery();
        
    }
}

No comments:

Post a Comment

TFS Work space configuration

Refer below link:  https://d365byjp.blogspot.com/2018/10/steps-to-configure-tfsvsts-workspace-in.html