Its been more than a month since I had new post. Here goes. 🙂
I had a peculiar situation wherein for a particular PS Query, there were 3 bind variables. One of these three was mandatory and the rest had to run taking into consideration all values of that field. There might be multiple ways to do it, but this is what I came up with.
A.FIELDNAME = NVL(LTRIM(:1,''),A.FIELDNAME)
:1 is the bind variable. In the event of a value not being provided for :1, the query would run taking all values of A.FIELDNAME. Otherwise, it would run with just the prompt value.
Have fun 🙂