How to include "NULL" object in query or filter
![]()
I am in RPE 1.2.11
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
![]()
If you are doing this though Filter Editor in RPE, you can check "XHTML Input" option and then use
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...
wouldnt you use name instead of resolution?
and I tried it and it still didnt work
i tried up loading a pic but i dont have a high enough reputation which is stupid... here is a dropbox link
Yes. That is what I meant. Now could you please try these?
im kinda lost now...
what url should i use?
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
Ok so here is my issue now with this...
-<workItem><id>23656</id></workItem>-
<workItem><id>23657</id>-
<resolution>
<id>amdws.workflow.defect.resolution.r7</id>
<name>Govt Do Not Fix</name>
</resolution>
</workItem>
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.
showing 5 of 6
show 1 more comments
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.