I would like to execute the below SQL query for one of my requirement. How to do

ramakg

A Score Level 1

over 8 years ago

I would like to execute the below SQL query for one of my requirement. How to do it through the queryEntity?

select max(column) from tablename where filedname=1 and filedname=2

Thanks in advance.

Discussion posts and replies are publicly visible

Parents

0 nageswararaoa over 8 years ago

Hi Rama try with the below code
a!queryEntity(
entity: cons!Entity_constant,
query: a!query(
aggregation: a!queryAggregation(aggregationColumns: {
a!queryAggregationColumn(field: "column1", isGrouping: true),
a!queryAggregationColumn(field: "column2", aggregationFunction: "MAX")
}),
                    logicalExpression:
a!queryLogicalExpression(
operator: "AND",
filters: {
                               a!queryFilter(field: "fileld_name1", operator: "=", value: 1),
                               a!queryFilter(field: "fileld_name2", operator: "=", value: 2)}),
                               ,
pagingInfo: local!pagingInfo

                              ))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 nageswararaoa over 8 years ago

Hi Rama try with the below code
a!queryEntity(
entity: cons!Entity_constant,
query: a!query(
aggregation: a!queryAggregation(aggregationColumns: {
a!queryAggregationColumn(field: "column1", isGrouping: true),
a!queryAggregationColumn(field: "column2", aggregationFunction: "MAX")
}),
                    logicalExpression:
a!queryLogicalExpression(
operator: "AND",
filters: {
                               a!queryFilter(field: "fileld_name1", operator: "=", value: 1),
                               a!queryFilter(field: "fileld_name2", operator: "=", value: 2)}),
                               ,
pagingInfo: local!pagingInfo

                              ))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data