Expand my Community achievements bar.

Sorting report by a custom column date

Avatar

Level 3
Is it possible to sort a column within a report view by a date that is being pulled from a collection? Text mode code below. displayname=Date ready to publish listdelimiter= listmethod=nested(predecessors).lists querysort={predecessor}.{actualCompletionDate} textmode=true type=iterate valueexpression={predecessor}.{actualCompletionDate} valueformat=atDate I would like the report to sort by this column with oldest dates at the top. Is it possible I tried adding: "sortType=asc" but an error message "Unable to edit the column text mode data in the view builder" pops up and will not allow me to save changes. Thanks. Cameron Howitt
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Level 1

Hi, Cameron, I am getting the same error in 2024...did you ever figure out why this was happening?  There doesn't seem to be much info about this particular error

Avatar

Level 4

Also facing this issue, specifically when trying to work with sortOrder. Anybody figure out the problem?