Functional Analysis Tool

Version 3 Saved on: 2026-03-10 12:27:33 UTC

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"

Version 2 Saved on: 2026-03-10 12:08:34 UTC

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 > '{END_DATE}') AND (created_date__v <= '{START_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 > '{END_DATE}') AND (created_date__v <= '{START_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 > '{END_DATE}') AND (created_date__v <= '{START_DATE}')"
            # Tokens specific only to this query
            group_by: "created_by__vr.country_code__v"

Version 1 Saved on: 2026-03-10 12:01:27 UTC

client_name: "Galderma"

# Tokens that apply to ALL queries (e.g., Date ranges, Schema names)
global_tokens:
  - "MAX_DATE"
  - "MIN_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 > '{MIN_DATE}') AND (created_date__v <= '{MAX_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 > '{MIN_DATE}') AND (created_date__v <= '{MAX_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 > '{MIN_DATE}') AND (created_date__v <= '{MAX_DATE}')"
            # Tokens specific only to this query
            group_by: "created_by__vr.country_code__v"

Version History: Galderma - EMEA