dear my friend
i want to show top one record in dialog query , but there is no option to create that .
i created manual fetch xml and save it as a view . it will work in entity view . but it will change in advanced find or dialog fetch xml .
what is the solution.
this is my fetch xml:
<fetch version="1.0" top="1" >
<entity name="kphacc_voucher" >
<attribute name="kphacc_serial" />
<attribute name="createdon" />
<order attribute="createdon" descending="true" />
<filter type="and" >
<condition attribute="statecode" operator="eq" value="0" />
</filter>
<attribute name="kphacc_calculatediffrence" />
<attribute name="kphacc_subcode" />
<attribute name="kphacc_turning" />
<attribute name="kphacc_totalcredit" />
<attribute name="kphacc_totaldebit" />
<attribute name="kphacc_description" />
<attribute name="kphacc_voucherid" />
</entity>
</fetch>
and i saved it as view . it work fine.
in dialog i select the view . but it will change the query .
the dialog preview:
i have the same problem in advanced search
what is the solution . i need different query like this to use in dialog .
*This post is locked for comments