Columns having values formatted using FORMATCOLUMNS are not sortable.

ravinerella · 2021-02-10T22:32:32+00:00

There was an error rendering this rich post.

Columns that have data values formatted using sub-tags before the data is returned to the client. are not sortable, is it by design, or is there a way to have this column sortable

This is what I have in the webreport

[LL_WEBREPORT_INSERTJSON @TABLEREPORT

COLLECTIONPROCESSING:"datasource"

EXCLUDECOLUMNS:'["ROWNUMBER","DATAID"]'

SORTABLECOLUMNS:'["NAME","ORGANIZATION","GROUPNAME","PROJECTCODE","PROJECTSTATUS","PROJECTMANAGER"]'

FORMATCOLUMNS:ProjectManager:"[LL_REPTAG=ProjectManager USERINFO:FULLNAME /]"

FORMATCOLUMNNAMES:NAME:"Project Name":ORGANIZATION:"Organization":GROUPNAME:"Group":PROJECTCODE:"Project Code":PROJECTSTATUS:"Status":ProjectManager:"Project Manager"/]

[LL_WEBREPORT_STARTROW /]

[LL_WEBREPORT_ENDROW /]

Any Pointers?

Find more posts tagged with

Comments

Christopher Donner

Hi,

For the @TABLREPORT directive, if COLLECTIONPROCESSING is set to "datasource", the columns will be automatically disabled. Can you test this with COLLECTIONPROESSING set to "webreport"?

ravinerella

Thanks, Chris,

I tried changing the COLLECTIONPROESSING "webreport" instead of the "datasource" but that's not fetching the results. Not sure if I am missing something here or need to change the source as the web report currently pointing to the livereport as the source.