---
title: Supported Combinations
slug: supported-combinations
createdAt: 2023-03-26T12:58:54.000Z
---

## Text-like

| **Property**                   | **Value**                                                                                                                                                                                                                                                     |
| ------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Sugar Field Types**          | `text`, `varchar`, `name`, `html`, `longtext`, `phone`, `url`, `username`                                                                                                                                                                                     |
| **Supported Operations**       | [Equality](https://docs.sugarquickqueryis.fun/operators#9fJ4k), [Membership](https://docs.sugarquickqueryis.fun/operators#a0duG), [Text](https://docs.sugarquickqueryis.fun/operators#GytXg), [Emptiness](https://docs.sugarquickqueryis.fun/operators#kCoLX) |
| **Compatible RHS field types** | [Text-like](./#text-like)                                                                                                                                                                                                                                     |
| **Compatible RHS value types** | [Text](https://docs.sugarquickqueryis.fun/values#x-X2h), [Numbers](https://docs.sugarquickqueryis.fun/values#I0HyT)                                                                                                                                           |

***

## Dropdown-like

| **Property**                   | **Value**                                                                                                                                                                                         |
| ------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Sugar Field Types**          | `enum`, `multienum`                                                                                                                                                                               |
| **Supported Operations**       | [Equality](https://docs.sugarquickqueryis.fun/operators#9fJ4k), [Membership](https://docs.sugarquickqueryis.fun/operators#a0duG), [Emptiness](https://docs.sugarquickqueryis.fun/operators#kCoLX) |
| **Compatible RHS field types** | [Dropdown-like](./#dropdown-like)                                                                                                                                                                 |
| **Compatible RHS value types** | [Text](https://docs.sugarquickqueryis.fun/values#x-X2h)                                                                                                                                           |

***

## Number-like

| **Property**                   | **Value**                                                                                                                                                                                         |
| ------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Sugar Field Types**          | `tinyint`, `smallint`, `int`, `integer`, `long`, `float`, `decimal`                                                                                                                               |
| **Supported Operations**       | [Equality](https://docs.sugarquickqueryis.fun/operators#9fJ4k), [Comparison](https://docs.sugarquickqueryis.fun/operators#eExPo), [Emptiness](https://docs.sugarquickqueryis.fun/operators#kCoLX) |
| **Compatible RHS field types** | [Text-like](./#text-like), [Number-like](./#number-like)                                                                                                                                          |
| **Compatible RHS value types** | [Numbers](https://docs.sugarquickqueryis.fun/values#I0HyT)                                                                                                                                        |

***

## Currency

| **Property**                   | **Value**                                                                                                                                                                                         |
| ------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Sugar Field Types**          | `currency`                                                                                                                                                                                        |
| **Supported Operations**       | [Equality](https://docs.sugarquickqueryis.fun/operators#9fJ4k), [Comparison](https://docs.sugarquickqueryis.fun/operators#eExPo), [Emptiness](https://docs.sugarquickqueryis.fun/operators#kCoLX) |
| **Compatible RHS field types** | [Currency](./#currency), [Text-like](./#text-like), [Number-like](./#number-like)                                                                                                                 |
| **Compatible RHS value types** | [Currencies](https://docs.sugarquickqueryis.fun/values#5OfD0)                                                                                                                                     |

***

## Temporal-like

| **Property**                   | **Value**                                                                                                                                                                                                                                                         |
| ------------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Sugar Field Types**          | `date`, `datetime`, `datetimecombo`                                                                                                                                                                                                                               |
| **Supported Operations**       | [Equality](https://docs.sugarquickqueryis.fun/operators#9fJ4k), [Comparison](https://docs.sugarquickqueryis.fun/operators#eExPo), [Temporal](https://docs.sugarquickqueryis.fun/operators#Vf7hO), [Emptiness](https://docs.sugarquickqueryis.fun/operators#kCoLX) |
| **Compatible RHS field types** | [Text-like](./#text-like), [Temporal](./#temporal-like)                                                                                                                                                                                                           |
| **Compatible RHS value types** | [Text](https://docs.sugarquickqueryis.fun/values#x-X2h), [Temporal](https://docs.sugarquickqueryis.fun/values#NO8G4)                                                                                                                                              |

***

## Binary

| **Property**                   | **Value**                                                                                                                       |
| ------------------------------ | ------------------------------------------------------------------------------------------------------------------------------- |
| **Sugar Field Types**          | `bool`                                                                                                                          |
| **Supported Operations**       | [Equality](https://docs.sugarquickqueryis.fun/operators#9fJ4k), [Emptiness](https://docs.sugarquickqueryis.fun/operators#kCoLX) |
| **Compatible RHS field types** | [Binary](./#binary)                                                                                                             |
| **Compatible RHS value types** | [Binary](https://docs.sugarquickqueryis.fun/values#D413V)                                                                       |

***

## Links

| **Property**                   | **Value**                                                       |
| ------------------------------ | --------------------------------------------------------------- |
| **Sugar Field Types**          | `link`, `email`                                                 |
| **Supported Operations**       | [Emptiness](https://docs.sugarquickqueryis.fun/operators#kCoLX) |
| **Compatible RHS field types** | None                                                            |
| **Compatible RHS value types** | None                                                            |

***

## ID-like

| **Property**                   | **Value**                                                                                                                                                                                                                                                     |
| ------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Sugar Field Types**          | `id`, `assigned_user_name`, `modified_user_name`, `relate`                                                                                                                                                                                                    |
| **Supported Operations**       | [Equality](https://docs.sugarquickqueryis.fun/operators#9fJ4k), [Membership](https://docs.sugarquickqueryis.fun/operators#a0duG), [Text](https://docs.sugarquickqueryis.fun/operators#GytXg), [Emptiness](https://docs.sugarquickqueryis.fun/operators#kCoLX) |
| **Compatible RHS field types** | [ID-like](./#id-like)                                                                                                                                                                                                                                         |
| **Compatible RHS value types** | [Text](https://docs.sugarquickqueryis.fun/values#x-X2h)                                                                                                                                                                                                       |

