Functional Analysis Tool

Query Configuration (YAML)

Paste your YAML configuration below.

client_name: "Galderma"

# Tokens that apply to ALL queries (e.g., Date ranges, Schema names)
global_tokens:
  - "START_DATE"
  - "END_DATE"

sections:
  - title: "Account Management"
    # A list of subsections, each with its own subtitle and queries
    subsections:
      - subtitle: "Approved Notes"
        queries:
          - name: "Query"
            sql: "SELECT id, object_type__vr.name__v FROM monitored_text__v WHERE (created_date__v > '{START_DATE}') AND (created_date__v <= '{END_DATE}')"

- subtitle: "Consent Capture"
        queries:
          - name: "Query"
            sql: "SELECT id, (SELECT country__vr.name__v FROM account__vr) FROM multichannel_consent__v WHERE (created_date__v > '{START_DATE}') AND (created_date__v <= '{END_DATE}')"
            # Tokens specific only to this query
            group_by: "account__vr.country__vr.name__v"

- subtitle: "DCRs"
        queries:
          - name: "Query"
            sql: "SELECT id, created_by__vr.country_code__v FROM data_change_request__v WHERE (created_date__v > '{START_DATE}') AND (created_date__v <= '{END_DATE}')"
            # Tokens specific only to this query
            group_by: "created_by__vr.country_code__v"

Configuration: EMEA