Indexing a Field on a Decisions Entity
Comments
-
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?
-
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]