how to filter results by a boolean field in a record.
![Bzarbo](https://us.v-cdn.net/6037124/uploads/userpics/ANWFA6VG4S8O/n5N84C0DZM916.jpg)
I have about 8000 records and among other fields or keys they each have a boolean field that says "isEnabled" with a true or false. I am trying to simply query all records and then return the records where the "isEnabled" is "false".
Thanks in adavnce!
Best Answer
-
You can always use the 'or' argument. You can have two (or more) constraints :)
Answers
-
In your query, you would set up an argument so that it looks at the table's column of isEnabled. You would want this to == false.
-
Thank you for the answer so this bring what the next problem is for me because technically your answer is correct however I already have a query where I am filtering by name.
How do I have another option where I can filter by name or boolean? would that require me to make a new API endpoint for just the boolean? I think this is where I am getting lost.
Categories
- All Categories
- 53 ? Announcements
- 47 ? Releases
- 37 ? Welcome
- 983 ? Help! I'm a Noob
- 125 ? No-Code Front-Ends
- 633 ? Working with APIs
- 439 ? Transforming data
- 126 ? Connect Xano to ...
- 50 ?? Find an Expert
- 348 ❓Other questions
- 35 ? Security
- 22 ✂️ Snippets
- 19 ? Showcase
- 7 ?️ Xano Chatter
- 62 ? Video Tutorials
- 171 ? Request a feature
- 229 ? Report a Bug
- 19 ? Templates & Extensions
- 7 ? Feedback