Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Extension of a query in AX 365

Posted on by 11,873

An extension for a query is created to add extra data source to it.

I build the project &  reset usage data then run the class ,the new added data source does not appear , what should I do reflect this update ?

*This post is locked for comments

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 230,214 Most Valuable Professional on at
    RE: Extension of a query in AX 365

    It seems that you should have told us that you modified PayrollStatementGenerationQuery (explaining what exact changes you made could be useful too) and now you don't see your new datasource in the selection for filter, when you run Payroll > Pay statement processing > Generate pay statement. Please make sure you provide such a description next time.

    Most likely you're looking at previously saved query, therefore you should delete it from usage data. Go to User options, press Usage data, switch to All usage data and delete records with Element name = PayrollPayStarementGeneration (which is the class which is called when you click Generate pay statement).

  • maram fraij Profile Picture
    maram fraij 11,873 on at
    RE: Extension of a query in AX 365

    I mean the new added data source does not appear in the area Records to include below.

    also when I press filter  marked below to add the data source , I cannot find it to be added as per the second screenshot.

    1348.Untitled2.gif

    1348.Untitled2.gif

  • Martin Dráb Profile Picture
    Martin Dráb 230,214 Most Valuable Professional on at
    RE: Extension of a query in AX 365

    Sorry, but it still didn't tell me anything. Where are you "clicking"? Did you use the query in a form or something?

    Please realize that we can't help you if you don't explain your problem. Start again and explain what you're doing. Invest five minutes or so to do it and don't be afraid of using multiple sentences and screenshots.

  • maram fraij Profile Picture
    maram fraij 11,873 on at
    RE: Extension of a query in AX 365

    I need to do filter on an field in this new added datasource so when filter is clicked this datasource  does not appear in the list of available datasources

  • Martin Dráb Profile Picture
    Martin Dráb 230,214 Most Valuable Professional on at
    RE: Extension of a query in AX 365

    Could you please elaborate what you mean by "the new added data source does not appear"?

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans