Custom query multiple variables

Struggling with the variables in a custom query.

When I use ONE variable (:P1) it works fine, but as soon as I include another one (:P2) it does not provide a result.

To illustrate, this is my query:


The above works well. But as soon as I replace UserID = 1 with UserID = :P2, it doesn’t work.

I searched the forum but couldn’t find any answers. What am I doing wrong?

Community Page
Last updated: