Message rule not working because of multiple concepts have the key value "contact_number:yes" present.

[Gojo-Taqi]

Support ticket - https://avni.freshdesk.com/a/tickets/2518

Tasks

• To fix the issue, have only one concept which stores the user's phone/contact number.
• Which ever concept is removed, the respectful data will have to be migrated as well.

[nupoorkhandelwal]

select * from (
SELECT  name,jsonb_array_elements(key_values) AS elem
FROM concept) data
WHERE elem->>'key' = 'contact_number'   AND elem->>'value' = 'yes';

-- LAHI Intern Registration >> Contact Information >> Intern WhatsApp Number >> Student contact number -- Student Registration >> Details >> Contact number >> Student contact number