Guys, I'm trying to query a date field like this: ...
# community-helpr
Rodrigo Paiva
04/05/2022, 9:24 PMGuys, I'm trying to query a date field like this: birthDate:>=165964833 && birthDate:<=797116833
And I get the error "Error with filter field `birthDate`: Not an int64."
Am I missing something here? My field is:
{
"facet": false,
"index": true,
"name": "birthDate",
"optional": true,
"type": "int64"
},
j
Jason Bosco
04/05/2022, 9:40 PM@Rodrigo Paiva Could you share the full code snippet or curl command for the search request?
r
Rodrigo Paiva
04/05/2022, 9:41 PMHey Json, I just figured, that, for some reason, my application is producing an invalid timestamp. Gonna have a look and get back to you. Thanks!
👍 1
Rodrigo Paiva
04/05/2022, 10:27 PMI'm trying to find all records by filter criteria
Copy code
{
"q": "*",
"query_by": "name",
"snippet_threshold": 100,
"include_fields": "name,username,dateCreated,languages,profiles.2a63de7be9b4.engagementPoints,profiles.2a63de7be9b4.statusText,profiles.2a63de7be9b4.platformObjects,profiles.2a63de7be9b4.publicSettings.favoriteCategories",
"filter_by": "birthDate:<=165968662,profiles.2a63de7be9b4.publicSettings.acceptRequests:= true,profiles.2a63de7be9b4.communityId:= 95f0d208-24a7-4c3b-bd87-2a63de7be9b4"
}Rodrigo Paiva
04/05/2022, 10:28 PMStill keep having the error with a valid timestamp
Error with filter field `birthDate`: Not an int64.
j
Jason Bosco
04/05/2022, 10:29 PMI'm assuming you want to AND all the field conditions. If so you want to use
&&,Jason Bosco
04/05/2022, 10:29 PMThe current filter string with
,Jason Bosco
04/05/2022, 10:30 PMSo
"filter_by": "birthDate:<=165968662 && profiles.2a63de7be9b4.publicSettings.acceptRequests:= true && profiles.2a63de7be9b4.communityId:= 95f0d208-24a7-4c3b-bd87-2a63de7be9b4"r
Rodrigo Paiva
04/05/2022, 10:30 PMoh, so && is also valid for different fields? I was in doubt because the docs are not clear about it, I thought I'd use && only for the same field
➕ 1
Rodrigo Paiva
04/05/2022, 10:30 PMWill try it like this, thanks!
j
Jason Bosco
04/05/2022, 10:32 PMThis is documented under "Multiple Conditions:" in the
filter_byr
Rodrigo Paiva
04/05/2022, 10:33 PMoh, indeed! I think I missed the first example num_employees:>100 && country: [USA, UK]
Thanks again
👍 1
Rodrigo Paiva
04/05/2022, 10:48 PMit worked like a charm 🙌
🙌 1