Use of querysort (text mode) on custom columns within project view | Adobe Higher Education
Skip to main content
N
NickVa7
Level 9
January 18, 2021
Respondido

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

  • January 18, 2021
  • 4 respostas
  • 888 Visualizações

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

Este tópico foi fechado para respostas.
Melhor resposta por 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 Respostas

imgrund
Adobe Employee
imgrundAdobe EmployeeResposta
Adobe 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.)

N
NickVa7Autor
Level 9
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.

H
HaroldBa1
Level 2
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?

RandyRoberts
Community Advisor
RandyRobertsCommunity Advisor
Community Advisor
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.

Termos e condiçõesAccessibility statement

Loading footer...