avniproject / jss-sickle-cell-screening

0 stars 0 forks source link

[JSCS UAT] Void duplicate concept used on UAT #75

Closed nupoorkhandelwal closed 11 months ago

nupoorkhandelwal commented 11 months ago

Reference report -

https://reporting.avniproject.org/question/1536-duplicate-concepts-in-a-form-production

Currently, there are two "Registration number" concepts getting used under "Lab results entry" form on UAT, we need to discard one.

Tech taks

vedfordev commented 11 months ago

Notes

from below query find out that we need to remove form elemet which has uuid = "35cc3efc-a0db-4350-82ca-e6d28e6772de" and display_order = 8

select fe.*
from form f
join form_element_group feg on f.id = feg.form_id
join form_element fe on feg.id = fe.form_element_group_id
where f.is_voided = false
and feg.is_voided = false
and fe.is_voided = false
and f.name = 'Lab results entry' and fe.name = 'Registration number'
order by fe.display_order
;
-- 010a16b9-e4d7-4e06-8d4b-a9132514a6ce