Hello guys, first post here!
So, I just want to filter my query using the values returned by the variable $client, using the [Builder]. How can I achieved that?
I can do it using the [code], as simple as writing “company in ($client)” …
there are a couple of ways to format variables depending on how you want to use them inline…
Also click on Query Inspector and see what the Builder created for you
On the Query Inspector, I can see that the values are passing correctly (between comma and single quotes) but is placing an extra quote at the start/end of the statement. How to avoid that?
Now show us the data generated by the variable, in the variable configuration itself
change Company IN ('$client') to Company IN ($client)
That works, as I said at the begining, if I write the querie directly on the [code].
I want to use it on [Builder].
might be a bug you might want to post in github. not sure though why people want to use the Builder.