Finance | Project Operations, Human Resources, ...

Can we create an entity from View

(0) Share

Report

Posted on by vicky1234

Hi,

I have a view which is having query as datasource. ( the query is bit complicated).

Now the requirement is that to have the view as a entity.

I think it is not possible to expose a view as an Odata feed /entity.

However I would like to check if it is a possibility or an alternative to this ?

Thanks,

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Komi Siabi 13,093 Most Valuable Professional on at

Like (0)

Report

Hi VK,

Just like you said, you can not see Views as datasource while creating data entities.

You should consider using composite entities where you can bring in multiple entities.

docs.microsoft.com/.../develop-composite-data-entities

Was this reply helpful? Yes No
vicky1234 66 on at

Like (0)

Report

Thanks for your reply.

Actually what I want to understand is that is there a way to expose a complicated query/viewas a datasouce in an entity so that it can be used as read-only entity.

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Do you get any error if you actually try it? Note that you shouldn't give up if it's not supported by the wizard - it still may be possible if you do it manually.

Was this reply helpful? Yes No
Mariano Gracia on at

Like (1)

Report

I have done many entities wich uses views as datasource, as Martin says the wizard will complain because the view doesn't have a primary key, but what I usually do is to create the entity using the wizard an a simple standard table, choose the fields from the primary key to be added to the entity, name the entity as per your convenience, once the wizard creates all the objects change the datasource of the created entity with the view, upgrade the entity key and add the fields you need, finally upgrade the staging table. Of course, what you get is a read only entity as you're using a view, but you can still use it for OData query purposes, of for BYOD

Was this reply helpful? Yes No
Komi Siabi 13,093 Most Valuable Professional on at

Like (1)

Report

So smart of you Mariano.

Was this reply helpful? Yes No