Fail to sort data

Hi sikhivahans,

load(
local!pagingInfo: topaginginfo(1,10),
local!querydata:queryrecord(
recordType: cons!COMPANY_AUDIT_LOG,
query: 'type!{www.appian.com/.../2009}Query'(
'selection|aggregation': 'type!{www.appian.com/.../2009}Aggregation'(
columns: {
'type!{www.appian.com/.../2009}AggregationColumn'(
field: "full_name",
alias: "label",
visible: true,
isGrouping: true
),
'type!{www.appian.com/.../2009}AggregationColumn'(
field: "no_of_company_count",
alias: "data",
visible: true,
aggregationFunction: "SUM"
)
}
),
pagingInfo:
a!pagingInfo(
startIndex: 1,
batchSize: -1,
sort: a!sortInfo(
field: "label",
ascending: true
)
)
)
),
with(
local!data:todatasubset(local!querydata.data,local!pagingInfo),
a!formLayoutColumns(
instructions: "In this report we can view the # of companies created by the Analyst(s) during a Year / Month / Week in tabular as well as graphical view",
columns:{
a!columnLayout(
contents: {
a!sectionLayout(
firstColumnContents: {
'type!{www.appian.com/.../2009}Grid'(
totalCount:local!data.totalCount,
instructions: "Test",
columns: {
'type!{www.appian.com/.../2009}GridTextColumn'(
label: "Analyst",
data: index(local!data.data, "label",0),
field: "label"
),
'type!{www.appian.com/.../2009}GridTextColumn'(
label: "# of Companies Created",
data: index(local!data.data, "data",0),
field: "data"
)
},
value: local!pagingInfo,
saveInto: local!pagingInfo
)
}
)
}
)
}
)
)
)

We're using the above code, it gives the error i.e. "Expression evaluation error at function 'todatasubset' [line 34]: Error evaluating function 'todatasubset' : java.lang.IllegalArgumentException: The given data type is not a record type: Dictionary (id=94)".Can you please provide some more suggestions.

Many thanks in advance.
Sandeep

Hi sikhivahans,

load(
local!pagingInfo: topaginginfo(1,10),
local!querydata:queryrecord(
recordType: cons!COMPANY_AUDIT_LOG,
query: 'type!{www.appian.com/.../2009}Query'(
'selection|aggregation': 'type!{www.appian.com/.../2009}Aggregation'(
columns: {
'type!{www.appian.com/.../2009}AggregationColumn'(
field: "full_name",
alias: "label",
visible: true,
isGrouping: true
),
'type!{www.appian.com/.../2009}AggregationColumn'(
field: "no_of_company_count",
alias: "data",
visible: true,
aggregationFunction: "SUM"
)
}
),
pagingInfo:
a!pagingInfo(
startIndex: 1,
batchSize: -1,
sort: a!sortInfo(
field: "label",
ascending: true
)
)
)
),
with(
local!data:todatasubset(local!querydata.data,local!pagingInfo),
a!formLayoutColumns(
instructions: "In this report we can view the # of companies created by the Analyst(s) during a Year / Month / Week in tabular as well as graphical view",
columns:{
a!columnLayout(
contents: {
a!sectionLayout(
firstColumnContents: {
'type!{www.appian.com/.../2009}Grid'(
totalCount:local!data.totalCount,
instructions: "Test",
columns: {
'type!{www.appian.com/.../2009}GridTextColumn'(
label: "Analyst",
data: index(local!data.data, "label",0),
field: "label"
),
'type!{www.appian.com/.../2009}GridTextColumn'(
label: "# of Companies Created",
data: index(local!data.data, "data",0),
field: "data"
)
},
value: local!pagingInfo,
saveInto: local!pagingInfo
)
}
)
}
)
}
)
)
)

We're using the above code, it gives the error i.e. "Expression evaluation error at function 'todatasubset' [line 34]: Error evaluating function 'todatasubset' : java.lang.IllegalArgumentException: The given data type is not a record type: Dictionary (id=94)".Can you please provide some more suggestions.

Many thanks in advance.
Sandeep