BuildShipBBuildShip
Powered by
Schpouet'S
BuildShip•2y ago•
8 replies
Schpouet'

Firestore Collection Query with multiple filters : Value for argument "value" is not a valid ...

I would like to filter collection with multiple filters 😄

"Value for argument "value" is not a valid query constraint. Cannot use "undefined" as a Firestore value. If you want to ignore undefined values, enable
ignoreUndefinedProperties
ignoreUndefinedProperties
."
image.png
image.png
image.png
Solution
Hi @Link, the
object validation
object validation
node's result here will be false (you can confirm by clicking the green arrow icon). As in
Body
Body
you are giving an Object but it only accepts and validates object. Due to which in the second node
Firestore Collection Query
Firestore Collection Query
, the value you are referencing from body is breaking (
invalid
invalid
),

To fix this, either pass the body as a valid object.

{
  "type": "House",
  "hidden": false
}
{
  "type": "House",
  "hidden": false
}


Or remove the object validation node, and reference it in the filter's value as
(x)Body[0].type
(x)Body[0].type
note: array's are always accessed by their index through dot notation.
Jump to solution
BuildShip banner
BuildShipJoin
Join founders, builders, devs using Low-code / No-code to create backend, APIs, scheduled Jobs, automation, AI workflows
7,971Members
Resources
Recent Announcements

Similar Threads

Was this page helpful?

Similar Threads

Firestore Collection Query with multiple filter : "Value is not a valid query constraint ..."
Answer OverflowAAnswer Overflow / ❓・buildship-help
2y ago
Buildship: Firestore Collection Query error
certified dirtiboiCcertified dirtiboi / ❓・buildship-help
3y ago
Using Firestore Collection Query Output in OpenAI Assistant Prompt
Al_BAAl_B / ❓・buildship-help
2y ago
Errors using Firestore Collection Query as a function of OpenAI Assistant
Al_BAAl_B / ❓・buildship-help
2y ago