Skip to main content
H
harathys0001
February 4, 2022
Question

Expression rule to compare two values

  • February 4, 2022
  • 5 replies
  • 0 views

I want to write an expression rule to compare two values: 

first value is from rule input and second value from a db table field.If the values are same ,then another field(column) of my db table must be set to inactive or 0.

    5 replies

    mikes0011
    mikes0011
    Brainy
    February 4, 2022

    FYI, you're able to edit your post if you want to change something, it's not really needed to post essentially the same thing again.

    For your question, you should be able to query from your database table (using a!queryEntity() or, preferably, referencing an existing expression rule you've already set up to handle queries to that table), and compare the result to the input value.  I'm not exactly clear what you mean when you say "another field of my table must be set to inactive", as an expression rule itself cannot change data in a DB table - what you describe will probably be most easily accomplished by using a process model which sets the desired value determined by some initial logic then writes that row back to your table.

    The Expression Guru
    H
    harathys0001Author
    February 6, 2022

    Hi Mike

    Thanks for your response,by the line "another field of my table must be set to inactive",what I mean is I have a column name "is active" in my db Table. I also have columns "fieldid" and "formid" in my DB table.So what I exactly want to do is get rule inputs for formid and fieldid.If the rule input values of these 2 fields matches(same value) with the value i have in the db table for "fieldid" and "formid" column, then my "isactive" column must be set to 0 or disabled. 

    mikes0011
    mikes0011
    Brainy
    February 7, 2022

    You probably need to look into doing this in a process model; a single expression rule can't really do all the different things you're describing here inherently.

    The Expression Guru
    A
    akhils
    February 4, 2022

    To do the comparison, the value should be retrieved from the database. Use query entity to get the value from backend, compare it and set the value (write into database). 

    J
    jasmithak990
    February 8, 2022

    load(
    local!dbdata:{
    {id:1,isactive:1,fieldId:1,formId:2},
    {id:1,isactive:1,fieldId:1,formId:3},
    },

    a!forEach(
    items: local!dbdata,
    expression: if(
    and(
    tointeger(fv!item.fieldId) = ri!fieldId,
    tointeger(fv!item.formId) = ri!formId
    ),
    {id:fv!item.id,isactive:0,fieldId:fv!item.fieldId,formId:fv!item.formId},
    fv!item
    )
    )
    )

    I specified dbdata as dictionary in above code. cast it to CDT using type! and write the output to database entity.

    Terms & ConditionsAccessibility statement