I had few case which didnt had origin field value ,so it was not working, once i deleted all the blank origin case then it was showing all data bydefault.
i had added this xml query for excluding null value , but still if there is any row which has doesnt contain origin then data is not shown in report . not sure why after adding the below condtion still it is not showing all bydefault even if any origin has blank data.
[ <condition attribute="cs_origin" operator="not-in">]
<fetch distinct="false" mapping="logical" output-format="xml-platform" version="1.0">
<entity name="incident">
<attribute name="title"/>
<attribute name="ticketnumber"/>
<attribute name="createdon"/>
<attribute name="incidentid"/>
<attribute name="caseorigincode"/>
<attribute name="cs_origin"/>
<order descending="false" attribute="title"/>
<filter type="and">
<condition attribute="cs_origin" operator="not-in">
<value uitype="cs_origin" uiname="KR"></value>
</condition>
<condition attribute="cs_origin" operator="not-null"/>
<condition attribute="statecode" operator="ne" value="2"/>
</filter>
</entity>
</fetch>
