Posts

Showing posts from June, 2023

workflow creation

 Link :  workflow

Look up part 2

  SysTableLookup sysTableLookup;         QueryBuildDataSource queryBuildDataSourceContract;         Query query = new Query();         queryBuildDataSourceContract = Query.addDataSource(tableNum(FlxContractTable));         queryBuildDataSourceContract.addRange(fieldNum(FlxContractTable, ContractStatusId)).value(enum2Str(FlxContractStatus::Active));         queryBuildDataSourceContract.addRange(fieldNum(FlxContractTable, CustAccount)).value(SysQuery::valueNotEmptyString());         queryBuildDataSourceContract.addRange(fieldNum(FlxContractTable, FeeContract)).value(SysQuery::value(NoYes::No));         sysTableLookup = SysTableLookup::newParameters(tableNum(FlxContractTable), _control,true);         sysTableLookup.addLookupfield(fieldNum(FlxContractTable, contractID), true);         sysTableLookup.pa...

Look up part 1

  SysTableLookup sysTableLookup;         QueryBuildDataSource queryBuildDataSourceContractLease;         QueryBuildDataSource queryBuildDataSourcePeriodTable;         QueryBuildDataSource queryBuildDataSourceLeaseType;         Query query = new Query();         queryBuildDataSourceContractLease = Query.addDataSource(tableNum(FlxContractLease));         queryBuildDataSourceContractLease.addRange(fieldNum(FlxContractLease, contractId)).value(dialogContractID.value());         queryBuildDataSourcePeriodTable = queryBuildDataSourceContractLease.addDataSource(tableNum(FlxPeriodTable));         queryBuildDataSourcePeriodTable.addLink(fieldNum(FlxContractLease,BillingFrequencyPeriodId), fieldNum(FlxPeriodTable ,periodid));         queryBuildDataSourcePeriodTable.joinMode(JoinMode::InnerJoin);   ...