[details=“System Information”]
- Strapi Version- Starpi V4:
- Operating System - Windows 10:
- Database- Mysql:
- Node Version - v14.15.1:
- NPM Version-7.5.3:
I want to populate a data with filteration. I have two content-types
- Deal
- User
Relationship : User has many deals (one to many)
I want to have number of deals created by a particular user.
MY Example JSON Data, this I am getting by calling API : http://localhost:1337/api/deals?populate=user
{
"id": 1,
"attributes": {
"dealTitle": "Musical Instrument",
"dealDescription": "20% off on guitars",
"dealActualPrice": 5000,
"dealDealPrice": 4000,
"dealDate": "2022-01-10T21:45:00.000Z",
"dealStartTime": "2022-01-11T18:30:00.000Z",
"dealEndTime": "2022-01-12T18:30:00.000Z",
"country": "India",
"stateVal": "Chhattishgarh",
"address": "abc aprtments",
"address2": "unit 3 ",
"city": "Raipur",
"zipcode": "490010",
"createdAt": "2022-01-11T07:47:30.138Z",
"updatedAt": "2022-01-11T07:47:31.763Z",
"publishedAt": "2022-01-11T07:47:31.751Z",
"user": {
"data": {
"id": 1,
"attributes": {
"username": "Joe123",
"email": "joe123@com.com",
"provider": "local",
"confirmed": true,
"blocked": false,
"createdAt": "2022-01-11T07:48:59.125Z",
"updatedAt": "2022-01-11T07:52:27.478Z",
"phone": "7896541230",
"country": "India",
"stateVal": "Chandigarh",
"address": "abc apartment",
"address2": "unit 2",
"city": "Raipur",
"zipcode": "491001"
}
}
}
}
}
To filter it in relationship level I used API URL as : http://localhost:1337/api/deals?populate[user][filters][username][$eq]=Joe123,
I’m getting all the deals with user data as null :-
{
"id": 4,
"attributes": {
"dealTitle": "Glass Shop",
"dealDescription": "GLass sheet at 40% flat discount. ",
"dealActualPrice": 5500,
"dealDealPrice": 3300,
"dealDate": "2022-01-04T10:23:16.000Z",
"dealStartTime": "2021-12-07T09:30:00.000Z",
"dealEndTime": "2022-01-11T14:48:00.000Z",
"country": null,
"stateVal": null,
"address": null,
"address2": null,
"city": null,
"zipcode": null,
"createdAt": "2022-01-11T09:24:43.127Z",
"updatedAt": "2022-01-11T09:24:43.127Z",
"publishedAt": "2022-01-11T09:24:43.124Z",
"user": {
"data": null
}
}
}
My expected Output is : number of deals created by user=“Joe123”
Please help 
