119941 - no subject - Hi All,\n\nAm getting below error for al

madhubindug over 9 years ago

Hi All,

Am getting below error for all the entity backed reports
Expression evaluation error in rule 'queryrecord' (called by rules 'getreportdetails' > 'dailyreport') [line 19]: The a!queryAggregation function has an invalid value for the “aggregationColumns” parameter. “aggregationColumns” must not be null or empty.

Please let me know if anyone of you faced and fixed this?
Regards,
Madhu
...

Discussion posts and replies are publicly visible

Parents

0 madhubindug over 9 years ago

Please find below query record code, am not using any a!queryAggregation function, this report was working earlier, after few changes to xsd, we did impact analysis, after this it is not working, same is with the other entitybacked reports

= queryrecord(
recordType: cons!REQUESTINFO_REPORT_RECORDTYPE,
query: a!query(
selection: a!querySelection(
columns: {
a!queryColumn(
field: "id",
visible: true
),
a!queryColumn(
field: "requestId",
visible: true
),
a!queryColumn(
field: "requestStatus",
visible: true
),
a!queryColumn(
field: "createdDate",
visible: true
),
a!queryColumn(
field: "accountDetails.accountNumber",
visible: true
),
a!queryColumn(
field: "accountDetails.accountName",
visible: true
),
a!queryColumn(
field: "accountDetails.accountType.accountTypeName",
visible: true
)
}
),
logicalExpression: a!queryLogicalExpression(
operator: "AND",
filters: {
if(
isnull(
ri!accountType
),
{},
a!queryFilter(
field: "accountDetails.accountType.accountTypeName",
operator: "=",
value: ri!accountType
)
),
a!queryFilter(
field: "createdDate",
operator: "not null"
),
if(
and(
not(
isnull(
ri!startDate
)
),
ri!startDate <> "",
trim(
ri!startDate
) <> ""
),
a!queryFilter(
field: "createdDate",
operator: ">=",
value: todatetime(
ri!startDate
)
),
{}
),
if(
and(
not(
isnull(
ri!endDate
)
),
ri!endDate <> "",
trim(
ri!endDate
) <> ""
),
a!queryFilter(
field: "createdDate",
operator: "<=",
value: todatetime(
ri!endDate + 1
)
),
{}
)
}
),
accountType: ri!accountType,
startDate: ri!startDate,
endDate: ri!endDate,
pagingInfo: ri!pagingInfo
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 madhubindug over 9 years ago

Please find below query record code, am not using any a!queryAggregation function, this report was working earlier, after few changes to xsd, we did impact analysis, after this it is not working, same is with the other entitybacked reports

= queryrecord(
recordType: cons!REQUESTINFO_REPORT_RECORDTYPE,
query: a!query(
selection: a!querySelection(
columns: {
a!queryColumn(
field: "id",
visible: true
),
a!queryColumn(
field: "requestId",
visible: true
),
a!queryColumn(
field: "requestStatus",
visible: true
),
a!queryColumn(
field: "createdDate",
visible: true
),
a!queryColumn(
field: "accountDetails.accountNumber",
visible: true
),
a!queryColumn(
field: "accountDetails.accountName",
visible: true
),
a!queryColumn(
field: "accountDetails.accountType.accountTypeName",
visible: true
)
}
),
logicalExpression: a!queryLogicalExpression(
operator: "AND",
filters: {
if(
isnull(
ri!accountType
),
{},
a!queryFilter(
field: "accountDetails.accountType.accountTypeName",
operator: "=",
value: ri!accountType
)
),
a!queryFilter(
field: "createdDate",
operator: "not null"
),
if(
and(
not(
isnull(
ri!startDate
)
),
ri!startDate <> "",
trim(
ri!startDate
) <> ""
),
a!queryFilter(
field: "createdDate",
operator: ">=",
value: todatetime(
ri!startDate
)
),
{}
),
if(
and(
not(
isnull(
ri!endDate
)
),
ri!endDate <> "",
trim(
ri!endDate
) <> ""
),
a!queryFilter(
field: "createdDate",
operator: "<=",
value: todatetime(
ri!endDate + 1
)
),
{}
)
}
),
accountType: ri!accountType,
startDate: ri!startDate,
endDate: ri!endDate,
pagingInfo: ri!pagingInfo
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data