Let’s say I have this DB schema:
{
"version": 2,
"data": {
"region.region": {
"1": {
"id": 1,
"Name": "AZ"
},
"2": {
"id": 2,
"Name": "Default"
},
"3": {
"id": 3,
"Name": "Default"
}
},
"tenant.tenant": {
"1": {
"id": 1,
"name": "Brand A"
},
"2": {
"id": 2,
"name": "Brand B"
},
"3": {
"id": 3,
"name": "Brand C"
},
"4": {
"id": 4,
"name": "Brand D"
}
},
"api::privacy.privacy": {
"1": {
"id": 1,
"Text": "Dolor sit amet",
"createdAt": "2023-11-10T22:44:14.627Z",
"updatedAt": "2024-01-31T00:37:14.787Z",
"publishedAt": "2024-01-26T22:12:38.289Z",
"Tenant": 1,
"Region": 1,
"createdBy": null,
"updatedBy": null
},
"2": {
"id": 2,
"Text": "Dolor sit amet",
"createdAt": "2023-11-10T22:46:16.517Z",
"updatedAt": "2024-01-31T00:36:00.243Z",
"publishedAt": "2023-11-10T23:26:55.648Z",
"Tenant": 2,
"Region": 2,
"createdBy": null,
"updatedBy": null
},
"3": {
"id": 3,
"Text": "Dolor sit amet",
"createdAt": "2024-01-30T22:32:49.466Z",
"updatedAt": "2024-01-31T00:33:57.536Z",
"publishedAt": "2024-01-30T22:33:15.559Z",
"Tenant": 3,
"Region": 3,
"createdBy": null,
"updatedBy": null
}
}
}
}
I would like to be able to query for one of these privacy documents by passing filters for both the tenant and region components associated with that particular privacy document. Each privacy doc will be required to have one of these chosen.
I’m able to get the populate with filtering to work, however, it’s still returning all of the other privacy documents.
What I’d like is for the API to only return that one privacy document that matches with those particular filters I passed in.
This is the example I have used that returns all privacy documents:
const query = qs.stringify(
{
populate: {
Tenant: {
filters: {
name: {
$eq: "Brand A",
},
},
},
Region: {
filters: {
name: {
$eq: "AZ",
},
},
},
},
},
{
encodeValuesOnly: true, // prettify URL
}
);
Is this achievable?