Symptom

If fields within the Logger are consistently populated with the same value, it can be extremely time-consuming having to re-input this each time. It is possible to set up metadata to be persistent making it readily available for re-entry.

Resolution

In order to achieve this, database alterations are required. Please consult your local DB administrator or contact IPV Support if you are unsure of any of the below:

In essence, "hasPersist" has to be added to the necessary rows of the CuratorDB Metadataviews table. The difficulty here, however, is that the setting is in the ui_schema column for which there is not a GUI editor.

For example, if you wanted the Playoff metadata name to be persistent, you would need to find the name_id within the metadatanames table. Once you have the ID(s), you then need to find the corresponding entry in the metadataviewcolumns that matches those IDs.

SELECT * FROM curatordb.metadataviewcolumns WHERE name_ID in (5202, 5203);

After analysing the column ui_schema shown. In this example it needs to be changed to:

{"type": "buttons", "multiSelect": false, "minHeight": "50px", "loadLocal": true, "columns": "6", "sortOptions":{"direction": "asc"}, "isFieldTab": true, “hasPersist”: true }

It’s worth checking the current string in the field to ensure that the other settings, such as minHeight, are the same, the double quotes are also important. Typically the only difference will be the very last part, “hasPersist”: true }

To update the row(s), use the following statement, changing the name_ID and other ui_schema settings where appropriate.

UPDATE curatordb.metadataviewcolumns
SET ui_schema = '{\"type\": \"buttons\", \"multiSelect\": false, \"minHeight\": \"50px\", \"loadLocal\": true, \"columns\": \"6\", \"sortOptions\": {\"direction\": \"asc\"}, \"isFieldTab\": true, \"hasPersist\": true }'
WHERE name_ID in (5202, 5203);

Related

For information on setting up cache of previously entered free text, please refer to the following article: Setting cache of entered free text in Curator Logger