any words are there to replace 'IN' keyword in sql to x++

(0) Share

Report

Posted on by Community Member

Hi,

while select test where test.name in ('ashok','karthik')
    { 
        info(strFmt("%1 - %2",test.name,test.age));
    }

how to use 'in' keyword in x or how to give condition in where like above mentioned.

I have the same question (0)

All responses (13)

Answers (1)

WillWU 22,361 on at

Like (0)

Report

Hi Ashokkumar,

Please try this:

while select test where test.name =='ashok' || test.name =='karthik'.

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

Hariharans87 3 on at

Like (0)

Report

In X++ there is no "IN" logical operator. You can use || (or) operator.

Available relational operators

docs.microsoft.com/.../relational-operators

while select test

where (test.name == 'ashok' ||

test.name == 'karthik')

{

info(strFmt("%1 - %2",test.name,test.age));

}

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

'in' operator is supported in F&O (with slightly different syntax), but it doesn't exist in older versions of AX.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Hariharan S,

Thanks for your response but each time give buffer.field, has it any alternative?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Will WU

Thanks for your response but each time give buffer.field, has it any alternative?

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report

No. That is X++ syntax.

Was this reply helpful? Yes No
Martin Dráb 237,948 Most Valuable Professional on at

Like (0)

Report

Can you explain your business scenario, please?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Martin,

Thanks for your response it's just for know, In case in my future , i will use it.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

The solution still depends on what you want to achieve - there is no universal answer for all possible situations.

Most likely you should use Query* classes, although there is an option to use field IDs in select statements (you can obtain an ID as runtime), e.g. buffer.(fieldId) == "value".

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
while select test where test.name in ('ashok','karthik','yogi','martin','kumar',....)

i want to achieve is for example a table has a 50 records it has name field but i want only particularly 20 records only it depends on name, that 20 names i will above mentioned like that.

any possible is there

Was this reply helpful? Yes No