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 jasmins over 7 years ago

@martinc872 , To make the query easier to understand, you can try below option -:

with(

local!Location:"c2",
local!Amount:"c4",

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: local!Location, operator: "includes", value: "East"),
a!queryFilter(field: local!Amount , operator: ">", value: 10000)
}
)
)
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 jasmins over 7 years ago

@martinc872 , To make the query easier to understand, you can try below option -:

with(

local!Location:"c2",
local!Amount:"c4",

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: local!Location, operator: "includes", value: "East"),
a!queryFilter(field: local!Amount , operator: ">", value: 10000)
}
)
)
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data