Can we use Temporary table in query?

(0) Share

Report

Posted on by Govinda Kumar

2,300 Moderator

So, I have created a query and used it in a temporary table to view the filtered record, but then I want to use that temporary table in my other query to use it as a data Item.

That uerAllocateInvoiceListView is a temporary table and data is inserted in that table whenever I open the page.

When I'm using that table in the query I get the error. "A query cannot process data from more than one database (data source). This includes queries for data in the both application database and the business database, even if the current deployment is not multitenant."

Is there any other way to solve my problem?

The requirement is to use filtered query records and use it in another query to filter more records from tables.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

DAnny3211 11,382 on at

Like (0)

Report

RE: Can we use Temporary table in query?

Hi

temporary tables can only be used in Reports, XmlPort or in the codeunit

learn.microsoft.com/.../devenv-temporary-tables

Greetings

DAniele

Was this reply helpful? Yes No