SearchKit API Calls

searchkit_activities_issue.json

{
  "version": 4,
  "select": [
    "id",
    "GROUP_CONCAT(DISTINCT Case_CaseContact_Contact_01.display_name) AS GROUP_CONCAT_Case_CaseContact_Contact_01_display_name",
    "subject",
    "GROUP_CONCAT(Case_CaseActivity_Activity_01.subject) AS GROUP_CONCAT_Case_CaseActivity_Activity_01_subject",
    "GROUP_CONCAT(Case_CaseContact_Contact_01.id) AS GROUP_CONCAT_Case_CaseContact_Contact_01_id",
    "GROUP_CONCAT(Case_CaseActivity_Activity_01.id) AS GROUP_CONCAT_Case_CaseActivity_Activity_01_id",
    "GROUP_CONCAT(DISTINCT Case_CaseActivity_Activity_01.Food_Discovery.Session_date) AS GROUP_CONCAT_Case_CaseActivity_Activity_01_Food_Discovery_Session_date"
  ],
  "orderBy": [],
  "where": [
    [
      "case_type_id:name",
      "=",
      "food_discovery"
    ]
  ],
  "groupBy": [
    "id"
  ],
  "join": [
    [
      "Contact AS Case_CaseContact_Contact_01",
      "LEFT",
      "CaseContact",
      [
        "id",
        "=",
        "Case_CaseContact_Contact_01.case_id"
      ]
    ],
    [
      "Activity AS Case_CaseActivity_Activity_01",
      "INNER",
      "CaseActivity",
      [
        "id",
        "=",
        "Case_CaseActivity_Activity_01.case_id"
      ],
      [
        "Case_CaseActivity_Activity_01.activity_type_id:name",
        "=",
        "\"Food Session Report\""
      ],
      [
        "Case_CaseActivity_Activity_01.subject",
        "IS NOT EMPTY"
      ]
    ]
  ],
  "having": []
}