Refine Value List Selection List in Text Type User Prompt Filter
Hello,
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.
Hi Amulya,
Thanks for the clarification, as we discussed earlier this will not be possible, and judging by the response I received from the product team I am now hesitant to say it ever will be.
Sorry for the inconvenience here, and let me know if you have any questions!
Regards,
Nathan
Hi Amulya,
Thanks for the clarification, as we discussed earlier this will not be possible, and judging by the response I received from the product team I am now hesitant to say it ever will be.
Sorry for the inconvenience here, and let me know if you have any questions!
Regards,
Nathan
Hi Amulya,
Using a WHERE clause in a custom query filter should be possible. If you are not having luck, it might be worth trying to use the WHERE clause in a nested SELECT such as:
If you are not able to get this to work, it would be helpful if you could tell me what version and build you are using (this can be found in the system information section of the admin console). Please let me know if you have any luck with this.
Regards,
Nathan
Hi Amulya,
Using a WHERE clause in a custom query filter should be possible. If you are not having luck, it might be worth trying to use the WHERE clause in a nested SELECT such as:
If you are not able to get this to work, it would be helpful if you could tell me what version and build you are using (this can be found in the system information section of the admin console). Please let me know if you have any luck with this.
Regards,
Nathan
Hi Amulya,
After speaking with the product team it seems that the only way to achieve this will be to use a filter hierarchy with date part formatters so:
Year: 2017, 16, etc
Month: March April
Field to have limited results
Unfortunately the only way to limit the filter result set in the near future will be through a filter hierarchy, so hopefully this is applicable to your needs.
Let me know if you have any questions here!
Regards,
Nathan
Hi Amulya,
After speaking with the product team it seems that the only way to achieve this will be to use a filter hierarchy with date part formatters so:
Year: 2017, 16, etc
Month: March April
Field to have limited results
Unfortunately the only way to limit the filter result set in the near future will be through a filter hierarchy, so hopefully this is applicable to your needs.
Let me know if you have any questions here!
Regards,
Nathan
Hi Amulya,
I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!
Regards,
Nathan
Hi Amulya,
I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!
Regards,
Nathan
Replies have been locked on this page!