1,048
Hi Experts,
I have some 15 columns in the form grid among that i wanted to get the user filter data for 1 columns (I can get active data of grid using execute query method of data Source), Ex:-
In the above screen if user filtered transaction code as 'APP'. I wanted to get value 'APP' based on that i need to calculation for amount. If user filtered any other column amount should be remain same. Can anyone help me on this ?
Regards
Guru
*This post is locked for comments
Thank you Rustem Galiamov and
ievgen Miroshnikov for help !
Hi Guruprasanna M,
It's a very strange requirement and I would recommend you to rethink it, however, if you want to get your value you can use next code:
Share
Report
All responses (
Answers (
QueryBuildDataSource qbds = myTable_ds.queryRun().query().dataSourceTable(tableNum(MyTable));
QueryBuildRange qbr = qbds.findRange(fieldNum(MyTable, MyField));
if (qbr)
{
info(qbr .value());
}
Hi guruprasanna!
This is how to get filter values:
Query query = InventTable_ds.queryRun().query();
QueryFilter queryFilter;
int i;
for (i = 1; i <= query.queryFilterCount(); i++)
{
queryFilter = query.queryFilter(i);
info(strFmt("%1: %2", queryFilter.field(), queryFilter.value()));
}
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156