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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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