filter a lookup field

(0) Share

Report

Posted on by Gautam

3,945

hi
one grid is there in my form , i have added a lookup method in one of the field of my grid and now i want to add filter on that very lookup method , and one thing more the filter should be based on two parameter .
i know how to add filter in lookup with one parameter , i have got this material from this site
http://ashokkancheti.blogspot.in/2014/03/x-code-to-filter-lookup-field-on-form.html
but i need to add filter in lookup method with two or more parameters. so tell me what should i do

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Sohaib Cheema 49,664 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

you have to create one more object for QueryBuildRange qbr;

and define filter/range for 2nd parameter also. Add 1 more range as you did 1st range.

Was this reply helpful? Yes No
Gautam 3,945 on at

Like (0)

Report
Copy link

Link copied!

Thanks Man ..its working now

Was this reply helpful? Yes No
Suggested answer

Mallika Roy 552 on at

Like (0)

Report
Copy link

Link copied!

Hi Gautam,

this can help you :

Query query;

QueryBuildDataSource qbds;

QueryBuildRange qbr,qbr1;

SysTableLookup lookup;

query = new Query();

qbds = query.addDataSource(tableNum(XXXTable));

qbr = qbds.addRange(fieldNum(XXXTable,YYYField));

qbr.value(queryvalue(_value1));

qbr1 = qbds.addRange(fieldNum(XXXTable,ZZZField));

qbr.value(queryvalue(_value2));

lookup

=SysTableLookup::newParameters(tableNum(XXXTable),_callingControl,true);

lookup.parmQuery(query);

lookup.addLookupField(fieldNum(XXXTable,YYYField));

lookup.performFormLookup();

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Why my filter lookup query is looping? How to fix it?

Was this reply helpful? Yes No