and more in a single search tool across platforms. Read the announcement here. |
12/02/2022 05:47 AM
Hi,
We have around 18000 departments which we wish to populate in a dropdown in the create user form from a dataset table that we have imported.
However, dataset gives us a threshold of only 10k lines of entries.
Any workarounds for this use case?
Can we break the list into two datasets and fetch the value in create user form via SQL query?
Solved! Go to Solution.
12/02/2022 06:20 AM
Yes we can break it into two datasets and fetch the data
12/02/2022 09:25 AM - edited 12/02/2022 09:25 AM
select attribute1 as id from dataset_values where datasetname='DEPT1' union
select attribute1 as id from dataset_values where datasetname='DEPT2'
make sure you use index else page load time will increase (work with saviynt ops)
12/02/2022 02:17 PM
Yes please make sure that indexing is done otherwise page loading will not work properly
12/04/2022 10:12 PM
Could you elaborate how indexing can affect?
12/04/2022 10:14 PM
Saviynt load dynamic attribute value on page load if your dynamics attribute values are more then page load time will be more so add index on table column
Indexes are used to retrieve data from the database more quickly than otherwise. The users cannot see the indexes, they are just used to speed up searches/queries. Note: Updating a table with indexes takes more time than updating a table without (because the indexes also need an update).