Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

need custom query in dialog

Posted on by 485

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:

2705.1.PNG

0247.2.PNG

i have the same problem in advanced search

4861.5.png

what is the solution . i need different query like this to use in dialog .

*This post is locked for comments

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans