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.

All responses (5)

Answers (1)

Verified answer

Blue Wang on at

Like (0)

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

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))；
Vignesh R 535 on at

Like (0)

Report

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

Hi,

I got my solution using below using query

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

thanks for your help.
Blue Wang on at

Like (0)

Report

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

HI Vignesh,

Use strFmt().

queryBuildRange.value(strFmt('%1,%2', enum2str(ABC::A),enum2Str(ABC::B)));
Vignesh R 535 on at

Like (0)

Report

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

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

If use above code.
Blue Wang on at

Like (0)

Report

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

Hi Vignesh,

You can try to use

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

Community site session details

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

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

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

Ramesh Kumar – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates