Hi
Requirement: Modify all portal forms where hidden field 'Team' = 'DevOps' to another field value
I'm new to DB queries and have been able to run some basic queries in the AO_54307E tables such as
AO_54307E_VIEWPORTFIELD
AO_54307E_VIEWPORTFIELDVALUE
AO_54307E_VIEWPORTFORM
Field ID
13759
Option ID
13200
I'm so far unable to get a complete list of all portal form names where the field ID above is using the option ID above.
My workaround has been to just use a dashboard to find all issues raised where Team = DevOps, but I'm quite sure we have double the forms where the value is hidden vs how many tickets have been raised.
DB type = Postgres
Thanks