8000 Update the IN operator description by anastasiaberyoza · Pull Request #763 · box/developer.box.com · GitHub
[go: up one dir, main page]
Skip to content

Update the IN operator description #763

< 8000 summary id="button-10c72606a459687a" class="btn btn-sm btn-primary m-0 ml-0 ml-md-2" > New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 4 commits into from
Jul 9, 2025
Merged

Update the IN operator description #763

Changes from 1 commit
Commits
Show all changes
4 commits
Select commit Hold shift + click to select a range
6eb7a85
Update the IN operator description
anastasiaberyoza Jul 3, 2025
84de1ab
Updated spelling
anastasiaberyoza Jul 3, 2025
434eb19
Modified IN operator
anastasiaberyoza Jul 9, 2025
fcc7ba9
Merge branch 'main' into DDOC-853-Add-limitiations-to-IN-operator
anastasiaberyoza Jul 9, 2025
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Next Next commit
Update the IN operator description
  • Loading branch information
@anastasiaberyoza
anastasiaberyoza committed Jul 3, 2025
commit 6eb7a8573edadcb1487170f54737525277185750
2 changes: 1 addition & 1 deletion content/guides/metadata/5-queries/2-syntax.md
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -87,7 +87,7 @@ A query supports the following logical operators.
| `NOT LIKE` | Matches when the template field value does **not** match a pattern. Only supported for string values. See [pattern matching](#pattern-matching) for more details. See additional limitations below. |
| `ILIKE` | Identical to `LIKE` but case insensitive. See additional limitations below. |
| `NOT ILIKE` | Identical to `NOT LIKE` but case insensitive. See additional limitations below. |
| `IN` | Matches when the template field value is equal to any one of a list of arguments provided. The format for this requires each item in the list to be an explicitly defined `query_params` argument, for example `amount NOT IN (:arg1, :arg2, :arg3)`. |
| `IN` | Matches when a template field value equals any value in a specified list. Use explicitly defined `query_params` arguments for each list item, such as `amount IN (:arg1, :arg2, :arg3)`. This operator doesn't work with multiselect fields in metadata queries and returns a 400 error. |
| `NOT IN` | Similar to `IN` but when the template field value matches none of the arguments provided in the list. |
| `IS NULL` | Matches when the template field value is `null`. |
| `IS NOT NULL` | Matches when the template field value is not `null` . |
Expand Down
Loading
0