How to include "NULL" object in query or filter
I am doing a query and or filter on “Resolution” field
If the state is in a specific type the resolution field shows as a “-“ meaning nothing is set.
Example:
if the workitem is in a state of submitted there is no resolution...
when you look at the results from a query the resolution field shows a "-"
If you look at the oslc the resolution field is completely blank
How do I include those that are blank in a filter? Basically include null?
ive tried resolution/name != "Withdrawn" (this returns all the items that match that except the ones that are null...
Or, can you generate a javascript to query it?
One answer
resolution == "<o:p> </o:p>"
The XHTML value for the attribute selected will be returned when you check this option.
Comments
EDIT: I just realized that this put in the <o:p> part...
Yes. That is what I meant. Now could you please try these?
1. Right click on the datasource and select Preview data, provide the URL and check what value is returned by REST API (make sure if it is "<o:p> </o:p>") (Or do a GET for the data source URL and check what value is returned)
2. Click "Test script" and make sure that your condition evaluates to true
im kinda lost now...
REST URL - Something like https://server:9443/ccm/rpt/repository/workitem
ok so i FINALLY figured out how to do that.. wow that will save alot of time LOL
Notice how 23656 doesn't have an id?
I hope you were able to do what you were looking for. You can also use javascript / string length function to check if len > 0 or not.