Firestore integration: How to query by field

21

UPDATE
This worked out after I created the object as text in request structure and used formula to set value {“stringValue”: “query”}
END UPDATE

If you are using where clause in runQuery with two fields - say one a stringValue and other a booleanValue. Since its the object with different properties at indexes o and 1 respectively, how can this me managed? As you suggested, I can keep the value (within where) as an object without properties. What formula should be used to map the values. This is the structure of my input request that works.

{
“structuredQuery”: {
“from”: [
{
“collectionId”: “UserContent”
}
],
“where”: {
“compositeFilter”: {
“filters”: [
{
“fieldFilter”: {
“field”: {
“fieldPath”: “contentType”
},
“op”: “EQUAL”,
“value”: {
“stringValue”: “query”
}
}
},
{
“fieldFilter”: {
“field”: {
“fieldPath”: “contentShow”
},
“op”: “EQUAL”,
“value”: {
“booleanValue”: true ---------> here the object property changes from string to boolean
}
}
}
],
“op”: “AND”
}
},
“orderBy”: [
{
“field”: {
“fieldPath”: “createdAt”
},
“direction”: “DESCENDING”
}
],
“limit”: 3
}
}

22

@Eduardo_Jaramillo Not sure if your still active in appgyver. But let me try my luck.

I’ve been trying to figure out how to run firestore db queries for a while now and I dont seem to arrive at a solution by my own, anytime soon. So a little help will go a long way for me.

This is my problem:
I’m able to acheive until the part where I see the response for the POST request. But I’m totally blank as to how I should bind the response to a data variable such that I can use it with the ‘repeat with’ property

What am I trying to do?
I’m trying to query firestore db for a collection named ‘users’ in the field ‘name’ for the value ‘Stacey’.
The request is a post request and returns a list of documents in the response. I want to be able to display all the users under the name of ‘Stacey’ using the ‘repeat with’ property

:))