[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();
}
}
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