queryProcessAnalytics - reports

martinc8721 over 7 years ago

Hello people, is there any way to set an alias to the fields in a report in order to make the query easier to build and understand? (c1,c4) also, apparently the name field assignation does not follow the order of the columns in the report.

a!queryProcessAnalytics(
report: cons!OPEN_REIMBURSEMENT_REQUESTS,
groupContext: cons!EXPENSE_APPROVERS,
query: a!query(
pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 20),
logicalExpression: a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(field: "c2", operator: "includes", value: "East"),
a!queryFilter(field: "c4", operator: ">", value: 10000)
}
)
)
)

Discussion posts and replies are publicly visible

Parents

0 martinc8721 over 7 years ago

what I want to have the alias set on the report end to use a query like this:
filters: {
a!queryFilter(field: "Location", operator: "includes", value: "East"),
a!queryFilter(field: "Amount", operator: ">", value: 10000)
}
I dont want to have any "c2" or "c4" on my expression rule
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 martinc8721 over 7 years ago

what I want to have the alias set on the report end to use a query like this:
filters: {
a!queryFilter(field: "Location", operator: "includes", value: "East"),
a!queryFilter(field: "Amount", operator: ">", value: 10000)
}
I dont want to have any "c2" or "c4" on my expression rule
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data