Comparing database data with data entered in Appian interface

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,

Kiran Sajjan

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.

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.