Hi everyone,
I wanted to do validation based comparing the data already existing in database, but problem is that I have around 40000 records, so while fetching data from database to appian it is throwing the error.
How to handle this scenario..
Thank you all in advance!
Regards,
Kiran Sajjan
Discussion posts and replies are publicly visible
Try to query data using the values entered by the user and let the database do the comparison. There is no need to load all the data into Appian.
Hi Stefan,
Can you explain more,
I have to check the database to validate duplicate of records, if record already exist in the database than i need to show the validation message like the record already exist in the application, else it should allow to enter the data.
Thanks and Regards,
Stefan's answer was exactly what you need to do for this. If you have any more specific issue, you'll need to give us more details here so we can discern what to suggest - otherwise your question is way too general to even start on an approach.
Yes, essentially each row will make a single, small query to the database to see if an exact match exists using all of it's data points as filters - such as you can have a validation button perform, say, 20 small queries for 20 rows. How many rows are being entered at one time?
you can create a queryEntity as an expression rule in which you will pass all the fields as a query filter and if that rule returns a data, then the data is available in the system else not available. But it will be appreciated if you can share your scenario.