Query API Sandbox

@Alex Wong
Hey thanks for the response! What I meant was that I explicitly approved two gift batches that I created through the API and webview. However, I was not able to retrieve results when filtering by batch number for either gift batch. The strange thing is that when I execute the same adhoc query but filter by a batch number for an approved batch that I did not create, I get results. I have also tested the same adhoc query in our production environment and was able to pull gifts for an approved batch.

@Alex Wong
Yup, I tried the webview and was able to pull the expected records. I also executed a query by ID

using the id of the query that I created in the webview, which also returned the correct results.

I also noticed that when I execute an adhoc query without any filters, I receive a large list of gifts that excludes the ones from the batches I created.

If it helps, here is the body of my adhoc query request:
{output_format: "Json", formatting_mode: "UI", ux_mode: "Asynchronous", query: {type_id: 20, select_fields: [{query_field_id: 539}, {query_field_id: 5994}], filter_fields: [{query_field_id: 5994, filter_values: [MY_BATCH_NUMBER], operator: "Equals", left_parenthesis: false, right_parenthesis: false, compare_type: "None"}]}})

@Alex Wong
That did the trick! Thank you. I was missing the constituent_filters.