Plaza 365
Plaza 365

No results found for your search

RegisterLog in

2

Query/QueryRun with temporary tables (AX/F&O)

Visit article

#buffervariables

#datasources

#queryclasses

#queryrunclass

#temporarytables

Dynamics 365 Finance

Category

Oct 13, 2023

Published date

Text

Article Type

AI Summary

  • The article discusses the misconception that Query* classes cannot be used to query temporary tables in Microsoft business applications like Dynamics 365.
  • When working with temporary tables, it is important to use the right buffer or reference to a specific data set.
  • To query temporary tables with Query* classes, a query needs to be defined in the same way as with regular tables, and references to temporary data sets should be passed in the setCursor() or setRecord() method of the QueryRun class.
  • If the query involves multiple temporary tables, the setCursor() method can be called multiple times to find the data source for each table.
  • The setCursor() method also has an extra parameter (_occurrence) for handling multiple data sources for the same table.
  • The article provides a complete example using standard tables, demonstrating the steps involved in querying temporary tables, including inserting data, creating a query, passing temporary tables to a QueryRun object, running the query, and displaying the returned records.
  • The syntax used in the example is specific to F&O, but the overall approach is applicable to Dynamics AX as well.

Registered users can view the full text for FREE!

Sign In Now!

Cookies Consent

We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking "Accept All", you consent to our use of cookies.