Dot-walking to Request Item Variable in Interactive Filter for Dashboard
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-19-2019 10:46 AM
I'm trying to create an Interactive Filter that allows sorting on a dot-walked column in a list report on a dashboard. The dot-walked column is a Variable on a catalog item [Variables --> (item name) --> (item variable name)]. When creating the interactive filter, it only allows me to hit the sc_req_item table columns, not the columns of individual SC items. Any ideas? Thanks!
- Labels:
-
Dashboard
-
Performance Analytics
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-20-2019 12:40 AM
It might be not possible this way. I guess you want to see values of variables and the way you are trying you will see variables definitions.
I would suggest to use sc_item_option_mtom table for variables and from there you can go to sc_req_item and using conditions display or filter what is required.
