Share
Report
2Hi For BankAccountTrans there is a relation defualt dimension , now i am using a query names (CashBook)
and given relation as well , but dont know howto create lookup for business unit as well as i have to give range in this query for business unit as well . i already have created a dialog for bankaccount code , can i create lookup for business unit using these methods ..please help
query buildQuery()
{
QueryBuildDataSource qbdsBankAccountTable, qbdsBankAccountTrans;
Query query = new Query(queryStr(CashBook));
qbdsBankAccountTable = query.dataSourceTable(tableNum(BankAccountTable));
qbdsBankAccountTrans = query.dataSourceTable(tableNum(BankAccountTrans));
qbdsBankaccountTrans.addRange(fieldNum(BankAccountTrans, TransDate)).value(queryRange(fromDate, toDate));
//Bank Code
BankAcc = con2Str(BankAccCon);
if(BankAcc)
{
BankAcc = strReplace(BankAcc,';',',');
qbdsBankAccountTable.addRange(fieldNum(BankAccountTable, AccountID)).value(BankAcc);
}
return query;
}
public boolean getFromDialog()
{
boolean ret = super();
fromDate = dfFromDate.value();
toDate = dfToDate.value();
//Bank Account
if (multiBankAccCtrl)
{
BankAccCon = multiBankAccCtrl.getSelectedFieldValues();
}
return ret;
}
///
/// dialog
///
/// dialogLocal
Object dialog()
{
#file
DialogRunbase dialogLocal ;
dialogLocal = super();
dfFromDate = dialogLocal.addFieldValue(extendedTypeStr(FromDate), fromDate,"@SYS5209");
dfToDate = dialogLocal.addFieldValue(extendedTypeStr(ToDate), toDate,"@SYS14656");
fbscMultiBankAcc = dialogLocal.curFormGroup().addControl(FormControlType::String, 'Bank Account');
fbscMultiBankAcc.label('Bank Account');
return dialogLocal;
}
///
/// DialogPostRun
///
/// Dialog
public void dialogPostRun(DialogRunbase dialog)
{
FormRun formRun;
super(dialog);
formRun = dialog.dialogForm().formRun();
if (formRun)
{
//Bank Account
fscMultiBankAcc = formRun.design().control(fbscMultiBankAcc.id());
multiBankAccCtrl = SysLookupMultiSelectCtrl::construct(formRun, fscMultiBankAcc, querystr(OABCashBookBankAcc));
}
}
I have the same question (0)
All responses (
Answers (
