Is there a way to add a virtual table to the REST Server

[Rohit_Nz (Gupta Rohit)]

I know, I can my own endpoints to the XDATA REST server. Is there a way to add a virtual or memory table to the Entities?

[wlandgraf (Wagner Landgraf)]

You can map views and any other database "entity" that behaves as table, just put the name of such object in the Table attribute of the Aurelius mapping. Of course, probably some capabilities will not be available, like data editing.

This was discussed in other topics like:

MSSQL View

You can map views just the way you map tables. Use the name of the view in the Table attribute and use it normally. Of course, you would not be able to update data using those entities, just read data. More references:

[Rohit_Nz (Gupta Rohit)]

I had thought of adding tables and removing write permissions, but I hadnt thought of views.

For the three I needed right away, I have added them on client side. They only had 2, 3 and 4 items, to be used in DBLookupComboBoxes as ListTable

[Monterisi_Stefano]

I think you can use a :memory: SQLite database for this porpouse.