Skip to main content
May 2, 2025
Question

Facing an issue regarding queryentity in expression rule

In a queryentity function, in an interface, I'm getting an error like "Unexpected error executing query (type: [CPVAccountsStatementTrackerDT8331], query:[queryentity expression], order by: [[Sort[FinancialInstitutionOther asc]]], filters:[(firmId = TypedValue[it=1,v=-1)])". How should I resolve this error. In one of filters, we are filtering based on -1 but this is working in some environment while failing at  some.

    13 replies

    gayatria0439
    May 2, 2025

    Hi [mention:2b38d12ffa9e4814b6cfcc9f64da75bc:e9ed411860ed4f2ba0265705b8793d05] , can you share your code. So that will try to tell and resolve your issue.

    May 2, 2025

    a!queryEntity_22r2(

    entity:cons!CP_DSE_V_STATEMENT_TRACKER,

    query:a!query(

    pagingInfo:a!pagingInfo(

    startIndex:1,

    batchSize:-1),

    selection:a!querySelection(

    columns:a!queryColumn(field: "financialInstitutionother",alias:"FinancialInstitutionOther",visible:true()),

    logicalExpression:a!queryLogicalExpression(

    ignoreFilterWithEmptyValues:true(),

    filters:{a!queryFilter(

             field: "firmId",

    operator:"=",

    value:-1)

    }

    )))

    stefanhelzle0001
    May 2, 2025

    This error message typically points towards a timeout issue.

    And ...

    June 18, 2025

    Can you try by giving batch size, instead of  instead of minus 1

    June 18, 2025

    else try to configure query filters to limit output result set