You’re offline. This is a read only version of the page.
70
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?
*This post is locked for comments
Hello Rasmus,
Thank you for information.
I really not had attention in the fields rsrs
Hello,
I can't really help with the technical parts of your expressions, but I notice that you seem to be using "statecode" and "statuscode" interchangably even though they are two different fields with different values. Are you writing the value of the "statecode" field to a variable called "statuscodeValue"? If not, this could be the source to your problems.
(Edited for clarification)
Regards,
Rasmus
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (