Indexing a Field on a Decisions Entity

Unknown

Indexing a Field on a Decisions Entity

Unknown

Hi,

What is suggested for making a Decisions Entity searchable by a custom property other than the Primary Key field?

I do not see a way in the Decisions UI (Integrations > Databases) to do such a thing. Would the best way be to create an Index on the field manually in the SQL Database? If so, in the case that a Decisions upgrades is performed, is there any risk of that “index” being lost or dropped during the upgrade?

Unknown

Hi,

Fortunately, we have a way of doing this in Decisions. It is referred to it as access patterns. To create an access pattern first we need to create a table integration for the Case Entity. To create this, navigate to System > Integrations > Databases and select the necessary connection folder. In that folder, you should see an option to Add Table.

[img]att1[/img]

Heres a link to our documentation site that will help in integrating a table and setting up an access pattern: [url=https://documentation.decisions.com/docs/alternate-access-pattern-table-integrations#]https://documentation.decisions.com/docs/alternate-access-pattern-table-integrations#[/url]