Unique Retrieve from XPath or Database

1
I have an entity with an indexing attribute. I want to have a data grid or list view where the user sees the types of indexes. I cannot use an enumeration because the user needs to be able to create and manage the indices. A related question, is there a way retrieve from database by just writing an SQL query? 
asked
2 answers
6

Regarding your question about SQL queriers: you might want to have a look at OQL:

https://docs.mendix.com/refguide/oql

For external databases, the following might be of interest:

https://docs.mendix.com/howto/integration/how-to-execute-an-sql-statement-on-an-external-database

Regards,

Thorsten

answered
5

A possible solution would be to use an extra entity for your "Index" and associate the first one with it. You can choose the index you need via a refference selector, you can create new ones, delete old ones and show only your indices in a datagrid.

The benefit is also that you reduce redundancy.

answered