I have a process model (SAIL) that contains several filters. One of the filters

helmuta over 9 years ago

I have a process model (SAIL) that contains several filters. One of the filters is use to select a project status. Project status can be set as Pending Scheduling;In-Flight;Complete;On Hold;Cancelled. When a new item is entered is has a project status of either NULL or Blank (not sure why the difference). When I first open my dashboard I want to display all requests where the project value is not Complete. The problem I am running into is that I can get all requests to show in my dashboard except for the ones that are NULL. The second problem is that my filter drop down will not allow me to filter on a status of blank.

I have tried reversing the logic on my query rule and bring back all requests that did not equal Complete. It worked great except when I want to use the same query for bringing back all requests with a project status of In-Flight. Then it brings back all requests except for those In-Flight.

Send any ideas and thoughts my wa...

Discussion posts and replies are publicly visible

0 helmuta over 9 years ago

...y, please!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 JEAN PIERRE over 9 years ago

Initialize always your status variables to a valid state (not null).
Make a further classification of your states according to the attached image.
Make 2 facets:
1. (Pending Scheduling, In flight, Complete, On Hold, Cancelled)
2. Open, Closed
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 vikask over 9 years ago

For your first issue, you should get all requests including NULL. First check whether you are getting datset including null or not. If you are reciving then see how you are rendering. May be you are excluding NULL records while displaying on gridcolumn.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 helmuta over 9 years ago

Thank you for your suggestions. As always I can count on the people using this forum for ideas and suggestions.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel