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.

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings