2 Replies Latest reply on Dec 18, 2013 10:31 AM by ChrisJohnston

    Need to see empty?

    ChrisJohnston

      Title

      Need to see empty?

      Post

      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:


      SUBJECT::splatform =

      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.


      
      IsEmpty(PROBLEM::platform);
      
      @vl;
      
      

        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?