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.