• State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 11 replies
  • Subscribers 8 subscribers
  • Views 7472 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

An error occurred while executing a save: Expression evaluation error

garym

Hi,
Please let me know if you have seen this error before and have come across this.
I have seen this error before when there is a connection issue to the database and it can't retrieve data.
However, in this case, I have verified over and over again that the connection is fine.

Users get this error:
An error occurred while executing a save: Expression evaluation error in rule 'nod_getcrslineitemsforenterdetailsform' at function a!queryEntity: An error occurred while retrieving data.

Here is the script for 'nod_getcrslineitemsforenterdetailsform': (I believe it is complaining about the section that has the ri!location but I can't figure out what is is)

a!queryEntity(
entity: cons!NOD_CRS_LINE_ITEM,
query: a!query(
logicalExpression: if(
and(
isnull(ri!chargeType),
isnull(ri!location),
isnull(ri!tradeHour),
isnull(ri!tradeInterval)
),
null,
a!queryLogicalExpression(
operator:...

OriginalPostID-226536

OriginalPostID-226536

  Discussion posts and replies are publicly visible

Parents
  • 0
    @mohammedz - the data is being fetched from a view

    @siddharthg837 - Thanks, I will check the logs. The expression is being used for a search button on the form so a user will input the criteria and click a Search button which should retrieve data and put it into a grid.

    The interface calling this interface already uses pagingInfo when calling this one. Does that matter?

    a!buttonLayout(
    secondaryButtons: {
    a!buttonWidget(
    label: cons!NOD_BUTTON_SEARCH,
    value: true,
    validate: true,
    saveInto: {
    local!showSearch << rule!NOD_formRule_returnTrue,
    a!save(
    local!preSortPage,
    rule!NOD_getCrsLineItemsForEnterDetailsForm(
    local!chargeSearchField,
    local!locationField,
    local!tradeHourField,
    local!tradeIntervalField,
    a!pagingInfo(startIndex:1,batchSize:-1),
    ri!noticeOfDisagreement.crsStatementId_int
    )
    )
    }
    )
    }
    ),
Reply
  • 0
    @mohammedz - the data is being fetched from a view

    @siddharthg837 - Thanks, I will check the logs. The expression is being used for a search button on the form so a user will input the criteria and click a Search button which should retrieve data and put it into a grid.

    The interface calling this interface already uses pagingInfo when calling this one. Does that matter?

    a!buttonLayout(
    secondaryButtons: {
    a!buttonWidget(
    label: cons!NOD_BUTTON_SEARCH,
    value: true,
    validate: true,
    saveInto: {
    local!showSearch << rule!NOD_formRule_returnTrue,
    a!save(
    local!preSortPage,
    rule!NOD_getCrsLineItemsForEnterDetailsForm(
    local!chargeSearchField,
    local!locationField,
    local!tradeHourField,
    local!tradeIntervalField,
    a!pagingInfo(startIndex:1,batchSize:-1),
    ri!noticeOfDisagreement.crsStatementId_int
    )
    )
    }
    )
    }
    ),
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.