Показать сообщение отдельно
Старый 27.07.2017, 05:26   #1  
Blog bot is offline
Blog bot
Участник
 
25,646 / 848 (80) +++++++
Регистрация: 28.10.2006
Malaysia: query.findQueryFilter to find parameter
Источник: http://axmas.blogspot.com/2017/07/qu...parameter.html
==============

In controller class:

protected container preRunValidate()
{
container ret;
QueryRun queryRun;
int cnt,i;
Query query = this.getFirstQuery();
QueryBuildRange range;
QueryBuildDataSource qbds;
str filter = "";

ret = super();

qbds = query.dataSourceTable(tablenum(SFA_MembershipTrans));
queryRun = new QueryRun(query);

if(query.findQueryFilter(qbds,"PaymMode"))
{
ret = [SrsReportPreRunState::Error, "Payment mode is not able to filter in this report"];
}

if(query.findQueryFilter(qbds,"AmountCur"))
{
ret = [SrsReportPreRunState::Error, "Amount Currency is not able to filter in this report"];
}

if(query.findQueryFilter(qbds,"AmountMST"))
{
ret = [SrsReportPreRunState::Error, "Amount is not able to filter in this report"];
}

return ret;
}

Источник: http://axmas.blogspot.com/2017/07/qu...parameter.html
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.