Support on “Not In” query syntaxis

[Cesar_Cotom]

Scenario,

1. I’m writing a query on an assign activity with the following syntaxis: dtData.Select(“GRA =‘F25320001’ AND Balance > 0 AND Receiving =’ Confirmed ’ AND [Offsetting Entity] NOT IN (‘LD10469’,‘LD10577’,‘LD10588’)”).CopyToDataTable
   And the result is correct.

2. My challenge begins when I created a variable vQuery as String with the dynamic values “‘LD10469’,‘LD10577’,‘LD10588’”

3. The Not In Query is now wrote as the following: dtData.Select(“GRA =‘F25320001’ AND Balance > 0 AND Receiving =’ Confirmed ’ AND [Offsetting Entity] NOT IN ('”+vQuery+“')”).CopyToDataTable

The application is showing the error: Missing operand after ‘LD10469’ operator.

I have tried with different variations but I’m not able to replicate the correct syntaxis, any advice is welcome.

Cesar

[beesheep (Eduardo Bernabe Sacahui Diaz)]

@Cesar_Cotom

• “‘LD10469’,‘LD10577’,‘LD10588’”

Hola @Cesar_Cotom

–Step 2-- I can see that you are creating the values = “‘LD10469’,‘LD10577’,‘LD10588’”

Look that you already have the ’

–Step 3 –
…NOT IN (’”+vQuery+“’)”).CopyToDataTable <===== You already have a ’ it looks like this ‘“‘LD10469’**Tres comillas

That is why is saying that an operand is missing because the editor is expecting an operand when you close the apostrophe.

---

If this answer your question please mark as solved, don´t forget to like our answer.

Happy Automation
Regards,

edit: typo

[Cesar_Cotom]

Thanks for the advice,

Problem solved

[beesheep (Eduardo Bernabe Sacahui Diaz)]

Your Welcome.
De Nada

Happy Automation
Eduardo Sacahui