Hi colleagues,
I'm trying to apply an interactive filter that would filter the results based on the answer to a question on a cat item variable (belonging to a variable set, to make it more fun;)
So we have a number of catalog items with Variable Set A, which contains the Department variable. It's a reference field to the cmn_department table.
The reports on the dashboard are built on the sc_req_item table and I'd like to find requests applicable to specific departments.
I've done multiple attempts but the one I consider closest to the expected solution is to build the interactive filter on the cmn_department table. I'm getting the values I'd like to filter on.
The trouble comes when I need to map it in the Interactive Filter References.
I've tried sc_item_option and sc_item_option_mtom but can't find the correct reference.
I expected to see Variables[+] in the sc_req_item table and then dot walk but Variables[+] are not on the list.
Any ideas are very welcome.
