Where the multi-select control data is stored in the database?

Dear Iman,

Thank you for letting us know your questions.

To access the data of a multi-select control, you would need to verify the entity attribute it is being that is populating it. This entity attribute should be a many-to-many collection in a table and its information can be accessed through these relationships between attributes.

It is not possible to access the data directly in the SQL server because it is stored in an intermediate table not registered in ATTRIB or ENTITY (since it is not necessary for the evaluation of xpaths relevant to the other two tables). So, the relationships in entities are the only way to access the data from those tables.

Now, in general, you should not be needing to access that information unless you are trying to make a query directly to the database which we do not recommend as it goes against our security best practices. So, be mindful of that.

We hope this helps to answer your question.

Best regards,

Laura G

Dear Laura,

Thank you for your answer. We need to have a report of some data including the data stored in a multi-select control. So there is no way to access it via SQL Server?

Dear Iman,

Then, again, you would need to look for the collections that populate the multi-select. For more information on this, please read the following article: https://help.bizagi.com/bpm-suite/en/index.html?multi-select.htm