64
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,
VK
So smart of you Mariano.
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
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.
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.
#1
André Arnaud de Cal...
291,602
Super User 2024 Season 2
#2
Martin Dráb
230,340
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
