# Limitations on Crystal Console As an **Admin User**, you need to be aware of the many possibilities that Crystal offers as well as of some limitations that you might encounter. A deep knowledge of Crystal allows you to make the most of the experience! Let's see an overview of the limitations in the Console's capabilities, broken down by Area and Feature and summarized. *You will also be redirected to the specific Feature page to find out more details!* {% hint style="success" %} **Stay Tuned!** We are constantly working to *improve* our product: check out the [**Release Notes**](https://docs.igenius.ai/release-notes) section of this documentation to learn about most recent *fixes and enhancements*! {% endhint %} *** ## **Impacts on Conversation** ### **Minimum Number of Configured Topics** * In order to guarantee an optimal conversational experience for the Member User, a **minimum of 5/6 Topics** must be configured in Console. With less Topics, Crystal might encounter training problems and not be able to recognize Entities. ## **Integration** ### **Security** * Crystal supports the connection to Data Sources with TLS >= 1.2 *Please find out more details in the* [*related Feature page*](https://docs.igenius.ai/crystal-console/topics-configuration/connect/supported-data-sources)*!* ### **Complex Fields Types** * At the moment Crystal is not supporting complex fields like: * “Json objects“ for Postgres * “LOB“ for Oracle * for Oracle, all the data types described [here](https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/Data-Types.html#GUID-A3C0D836-BADB-44E5-A5D4-265BA5968483) are not supported either * If such field types are present in a table, Crystal will not be able to use them in the Topic Configuration process, nor to preview the related data *Please find out more details in the* [*related Feature page*](https://docs.igenius.ai/crystal-console/topics-configuration/connect/supported-data-sources-1)*!* ### **Complex Fields Names** * There are some restrictions on the use of special characters and punctuation signs in some fields, and in particular: * Crystal doesn’t support column names that contain special characters like .(),%$… * The presence of a special symbol inside a column name is causing the failure of the Topic retrieval * Crystal doesn’t support periods inside the schema name * Crystal doesn’t support column names that include "/" for dynamic filters ## **IAM** ### **Groups** * As of now, Crystal is not supporting Groups hierarchy (Groups belonging to other Groups) *Please find out more details in the* [*related Feature page*](https://docs.igenius.ai/crystal-console/users/user-groups)*!* ## **Console** ### **Language** * Currently, Crystal Console is only available in the English language: the 5 languages supported (English, Italian, Spanish, French, German) refer to the languages available for [training](https://docs.igenius.ai/crystal-console/topics-configuration/train) and [conversation](https://docs.igenius.ai/crystal-advisor/customize-your-experience/how-to-interact-with-crystal) ### **Topic Publishing** * It is not possible to edit a Topic without unpublishing it first * It is not possible to delete a Topic that is in the statuses of "publishing", "unpublishing" or "published" *Please find out more details in the* [*related Feature page*](https://docs.igenius.ai/crystal-console/topics-configuration/publish)*!* ### **Topic Configuration** * It is not possible to select a “number” column in the "group by" field for a table without binning, even if the number is an integer * For Multi-Entity visualizations, it is not possible to use different aggregations or column types on Entities *Please find out more details in the* [*related Feature page*](#h_e5e3ea6141)*!* ### **Maximum Configurable Values** These are the maximum values available as you configure Topics: * Maximum number of Filters per Topic: **7** * Maximum number of Filter Values ​​for a single Filter: **50.000** * Maximum number of total Tables in the target DB: **40** * Maximum number of Columns for a single Table: **24** * Maximum number of Joins for a single Topic: **5** * Maximum number of Topics: **100** *Please find out more details in the* [*related Feature page*](#h_e5e3ea6141)*!* ### **Dynamic Filters** * You can’t set a required Filter without a default value * You cannot have more than three mandatory filters (excluding the time filter) * At the moment, the Filter Values are updated only during the publication or depublication of a Topic: there’s no automated way to update the Filter Values without a training action *Please find out more details in the* [*related Feature page*](https://docs.igenius.ai/crystal-console/topics-configuration/filter)*!* ### **Join Tables** * It’s currently not possible to join objects from different data sources *Please find out more details in the* [*related Feature page*](https://docs.igenius.ai/crystal-console/topics-configuration/connect)*!* ### **Fields Composition** * It’s not possible to perform operations between different fields (es: column A + column B): you can create Custom Entities with aggregations instead *Please find out more details in the* [*related Feature page*](https://docs.igenius.ai/crystal-console/topics-configuration/configure/custom-entity)*!* ### Permissions * A maximum of **1000** Filters can be allowed per User * Different logics for *"Allow"* and *"Revoke"* actions in Topics and Filters Tab * Missing visibility of permissions for inherited Topics / Filters * Missing visibility of permissions in Multiple or Mixed Targets selection * Missing *"Revoke"* option for Filters in Multiple or Mixed Targets selection *Please find out more details in the* [*related Feature page*](https://docs.igenius.ai/crystal-console/users/manage-permissions)*!* ***