---
schema_version: "1"
id: 43a124b87d5cd65853455d73e715a4ea2f0922a56517f3b21db8c90ca3c5dd5d
title: BOOL_OR
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/aggregate-func/bool-or.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/bool-or.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 92c5dfdcbf89eec654af7ab2807a8ae751da1db5b0024ff5c66915d47d32e62f
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# `BOOL_OR`

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Returns true if at least one input value is true; otherwise returns false.

## Syntax

```sql
bool_or(<expression>)
```

## Arguments

### Required

- `<expression>`: An expression of type `boolean`.

## Returns

Returns a `boolean` value. Returns NULL if no rows are selected.

## Considerations

- NULL values are ignored in the calculation.

## Examples

### Check Any True

Check if any order has an issue.

```sql
SELECT bool_or(has_issue) AS any_issues
FROM orders
WHERE order_date = '2024-01-15';
```

### Check by Group

Find groups with at least one matching condition.

```sql
SELECT category, bool_or(is_featured) AS has_featured_item
FROM products
GROUP BY category;
```

## Related Documentation

- [BOOL_AND](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/bool-and.md)
- [Aggregate Functions](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/aggregate.md)