How to pass two enum values in Query filter using x++

(0) Share

Report

Posted on by Vignesh R

535

Hi All,

How to pass two enum value into query filter using x++?

For e.g: In PO, we have status (Open order, invoiced, received). I want to see only invoiced and received. if i click one check box, it has to show only "Received"&"invoiced" status.

For this, i need to pass two enum values instead on passing string value to filter the same.

Help me here if anyone knows.

I have the same question (0)

All responses (5)

Answers (1)

Blue Wang on at

Like (0)

Report

Hi Vignesh,

You can try to use

queryBuildRange.value(enum2str(XX::Received),enum2str(XX::Invoiced));

Was this reply helpful? Yes No
Vignesh R 535 on at

Like (0)

Report

I'm getting an error(The wrong number of arguments has been specified for the function.)

If use above code.

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

HI Vignesh,

Use strFmt().

queryBuildRange.value(strFmt('%1,%2', enum2str(ABC::A),enum2Str(ABC::B)));

Was this reply helpful? Yes No
Vignesh R 535 on at

Like (0)

Report

Hi,

I got my solution using below using query

queryBuildRange.value(Global::queryRangeConcat(enum2str(xx::Received), enum2str(xx::Invoiced)));

thanks for your help.

Was this reply helpful? Yes No
Verified answer

Blue Wang on at

Like (0)

Report
HI Vignesh,

If you use Global::queryRangeConcat.

I think it should like:

queryBuildRange.value(Global::queryRangeConcat(queryValue(enum2str(xx::Received), enum2str(xx::Invoiced))));

OR

queryRangeConcat(SysQuery::value(xx::Received), SysQuery::value(xx::Invoiced))；

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to pass two enum values in Query filter using x++

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

How to pass two enum values in Query filter using x++

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