Answered

Is there an equivalent of SQL Views in PowerPages to view data across multiple tables?

(0) Share

Report

Posted on by MJWhite

338

In SQL server, it is possible to use Views to collate data from two, three or more related tables i.e. in a chain of one to many relationships and can then create a calculated field which contains data from all the tables. Is there an equivalent in PowerPages using Dataverse?

The Views in PowerPages seem to just manipulate data in a single table. There is the option to look up to a single related table, but it doesn't seem capable of looking up across a chain of related tables?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

oliver.rodrigues 9,461 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Using Dataverse views you can only see the primary table + parent tables data.

If you need something more advanced, you will need to build your query using WebAPI or Fetch and to a custom render of the results

Was this reply helpful? Yes No
MJWhite 338 on at

Like (0)

Report
Copy link

Link copied!

Thanks. This stops me looking for an easy solution that isn't there. Plus, I now know where to go for the more complex solution.

Was this reply helpful? Yes No