Home > Forum > Rules, JS, SQL > How to exctract the form fileds with marked personal data?

How to exctract the form fileds with marked personal data?
0

Hi i have a task to extract formfields from all the applications that has like this makred. Can anybody help? would be much appreciated

Hi,
you can try with this SQL command executed on BPS Content database:

SELECT WFCON_ID, WFCON_Prompt, WFCON_DEFID, DEF_Name
FROM [WFConfigurations]
LEFT JOIN WFDefinitions on WFCON_DEFID = DEF_ID
WHERE WFCON_PersonalDataType = '1'

You may need to adjust the query based on your requirements. This one will return FIeld ID, Field name, ID of Workflow and it's name.

Best.