obsolete.ChilliProject/test/fixtures/queries.yml

---
queries_001:
  id: 1
  project_id: 1
  is_public: true
  name: Multiple custom fields query
  filters: |
    ---
    cf_1:
      :values:
      - MySQL
      :operator: "="
    status_id:
      :values:
      - "1"
      :operator: o
    cf_2:
      :values:
      - "125"
      :operator: "="

  user_id: 1
  column_names:
queries_002:
  id: 2
  project_id: 1
  is_public: false
  name: Private query for cookbook
  filters: |
    ---
    tracker_id:
      :values:
      - "3"
      :operator: "="
    status_id:
      :values:
      - "1"
      :operator: o

  user_id: 3
  column_names:
queries_003:
  id: 3
  project_id:
  is_public: false
  name: Private query for all projects
  filters: |
    ---
    tracker_id:
      :values:
      - "3"
      :operator: "="

  user_id: 3
  column_names:
queries_004:
  id: 4
  project_id:
  is_public: true
  name: Public query for all projects
  filters: |
    ---
    tracker_id:
      :values:
      - "3"
      :operator: "="

  user_id: 2
  column_names:
queries_005:
  id: 5
  project_id:
  is_public: true
  name: Open issues by priority and tracker
  filters: |
    ---
    status_id:
      :values:
      - "1"
      :operator: o

  user_id: 1
  column_names:
  sort_criteria: |
    ---
    - - priority
      - desc
    - - tracker
      - asc
queries_006:
  id: 6
  project_id:
  is_public: true
  name: Open issues grouped by tracker
  filters: |
    ---
    status_id:
      :values:
      - "1"
      :operator: o

  user_id: 1
  column_names:
  group_by: tracker
  sort_criteria: |
    ---
    - - priority
      - desc
queries_007:
  id: 7
  project_id: 2
  is_public: true
  name: Public query for project 2
  filters: |
    ---
    tracker_id:
      :values:
      - "3"
      :operator: "="

  user_id: 2
  column_names:
queries_008:
  id: 8
  project_id: 2
  is_public: false
  name: Private query for project 2
  filters: |
    ---
    tracker_id:
      :values:
      - "3"
      :operator: "="

  user_id: 2
  column_names:
queries_009:
  id: 9
  project_id:
  is_public: true
  name: Open issues grouped by list custom field
  filters: |
    ---
    status_id:
      :values:
      - "1"
      :operator: o

  user_id: 1
  column_names:
  group_by: cf_1
  sort_criteria: |
    ---
    - - priority
      - desc