Share
Report
2,310So, 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.
All responses (
Answers (
