How to use Custom CDT with dataset

Create a script task. From the output tab of the script task, create a new output and using the expression editor, call the rule which returns your dataset. Add ".data" after the rule call. Then in the same output that you just created, select 'is stored as' and then give your cdt name where you want to store the output (in your case the dataset).

** Keep In mind that your dataset field names should match your cdt field name.

I have single report with multiple sections , so i need to implement at interface level.

Are you using any buttons in your section?

No , it's loading on clicking respective report name on report tab

Can you share your code

I got this by somehow, but stuck on other . Want to perform aggregation on existing dataset which i got on my interface without hitting new DB call.

WIth the existing View data , i want to perform below query. Is that possible ?

a!queryEntity(
entity: cons!TEST_VIEW,
query: a!query(
aggregation: a!queryAggregation(
aggregationColumns: {
a!queryAggregationColumn(
field: "testName",
isGrouping: true
),
a!queryAggregationColumn(
field: "test1",
alias: "test1",
aggregationFunction: "SUM"
),
a!queryAggregationColumn(
field: "test2",
alias: "test2",
aggregationFunction: "SUM"
),
a!queryAggregationColumn(
field: "test3",
alias: "test3",
aggregationFunction: "SUM"
),
a!queryAggregationColumn(
field: "test4",
alias: "test4",
aggregationFunction: "SUM"
)
}
),
logicalExpression: a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field: "testName",
operator: "not in",
value: {
"A",
"B"
}
),
if(
or(
isusermemberofgroup(
loggedInUser(),
cons!TEST_GROUP1
),
isusermemberofgroup(
loggedInUser(),
cons!TEST_GROUP2
),
isusermemberofgroup(
loggedInUser(),
cons!TEST_GROUP3
),
isusermemberofgroup(
loggedInUser(),
cons!TEST_GROUP4
)
),
{},
a!queryFilter(
field: "testName",
operator: "not in",
value: cons!C
)
)
}
),

pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: - 1,
sort: a!sortInfo(
field: "testName",
ascending: true
)
)
)
)

I got this by somehow, but stuck on other . Want to perform aggregation on existing dataset which i got on my interface without hitting new DB call.

WIth the existing View data , i want to perform below query. Is that possible ?

a!queryEntity(
entity: cons!TEST_VIEW,
query: a!query(
aggregation: a!queryAggregation(
aggregationColumns: {
a!queryAggregationColumn(
field: "testName",
isGrouping: true
),
a!queryAggregationColumn(
field: "test1",
alias: "test1",
aggregationFunction: "SUM"
),
a!queryAggregationColumn(
field: "test2",
alias: "test2",
aggregationFunction: "SUM"
),
a!queryAggregationColumn(
field: "test3",
alias: "test3",
aggregationFunction: "SUM"
),
a!queryAggregationColumn(
field: "test4",
alias: "test4",
aggregationFunction: "SUM"
)
}
),
logicalExpression: a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field: "testName",
operator: "not in",
value: {
"A",
"B"
}
),
if(
or(
isusermemberofgroup(
loggedInUser(),
cons!TEST_GROUP1
),
isusermemberofgroup(
loggedInUser(),
cons!TEST_GROUP2
),
isusermemberofgroup(
loggedInUser(),
cons!TEST_GROUP3
),
isusermemberofgroup(
loggedInUser(),
cons!TEST_GROUP4
)
),
{},
a!queryFilter(
field: "testName",
operator: "not in",
value: cons!C
)
)
}
),

pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: - 1,
sort: a!sortInfo(
field: "testName",
ascending: true
)
)
)
)