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();
}

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Martin Dráb 237,882 Most Valuable Professional on at

Like (1)

Report
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(); }

Was this reply helpful? Yes No
faridz on at

Like (0)

Report

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

Was this reply helpful? Yes No

Join the conversation

Community site session details

Filtering Lookup Value

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Filtering Lookup Value

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates