Xano Documentation
  • 👋Welcome to Xano!
  • 🌟Frequently Asked Questions
  • 🔐Security & Compliance (Trust Center)
  • 🙏Feature Requests
  • 💔Known Issues
  • Before You Begin
    • Using These Docs
    • Where should I start?
    • Set Up a Free Xano Account
    • Key Concepts
    • The Development Life Cycle
    • Navigating Xano
    • Plans & Pricing
  • The Database
    • Designing your Database
    • Database Basics
      • Using the Xano Database
      • Field Types
      • Relationships
      • Database Views
      • Export and Sharing
      • Data Sources
    • Migrating your Data
      • Airtable to Xano
      • Supabase to Xano
      • CSV Import & Export
    • Database Performance and Maintenance
      • Storage
      • Indexing
      • Maintenance
      • Schema Versioning
  • 🛠️The Function Stack
    • Building with Visual Development
      • APIs
        • Swagger (OpenAPI Documentation)
      • Custom Functions
        • Async Functions
      • Background Tasks
      • Triggers
      • Middleware
      • Configuring Expressions
      • Working with Data
    • Functions
      • AI Tools
      • Database Requests
        • Query All Records
          • External Filtering Examples
        • Get Record
        • Add Record
        • Edit Record
        • Add or Edit Record
        • Patch Record
        • Delete Record
        • Bulk Operations
        • Database Transaction
        • External Database Query
        • Direct Database Query
        • Get Database Schema
      • Data Manipulation
        • Create Variable
        • Update Variable
        • Conditional
        • Switch
        • Loops
        • Math
        • Arrays
        • Objects
        • Text
      • Security
      • APIs & Lambdas
        • Realtime Functions
        • External API Request
        • Lambda Functions
      • Data Caching (Redis)
      • Custom Functions
      • Utility Functions
      • File Storage
      • Cloud Services
    • Filters
      • Manipulation
      • Math
      • Timestamp
      • Text
      • Array
      • Transform
      • Conversion
      • Comparison
      • Security
    • Data Types
      • Text
      • Expression
      • Array
      • Object
      • Integer
      • Decimal
      • Boolean
      • Timestamp
      • Null
    • Environment Variables
    • Additional Features
      • Response Caching
  • Testing and Debugging
    • Testing and Debugging Function Stacks
    • Unit Tests
    • Test Suites
  • CI/CD
  • File Storage
    • File Storage in Xano
    • Private File Storage
  • Realtime
    • Realtime in Xano
    • Channel Permissions
    • Realtime in Webflow
  • Maintenance, Monitoring, and Logging
    • Statement Explorer
    • Request History
    • Instance Dashboard
      • Memory Usage
  • Building Backend Features
    • User Authentication & User Data
      • Separating User Data
      • Restricting Access (RBAC)
      • OAuth (SSO)
    • Webhooks
    • Messaging
    • Emails
    • Custom Report Generation
    • Fuzzy Search
    • Chatbots
  • Xano Features
    • Snippets
    • Instance Settings
      • Release Track Preferences
      • Static IP (Outgoing)
      • Change Server Region
      • Direct Database Connector
      • Backup and Restore
      • Security Policy
    • Advanced Back-end Features
      • Xano Link
      • Developer API (Deprecated)
    • Metadata API
      • Master Metadata API
      • Tables and Schema
      • Content
      • Search
      • File
      • Request History
      • Workspace Import and Export
      • Token Scopes Reference
  • Xano AI
    • Building a Backend Using AI
    • Get Started Assistant
    • AI Database Assistant
    • AI Lambda Assistant
    • AI SQL Assistant
    • API Request Assistant
    • Template Engine
    • Streaming APIs
  • AI Tools
    • MCP Servers
      • Connecting Clients
      • MCP Functions
  • Xano Transform
    • Using Xano Transform
  • Xano Actions
    • What are Actions?
    • Browse Actions
  • Team Collaboration
    • Realtime Collaboration
    • Managing Team Members
    • Branching & Merging
    • Role-based Access Control (RBAC)
  • Agencies
    • Xano for Agencies
    • Agency Features
      • Agency Dashboard
      • Client Invite
      • Transfer Ownership
      • Agency Profile
      • Commission
      • Private Marketplace
  • Enterprise
    • Xano for Enterprise
    • Enterprise Features
      • Microservices
      • Tenant Center
      • Compliance Center
      • Security Policy
      • Instance Activity
      • Deployment
      • RBAC (Role-based Access Control)
      • Xano Link
  • Your Xano Account
    • Account Page
    • Billing
    • Referrals & Commissions
  • Troubleshooting & Support
    • Error Reference
    • Troubleshooting Performance
      • When a single workflow feels slow
      • When everything feels slow
      • RAM Usage
      • Function Stack Performance
    • Getting Help
      • Granting Access
      • Community Code of Conduct
      • Community Content Modification Policy
  • Special Pricing
    • Students & Education
    • Non-Profits
  • Security
    • Best Practices
Powered by GitBook
On this page

Was this helpful?

  1. The Function Stack
  2. Filters

Comparison

Last updated 3 months ago

Was this helpful?

​Comparison filters are useful for comparisons and checking data types, especially for conditional logic. They will result in a true or false boolean value.

  • - Returns the existing value with its bits flipped.

  • - Returns a boolean if both values are equal.

  • - Returns whether or not the value is even.

  • - Returns a boolean if the left value is greater than the right value.

  • - Returns a boolean if the left value is greater than or equal to the right value.

  • - Returns whether or not the value is in the array.

  • - Returns whether or not the value is a numerical indexed array.

  • - Returns whether or not the value is a boolean.

  • - Returns whether or not the value is a decimal value.

  • - Returns whether or not the value is empty ("", null, 0, [], {}).

  • - Returns whether or not the value is an integer.

  • - Returns whether or not the value is null

  • - Returns whether or not the value is an object.

  • - Returns whether or not the value is text.

  • - Returns a boolean if the left value is less than the right value

  • - Returns a boolean if the left value is less than or equal to the right value

  • - Returns the opposite of the existing value evaluated as a boolean

  • - Returns a boolean if both values are not equal

  • - Returns whether or not the value is odd

bitwise_not

Returns the existing value with its bits flipped.

equals

Returns a boolean if both values are equal.

even

Returns whether or not the value is even, this returns a response of true or false.

greater_than

Returns a boolean if the left value is greater than the right value.

greater_than_or_equal

Returns a boolean if the left value is greater than or equal to the right value.

in

Returns whether or not the value is in the Array, this returns a response of true or false.

is_array

Returns whether or not the value is a numerical indexed array.

is_bool

Returns whether or not the value is a boolean.

is_decimal

Returns whether or not the value is a decimal value.

is_empty

Returns whether or not the value is empty ("", null, 0, [], {}).

is_int

Returns whether or not the value is an integer.

is_null

Returns whether or not the value is null, this returns a response of true or false.

is_object

Returns whether or not the value is an object.

is_text

Returns whether or not the value is text.

less_than

Returns a boolean if the left value is less than the right value

less_than_or_equal

Returns a boolean if the left value is less than or equal to the right value.

not

Returns the opposite of the existing value evaluated as a boolean.

not_equals

Returns a boolean if both values are not equal.

odd

Returns whether or not the value is odd, this returns a response of true or false.

🛠️
bitwise_not
equals
even
greater_than
greater_than_or_equal
in
is_array
is_bool
is_decimal
is_empty
is_int
is_null
is_object
is_text
less_than
less_than_or_equal
not
not_equals
odd
var_2 is also 7, so in this example, the result will be true.
In this example, we have a variable with the int 23 after applying the even filter the variable becomes false.
The result will be true because 23 is greater than 5.
The result will be true because 23 is equal to 23.
var_2 is the array [1,2,7,23]. The result will be true because 23 is IN the array.
var2 is the array [1,2,7,23]. The result will be true because var_2 is an array.
False is a boolean so the result will be true.
9.86 is a decimal so the result will be true.
The result will be true because the value is an empty object {}.
-9 is an integer so the result will be true.
In this example, we have a variable with the int 23 after applying the is_null filter the variable becomes false.
The result is true because the value is an object {}.
Hello there is a text string so the result will be true.
The result will be true because 5 is less than 12.
5 is not less than or equal to 1 so the result will be false.
In this example, we first have the odd filter applied to 5 which results in a true boolean. Then, the not filter is applied resulting in the opposite existing value - making the result false.
The result will be true because 5 is not equal to 6.
5 is an odd number so the result will be true.