After hours or trying / researching I turn to you all for help with this apparently simple (yet - for me - elusive) Slice problem.
in the USER SETTINGS I have: Track (text) which can be A, B, C etc Activity (text) which can be Riffles, Archery, Rafting etc
in table SESSION_LIST I have: session_uid (text) set UNIQUE() track (text) as above activity (text) as above done (Yes/No)
I want to create a single View, using a Slice of SESSION_LIST that will EITHER
a. list matching rows by track - ie [_THISUSER].[Track] = [track]
OR
b. list matching rows activity - ie [_THISUSER].[Activity] = [activity]
Despite trying multiple way of creating the Slice, it is either empty or shows everything in SESSION_LIST. I’ve tried SELECT, IF, SWITCH, virtual columns … and now find myself so confused I don’t know which way is up.
Guidance, suggestions, other solutions very welcome.
You may want to elaborate what are the column types [Track] and [Activity] in the User Settings and the SESSION_LIST table?
You have mentioned those as text type. However could you elaborate exact implementation. For example, are the options A, B, C as text string or enum or enumlist options available for the user?
Assuming the user has selected “Group Chaperone”, they then proceed to set Group and Section, which returns their Track (the track must be selected, but there is only ever ONE Track shown).
Prompted by your questions, I took another look at my problem and realised I was mis-handling the Role column. I was treating it like a text field, but it’s a Yes/No field. Once I accounted for this, I soon got the following Slicer filter to work:
