Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

How to get Lookup in AOT query range field value in Inquiry form + AX 2012

(0) ShareShare
ReportReport
Posted on by 5,680

Hi all,

I have created one query in AOT and setting the range field for the same.

for e.g. Created query in AOT name 'AX_Query' data source is Vendtable table and set the range for 'AX_Query" ranges are Vendor Account, Currency see below screen shot,

Now, when using this query into Report the report parameter form having select button to set the ranges in report inquiry form.

like below screen shot.

after that, when clicking a vendor account field criteria to display all type of vendor in lookup,

In Standard scenario:

vendor account  criteria lookup value:

Accnum  - group

A001             10

A002             20

A00               30

but, my requirement is when clicking a vendor account field criteria to display only particular type of vendor in lookup.

My requirement vendor account criteria lookup value :(only vendor group 10)

Accnum   - group

A001              10

if this is possible in query inquiry form please let me know. I have struggling how to do it.

 

*This post is locked for comments

  • Suggested answer
    Luan Nguyen Profile Picture
    Luan Nguyen 689 on at
    RE: How to get Lookup in AOT query range field value in Inquiry form + AX 2012

    This is a simple way to get range for report, but in some case you can put fields above to parm and write lookup method for it

  • Karthik Desappan Profile Picture
    Karthik Desappan 5,680 on at
    RE: How to get Lookup in AOT query range field value in Inquiry form + AX 2012

    Hi ivan,

    I have using query and write some coding init method using query filter class but how we get lookup based one query range field from another.

    if u know anything abt query related filter criteria pla let me know......

  • Suggested answer
    RE: How to get Lookup in AOT query range field value in Inquiry form + AX 2012

    Well, as I said, it's software, so anything is possible. So yes, you can achieve through customization of larger scale.

    But I'd suggest that you add a field for specifying the vendor account directly on the report dialog. This way, you'll be able to easily override the lookup for it.

    Upd. Oops, took my bloody time replying :) You already have the same reply above... 

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 230,445 Most Valuable Professional on at
    RE: How to get Lookup in AOT query range field value in Inquiry form + AX 2012

    As Ivan already said, it would be possible with some customizations. But don't do that - instead, add a normal field to the report dialog.

  • Karthik Desappan Profile Picture
    Karthik Desappan 5,680 on at
    RE: How to get Lookup in AOT query range field value in Inquiry form + AX 2012

    Hi ivan,

    if this scenario simply possible or not?

  • RE: How to get Lookup in AOT query range field value in Inquiry form + AX 2012

    Without a number of customizations - you can't filter the looking values displayed in SysQueryForm.

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans