By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Generic Inquiries & Pivot Tables
2
Posts
2
Users
0
Reactions
1,050
Views
December 17, 2020 6:42 am
Greetings 🙂
I am trying to take advantage of the IN logic, and I have met this problem.
The idea is that I am going to gather all unique values in a certain column into a variable. Then I am going to check if a certain value excist in the variable.
Example: Variable $X consisting of concatenated numbers with () around = (1, 4, 5, 7, 11)
Why does ('5' In ($X)) return False, when ('5' In (1, 4, 5, 7, 11)) returns True just fine?
1 Reply
March 15, 2021 4:18 am
My recommendation would be to check the Trace to see what SQL is being generated. I haven't done much with In, but I think it might be intended for Workgroups and the Company Tree (I could be wrong on that).
Online Members
