Need to see empty?
I have as a portal in my SUBJECT table that comes from my PROBLEMS table. I have a value list called Platform that consists of:
All PC Mac Linux
When I create a PROBLEM record it shows up in the portal. I then created a way to filter the portal by PROBLEM::platform so I create a field and set it up like so:
Let ([ @vl = ValueListItems(Get(FileName); "Platform")]; Case ( SUBJECT::xplatform = "All"; @vl; SUBJECT::xplatform ) )
so in SUBJECT I have a field that (s_platform) that I set up a relationship to like this
pk = fk splatform = platform
to filter I set the global (SUBJECT::xplatform)to use a dropdown list. The filter works as long as the members of problem have a PROBLEM::platform set(by dropdown). How come I cannot seem to find a way to see members of PROBLEM if there is nothing set yet in PROBLEM::platform. I have tried to add to my case statement various form of trapping for an “Empty” value of PROBLEM::platform. I have tried things like add the lines.
to my Case statement. I can’t seem to get to include what I am calling a “” empty as a something I will make visible in portal. I want when I choose "All" that any value shows up in the portal even if empty. What concept am I not understanding here?