- 1 Posts
- 4 Views
Query Drilling URL
I'm a pretty advanced Query user but this one has me stumped. I'm trying to modify a drilling URL to add conditional logic which enables query result column to sometimes be an active drilldown link and other times not based on the criteria. Example my drilldown works correctly 'psp/EMPLOYEE/HRMS/q/?ICAction=ICQryNameURL=PUBLIC.EMP_LOC&BIND1=%A.PRODUCT%&BIND2=%A.PROGRAM_CODE%&BIND3=%A.OPERATING_UNIT%&BIND4=%A.LOCATION%:A.COUNT3' in that all results for my field A.COUNT3 are returned as a result value (like a TOTAL) which is also a hyperlink for the user to drill down to another query and get the detailed information. It has now come up that there are certain conditions where management does not want the user to be able to see the detail, aka turn the hyperlink off, for certain values but leave it on for others. Is anyone aware of how to code this in the Expression Text?