Open
Description
Context
currently "stored queries" (as used by our OpenSearch functionality) are stored very simply as json on the filesystem. this is functional, but will accumulate over time and needs better architecture.
Requirements
The current proposed solution:
- move to a proper java class that is persisted in the database instead
- have a creation timestamp, to allow removal of queries that are "old enough" to be expired/deleted
- all proposed properties: id, created, indexName, creator, query (mirrors current file-based queries)
- background process to remove expired queries
Technical note
this also allows for possible later development of user-ownership and "named" queries for more permanent storage