web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX query not showing i...
Microsoft Dynamics AX (Archived)

AX query not showing in VS query list

(0) ShareShare
ReportReport
Posted on by bankk 6,611

Hello. I created a simple AX query in the AOT, but when I'm in Visual Studio and under the dataset node of a report, I'm not able to see the AX query in the listing for that dataset. I'm able to see the query on the Application explorer panel in VS but when I go to select the query under the dataset node it's not listed as an option. I've tried refreshes and restores in VS and AX with no help. Thanks very much!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ali Zaidi Profile Picture
    Ali Zaidi 4,657 on at

    This occurs when some error exists in Query, possible you relate wrong column of table to wrong column of joined table or you did not save the query, red highlighted line under the Query name indicate that changes are not saved. You have to compile the query by right clicking on it to find what wrong in it. If this problem remains then possible Incremental CIL did not generated from long time at your machine. You have to compile AOT and resolve possible errors. then generate Increment CIL..

  • bankk Profile Picture
    bankk 6,611 on at

    Hi Ali. I tried recompiling, running the incremental CIL, restore. Nothing seemed to have worked.

    I also created a job to run the query and write the records out to the infolog with a count, and the query seems to be fine. I modified the query to only use a single table with a very simple range. I ran the job again and the query is working as anticipated. Again, within VS I can see the query under the Application explorer. It's just when I go to set the query on the dataset I'm not able to see the query on the list.

    Any additional thoughts would be appreciated. Thank you!

  • dolee Profile Picture
    dolee 11,279 on at

    Hi,

    Do you have multiple AOSes installed on the same machine?

    Regards

  • Ali Zaidi Profile Picture
    Ali Zaidi 4,657 on at

    Hi KBANH. Possible then you select wrong data Source type while creating DataSet in Report. when you add source for DataSet please varify that you select the AX Query in data source provider.

  • bankk Profile Picture
    bankk 6,611 on at

    Dolee, no the there are not multiple AOS instances running on the same VM.

  • bankk Profile Picture
    bankk 6,611 on at

    Ali, I've double-checked the source settings several times. Data source = Dynamics AX; Data source type = Query. I can see custom AX Queries which were built for other functions, just not the one I recently developed. Thanks.

  • Vasily Profile Picture
    Vasily 25 on at

    Hi,

    do you have correct WSDL port setup and actual WCF config in Business Connector configuration?

    Regards,

    Vasily

  • Verified answer
    bankk Profile Picture
    bankk 6,611 on at

    Hi Vasily, I discovered what my issue was.

    My development environment is not static so I use configuration files to connect to different instances. Although I was using the correct AXC file to connect me to my testing environment in VS (because I was able to see my query in the Application explorer panel), I didn't realize the dataset was picking up on the default configuration of my development environment, which was pointed to another instance. This doesn't answer all my questions but once I pointed the default config to my test environment I was able to see the my query. I'll not forget this lesson soon! :D

  • Vasily Profile Picture
    Vasily 25 on at

    That's right, Visual Studio use Business Connector configuration from registry.

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#2
TAHER Mehdi Profile Picture

TAHER Mehdi 3

#3
Nakul Profile Picture

Nakul 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans