Skip to main content
zainabm725105
New Participant
Feb 4, 2025 4:19 PM UTC
Solved

How can I access the db for a record type?

I am trying to make a field unique by following these instructions - (source : 24.3 24.3 Case Mgmt Studio (CMS) Common Customization and Configuration Guidance)

How can I navigate to the db table corresponding to CMGT_Agency? These are the options I see in source settings.

 

konduruc733182
Inspiring
Feb 4, 2025 5:31 PM UTC

Hello [mention:5c5c5502a55d401cadc6903ccf717e3c:e9ed411860ed4f2ba0265705b8793d05] 

Do you have access to Cloud Database in the Navigation pane? If yes, go to the cloud database and select the schema (If theres only one might be with the name APPIAN) and in the search box you can search your record name. It would return the generated database table for CMGT_Agency record.

3 replies

konduruc733182
Inspiring
Feb 4, 2025 5:31 PM UTC

Hello [mention:5c5c5502a55d401cadc6903ccf717e3c:e9ed411860ed4f2ba0265705b8793d05] 

Do you have access to Cloud Database in the Navigation pane? If yes, go to the cloud database and select the schema (If theres only one might be with the name APPIAN) and in the search box you can search your record name. It would return the generated database table for CMGT_Agency record.

zainabm725105
New Participant
Feb 4, 2025 5:45 PM UTC

That worked! Thank you Chaitanya

varuntejg243705
Inspiring
Feb 4, 2025 6:36 PM UTC

Hi [mention:5c5c5502a55d401cadc6903ccf717e3c:e9ed411860ed4f2ba0265705b8793d05] ,

In order to make  the field unique, you need to navigate to the cloud database,It's visible in the waffle icon as shown in below image.

Please check if you have access to cloud Database.

Navigate to table, Structure and select the column and Hit on unique.