Refine Value List Selection List in Text Type User Prompt Filter
On a Freehand SQL Report, I'm trying to make it easy for my end users to only have the option of selecting employees who were actually active between specified date ranges (Date ranges can be selected using another User Prompt Filter).
When trying to use a Custom Query under Value List Selection, I can only write a SELECT query which would return a single column of ALL the employees. Not the ones actually active between the date ranges specified since I cannot enter a WHERE clause here (See attached image). Basically, I'm unable to link the Employee UPF with the Date UPF's
I can make the list refined in the Freehand SQL code but I don't want the end user selecting from a list of ALL employees when they aren't even going to be on the report based on the service date ranges entered. I hope you can see the disconnect. How do I solve this? Is this feature possible at all in Yellowfin? Thank you.