pc
5 posts
Registered:
22 Oct 2015
29 Oct 2015
Link to this post
I have a CRM lookup field looks like the xml code below, it is working great currently.
I would like to add an additional condition, gm_expirydate >= today's date.
I am not sure how to do it. Could someone please help?
<fetch output-format="xml-platform" no-lock="true" version="1.0" mapping="logical">
<entity name="gm_qsp">
<attribute name="gm_vendor"/>
<attribute name="gm_name"/>
<attribute name="gm_qspid"/>
<attribute name="gm_effectivedate"/>
<attribute name="gm_expirydate"/>
<attribute name="gm_program"/>
<order descending="false" attribute="gm_vendor"/>
<filter type="and">
<condition value="BDE0BF26-176C-E411-80D6-00155D14C906" operator="eq" attribute="gm_program"/>
</filter>
<link-entity alias="" to="gm_vendor" from="new_vendorid" name="new_vendor">
<filter type="and">
<condition value="1" operator="eq" attribute="gm_approved"/>
</filter>
</link-entity>
</entity>
</fetch>