Skip to main content
November 5, 2021
Question

Expression rule error if input does not exist.

  • November 5, 2021
  • 5 replies
  • 0 views

Hi Everyone,

Can anyone please tell me how to get rid of error in expression rule when rule input does not exist in the entity parameter in appian.

Thank You

    5 replies

    November 5, 2021

    Hi,

    can share the code?

    November 5, 2021

    Here is the rule I used:

    with(
    a!queryEntity(
    entity: cons!TEMS_ENTITY_V_TE_DETAILS,
    query: a!query(
    paginginfo: if(rule!APN_isBlank(ri!pagingInfo) , a!pagingInfo(1, - 1,a!sortInfo(field: "etemId",ascending: true)),ri!pagingInfo),
    logicalexpression: a!queryLogicalExpression(
    ignorefilterswithemptyvalues: true,
    operator: "AND",
    filters: {
    a!queryFilter(
    field: "id",
    operator: "includes",
    value: ri!id
    ),
    a!queryFilter(
    field: "etemId",
    operator: "=",
    value: ri!etemId
    ),

    a!queryFilter(
    field: "eterfId",
    operator: "=",
    value: ri!eterfId
    ),
    a!queryFilter(
    field: "cafNumber",
    operator: "includes",
    value: ri!cafNumber
    ),
    a!queryFilter(
    field: "uniqueId",
    operator: "=",
    value: ri!uniqueId
    ),
    a!queryFilter(
    field: "appianDocumentId",
    operator: "=",
    value: ri!appianDocumentId
    ),
    a!queryFilter(
    field: "caseId",
    operator: "=",
    value: ri!caseId
    ),
    a!queryFilter(
    field: "excursionId",
    operator: "=",
    value: ri!excursionId
    ),
    a!queryFilter(
    field: "excursionRangesId",
    operator: "=",
    value: ri!excursionRangesId
    ),
    a!queryFilter(
    field: "justification",
    operator: "includes",
    value: ri!justification
    ),
    a!queryFilter(
    field: "minObservedTempOfTe",
    operator: "=",
    value: ri!minObservedTempOfTe
    ),
    a!queryFilter(
    field: "maxObservedTempOfTe",
    operator: "=",
    value: ri!maxObservedTempOfTe
    ),
    a!queryFilter(
    field: "maxTotalDurationOfTe",
    operator: "includes",
    value: ri!tlDurationOfTe
    ),
    a!queryFilter(
    field: "dispositionStatus",
    operator: "=",
    value: ri!dispositionStatus
    ),
    a!queryFilter(
    field: "createdBy",
    operator: "includes",
    value: ri!createdBy
    ),
    a!queryFilter(
    field: "approvedByName",
    operator: "includes",
    value: ri!approvedByName
    ),
    a!queryFilter(
    field: "approvedByDate",
    operator: "=",
    value: ri!approvedByDate
    ),
    a!queryFilter(
    field: "approverRole",
    operator: "includes",
    value: ri!approverRole
    ),
    a!queryFilter(
    field: "emailSent",
    operator: "includes",
    value: ri!emailSent
    ),

    a!queryFilter(
    field: "capa",
    operator: "=",
    value: ri!capa
    ),
    a!queryFilter(
    field: "comments",
    operator: "includes",
    value: ri!comments
    ),

    a!queryFilter(
    field: "permittedTeRange",
    operator: "includes",
    value: ri!permittedTeRange
    ),
    a!queryFilter(
    field: "calculatedTime",
    operator: "includes",
    value: ri!calculatedTime
    ),
    a!queryFilter(
    field: "disposition",
    operator: "includes",
    value: ri!disposition
    ),
    a!queryFilter(
    field: "justification",
    operator: "includes",
    value: ri!justification
    ),

    a!queryFilter(
    field: "timeAllowableForFutureExcursion",
    operator: "=",
    value: ri!timeAllowableForFuture
    )
    }
    ),

    ),
    fetchTotalCount: true
    )
    )

    stefanhelzle0001
    Brainy
    November 5, 2021

    Next time please use

    Would you please post the actual error message.

    And please explain what "error in expression rule when rule input does not exist in the entity parameter" means. In your code, the entity is a constant. Why can that be empty?