Open-Assistant icon indicating copy to clipboard operation
Open-Assistant copied to clipboard

task_labels table updates are redundant for certain user behaviour

Open melvinebenezer opened this issue 1 year ago • 1 comments

An update from the frontend /api/set_label updates the task_labels table (Postgres DB) in the backend. multiple clicks to report a messages creates that many entries in the DB

User reports one tag Screenshot 2023-01-08 at 12 17 58 PM

User selects another tag and reports Screenshot 2023-01-08 at 12 18 09 PM

The updates in the DB Screenshot 2023-01-08 at 12 11 48 PM

Is this an acceptable behaviour ? Concern is while retrieving the flags from the DB after data collection. The SQL script writer should ensure that the most check flags are retrieved

Solution:

Update the labels for existing message_ids in text_labels table

melvinebenezer avatar Jan 08 '23 06:01 melvinebenezer