Database tips

On this page you can find tips for working with the Any2Info databases

Form content

All the data from filled forms is stored in the Any2Info database. The data is stored in the FRMMessage_<FormDefinitionId> tables. These tables are dynamically generated when a FormDefinition is saved in the platform. When a field is added to a FormDefinition, the backend service adds a column to the corresponding table. When a field is deleted, the column is not removed from the table to prevent accidental data loss. The FormMessage table contains column which use the internal fieldId as name, to make live a bit easier we also generate a view for each FormMessage table using the naming convertion vw_FRMMessage_<FormDefinitionId>. In these views the column use the names of the fields.

Usefull database functions

GetValueBetweenQuotes

This function can be used to extract selected list, tree and state values from the columns

example usage

SELECT sysId, dbo.GetValueBetweenQuotes(lsList1) AS ListId FROM vw_FRMMessage_1