Whenever I try to use select query in column I am getting error, how to use condition in mentioned query
Question
Lobby Column using select query
+7
I have found, to date, that i can only use select count(*) or sum - or use an api method to get a single value.It would be very powerful if IFS could find a way for calculated columns to have an alias and then be able to reference that for the same row - but in another column. In your example you are explicitly defining a field name in the select a.Price which i think is the issue. Can you get Price from api or maybe use sum - so you get the value if you supply the right key and only a single value exist then that might work..
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.