Sunday, 17 April 2016

in-fiscal-period - FetchXML Query

The following example shows a FetchXML expression that finds all orders fulfilled in period three of any fiscal year, according to the organization’s fiscal year settings. The fiscal period value is specified in the value attribute of the condition tag. If the organization uses fiscal months, the query returns results from month three. If the organization uses fiscal quarters, the query returns results from quarter three. If the organization uses fiscal semesters, no results are returned; there are only two semesters, and the value supplied is therefore out-of-range.
  1. <fetch>
  2. <entity name="order">
  3. <attribute name="name"/>
  4. <filter type="and">
  5. <condition attribute="datefulfilled" operator="in-fiscal-period" value="3"/>
  6. </filter>
  7. </entity>
  8. </fetch>
Explanation
To create in-fiscal-period FetchXML query:
  • In condition attribute set operator keyword to in-fiscal-period.
    <condition attribute="datefulfilled" operator="in-fiscal-period" value="3"/>
    
  • Specify value of fiscal period in value attribute of condition tag.
- See more at: http://msxrmtools.com/fetchxml/reference

No comments:

Post a Comment