Functional Analysis Tool

Account Management

Approved Notes

Query

SELECT id, object_type__vr.name__v FROM monitored_text__v WHERE (created_date__v > '{MIN_DATE}') AND (created_date__v <= '{MAX_DATE}')

Options:

Group By (comma-separated):

Consent Capture

Query

SELECT id, (SELECT country__vr.name__v FROM account__vr) FROM multichannel_consent__v WHERE (created_date__v > '{MIN_DATE}') AND (created_date__v <= '{MAX_DATE}')

Options:

Group By (comma-separated):

DCRs

Query

SELECT id, created_by__vr.country_code__v FROM data_change_request__v WHERE (created_date__v > '{MIN_DATE}') AND (created_date__v <= '{MAX_DATE}')

Options:

Group By (comma-separated):

Run Queries: EMEA

Vault Credentials