Thread Discussion

# label: "Cases with Filters"
# description: "Filter cases by name"
# $offset = {{ request.query_dict.offset || 0 }}
# $limit = {{ request.query_dict.limit || 20 }}
# $sort = [{{ request.query_dict.sort || '"hs_lastmodifieddate__asc"' }}]
# $search = "{{ request.query_dict.search || '' }}"
# $search_number = "{{ request.query_dict.search_number || '' }}"
# $search_parties = "{{ request.query_dict.search_parties || '' }}"

query cases_query(
	$offset: Int,
	$limit: Int,
	$sort: [crm_p_cmlist_order_by],
	$search: String,
	$search_number: String,
	$search_parties: String
) {
  CRM {
    p_cmlist_collection(
      limit: $limit 
      offset: $offset
      orderBy: $sort
      filter: {
		case_number__contains: $search_number, 
		case_name__contains: $search, 
		case_name__not_null: "true", 
		case_parties__contains: $search_parties
	  }
    ) {
      hasMore
      total
      offset
      limit
      items {
        case_name
        case_number
        case_parties
        case_type
        case_type_select
        court_address
        court_applicant
        court_house
        court_list_number
        court_location
        court_location_select
        court_name
        court_name_select
        court_respondent
        court_room
        hs_object_id
		hs_lastmodifieddate
        is_new
        judge
        jurisdiction
        profile_slug
        slug
        submission_idempotent_id
        associations {
          p_profiles_collection__court_master_list_to_profile {
            items {
              hs_object_id
              slug
              full_name
            }
          }
        }
      }
    }
  }
}