Use of querysort (text mode) on custom columns within project view | Community
Skip to main content
N
NickVa7
New Participant
January 18, 2021
Solved

Use of querysort (text mode) on custom columns within project view

  • January 18, 2021
  • 4 replies
  • 886 views

Hi WF Community,

I create a few custom calculated columns in a project report view. I added 'querysort=' to the text mode for each custom column, and when the column headings are clicked on once the report is run, it looks like it tried to sort the columns, but never does.

Here's an example of one of my custom calculated columns:

displayname=Update % Complete or Status?

querysort=DE:Update % Complete or Status?

textmode=true

valueexpression=IF({percentComplete}="100"&&{status}!="CPL","Check % Complete & Status","")

valueformat=string

In this example, I put "DE:" in front of the column name. I tried it without "DE:", and it still didn't work.

Am I missing something?

Thanks.

Nick

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by imgrund

Someone correct me if I'm wrong, but I don't think you can sort calculated columns as the info is not in the database but calculated in the view.

You definitely can on a calculated field in the custom form as that info is in the database so it can do the sorting logic. Is that an option? (Not sure what object this is on and not sure if everyone of those objects has a custom form in your system.)

4 replies

RandyRoberts
RandyRoberts
New Participant
January 26, 2021

I have a section at the bottom of our main project form (which is on every project) called "Admin only" where folks can see but not edit. In that section is calculated links to documents, updates and forms, etc. This way, every project has them and I can call them up in any report easily. This may work for you as well. I'm not sure if it's sort-able in a report though.

H
HaroldBa1
New Participant
January 26, 2021

I've used custom groupings in several situations where I was unable to "sort" because of the custom calculation thing. Is that an option in this case?

N
NickVa7Author
New Participant
January 19, 2021

That's interesting, Anthony...and good to know. So no sorting on calculated columns.

A calculated field could be a possibility; I'll have to weigh the value of adding one. Thanks for the suggestion.

imgrund
imgrundAccepted solution
Employee
January 19, 2021

Someone correct me if I'm wrong, but I don't think you can sort calculated columns as the info is not in the database but calculated in the view.

You definitely can on a calculated field in the custom form as that info is in the database so it can do the sorting logic. Is that an option? (Not sure what object this is on and not sure if everyone of those objects has a custom form in your system.)

Terms & ConditionsAccessibility statement

Loading footer...