Filtering Lookup Value

(0) Share

Report

Posted on by faridz

Hello,

I want to lookup field Name where the IsTemplate value is only true, can anyone help me?

Should i using addRange or something?

Here's my code :

public void lookup()
{
    Query                   query = new Query();
    QueryBuildDataSource    queryBuildDataSource;
    QueryBuildRange         queryBuildRange;
    SysTableLookup          sysTableLookup = SysTableLookup::newParameters(tableNum(Hierarchy), this);
    ;

    queryBuildDataSource = query.addDataSource(tableNum(Hierarchy));

    sysTableLookup.addLookupfield(fieldNum(Hierarchy, Name),true);
    sysTableLookup.addLookupfield(fieldNum(Hierarchy, Description));

    queryBuildRange = queryBuildDataSource.addRange(fieldNum(Hierarchy, IsTemplate));

    sysTableLookup.parmQuery(query);
    sysTableLookup.performFormLookup();
}

All responses (2)

Answers (1)

faridz on at

Like (0)

Report

RE: Filtering Lookup Value

Thank you so much Martin it's solved now , sorry for late reply.
Verified answer

Martin Dráb 230,214 Most Valuable Professional on at

Like (1)

Report
RE: Filtering Lookup Value

You're almost done - you just need to set the value of your query range:

public void lookup() { Query query = new Query(); QueryBuildDataSource queryBuildDataSource = query.addDataSource(tableNum(Hierarchy)); QueryBuildRange isTemplateRange; SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(Hierarchy), this); sysTableLookup.addLookupField(fieldNum(Hierarchy, Name),true); sysTableLookup.addLookupField(fieldNum(Hierarchy, Description)); isTemplateRange = queryBuildDataSource.addRange(fieldNum(Hierarchy, IsTemplate)); isTemplateRange.value(queryValue(NoYes::Yes)); sysTableLookup.parmQuery(query); sysTableLookup.performFormLookup(); }