Skip to main content
K
kirans0126
October 15, 2022
Question

Comparing database data with data entered in Appian interface

  • October 15, 2022
  • 5 replies
  • 0 views

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

    5 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    October 15, 2022

    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.

    K
    kirans0126Author
    October 17, 2022

    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

    mikes0011
    mikes0011
    Brainy
    October 17, 2022

    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.

    The Expression Guru
    Terms & ConditionsAccessibility statement