Hi hoping someone can shed some light on why this is not working for me. I have a custom query for a notificaiton system of alerts of unread events. It all works pretty much now, and my sql works in workbench, and, i can get it to work in SC customer query tool, if i hand code the IN operators in…

What about join and then split by comma?

where is the join operation, i dont see it in the 'text' menu? thanks

Wait, can you see this first? Sounds similar: [image] GET array for use with IN clause of custom query action How To Hi All, Having trouble today with getting an array passed into a custom query action IN clause. For testing I have tried hard-coding the numbers, which y…

yeah i found that as well I actually think, in custom query it wants the brackets around the :P2 in my example, I just did that and it appears to be working, but, its quite hard to test so testing now lol this is a simplified version of the sane sql just doing a count select count(`Notification…

take that back, i am getting same results as that link you sent, only taking the first value i think in the IN operator, as in workbench i get a count of 4 and in wappler a count of 1, with same sql, as workbench uses the IN (A,E,C) and dont think wappler is somehow

will give this a whirl {{delivery.join(",", "COLUMN_NAME_HERE").split(",")}} as @teador posted this on a thread, just to work out how to put that into my code working out what the variable is in that code, i think delivery anyway, will try but goes back to your initial resposne to join (which i …

cant work out quite what to put where in that string {{$_GET.permission.join(",", "`Notifications`.`TargetPermission`").split(",")}} $_GET.permission is my inbound variable string Notifications.TargetPemission is the column i am checking the IN again any thoughts

You can't use IN in operator custom queries like this, with dynamic number of parameters, this is only used in regular database query builder. That's already explained in a few topics, for example: https://community.wappler.io/t/get-array-for-use-with-in-clause-of-custom-query-action/11928/17

Blast. Not sure how else I can get the data set I need as I need a variable on the left join, I don't suppose there are any good tutorials on here of an alert/notification system like top right on this forum, which if what I have to get built. But notifications can be target to groups of users, whe…

[image] JamesJenkins: what I send from the front to sc is a string that can be A or E or C or A,E ,C or E,C Maybe you can re-think your logic. You can create an array server list with this. Using a repeat, for each element add it to the array. Then you can create a simple query and use the…

Custom query IN operator and array error

Wappler General Need Help

franse May 20, 2024, 6:05pm 4

Wait, can you see this first?
Sounds similar: