Folks,
Help me please!!!
I'm development Report in the support area using BIDs Dynamics CRM.... but not filtered statecode value of the incident entity.
i'm using FetchXML for the filter:
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false"> <entity name="queueitem"> <attribute name="objecttypecode" />
<attribute name="objectid" />
<order attribute="objecttypecode" descending="true" />
<link-entity name="incident" from="incidentid" to="objectid" alias="a_cf79ac6ed0e243f8b4514bbf0554999c"> <attribute name="subjectid" /> <attribute name="prioritycode" />
<attribute name="title" />
<attribute name="statuscode" />
<attribute name="ticketnumber" />
<attribute name="createdon" />
<attribute name="customerid" />
<attribute name="statecode" />
<filter type="and">
<filter type="or"> <condition attribute="subjectid" operator="eq" uiname="Dynamics 365" uitype="subject" value="{FA23C363-06B7-E611-80FC-5065F38A2901}" />
<condition attribute="subjectid" operator="eq" uiname="Dynamics CRM" uitype="subject" value="{0EA4A751-9BD8-E411-80F3-FC15B4289E3C}" />
</filter> <filter type="or">
<condition attribute="statecode" operator="eq" value="0" />
<condition attribute="statecode" operator="eq" value="1" />
</filter>
<condition attribute="createdon" operator="this-month" />
<condition attribute="customeridname" operator="not-like" value="%AX4B%" />
</filter>
</link-entity>
</entity>
</fetch>
i'm development one expression for filtered the statecode equals "1", but nothing:
=Count(Fields!a_cf79ac6ed0e243f8b4514bbf0554999c_statuscodeValue.Value = 1)
Next i using iif in the expression, but nothing:
=Count(IIf(Fields!a_cf79ac6ed0e243f8b4514bbf0554999c_statuscodeValue.Value = 1, 1, nothing))
How i have filtered incident for statecode?
