Does anyone have textmode that allows me to group on 'Document Source'? | Community
Skip to main content
Level 5
April 19, 2021
Solved

Does anyone have textmode that allows me to group on 'Document Source'?

  • April 19, 2021
  • 2 replies
  • 800 views

Within a project, I have been able to include the following textmode in a custom view to see the document source, but I would also like the ability to group by as well.

Custom textmode in View for Document Source

descriptionkey=sourceobject

displayname=Document Source

link.linkproperty.0.name=ID

link.linkproperty.0.valuefield=referenceObjID

link.linkproperty.0.valueformat=string

link.lookup=link.view

link.nestedobjcode=string(referenceObjCode)

link.nestedobjid=string(referenceObjID)

link.valuefield=referenceObjCode

link.valueformat=val

namekey=sourceobject.abbr

stretch=0

textmode=true

valuefield=referenceObjectName

valueformat=HTML

width=151

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 William--

The below will group first by the kind of object to which the documents are attached (were they added directly to the project, or one of its tasks, or one of its requests); then by the item it was attached to:

group.0.displayname=Attached To

group.0.valueexpression=IF({docObjCode}="OPTASK","Requests",IF({docObjCode}="TASK","Tasks",IF({docObjCode}="PROJ","Project",IF({docObjCode}="PRGM","Program",IF({docObjCode}="PORT","Portfolio",{docObjCode})))))

group.0.valueformat=HTML

group.1.displayname=On

group.1.valuefield=referenceObjectName

group.1.valueformat=HTML

textmode=true

If you don't want the initial grouping of Project/Task/Request, you can use this:

group.0.displayname=Source

group.0.valuefield=referenceObjectName

group.0.valueformat=HTML

textmode=true

2 replies

imgrund
Adobe Employee
Adobe Employee
April 19, 2021

Hi - I think you might be out of luck. I looked at the API explorer and it has a flag of "Not Groupable" 😞

tracy_foxAuthor
Level 5
April 19, 2021

Aw that makes me very 😢 thank you for trying @Anthony Imgrund‚

William--
Community Advisor
William--Community AdvisorAccepted solution
Community Advisor
April 20, 2021

The below will group first by the kind of object to which the documents are attached (were they added directly to the project, or one of its tasks, or one of its requests); then by the item it was attached to:

group.0.displayname=Attached To

group.0.valueexpression=IF({docObjCode}="OPTASK","Requests",IF({docObjCode}="TASK","Tasks",IF({docObjCode}="PROJ","Project",IF({docObjCode}="PRGM","Program",IF({docObjCode}="PORT","Portfolio",{docObjCode})))))

group.0.valueformat=HTML

group.1.displayname=On

group.1.valuefield=referenceObjectName

group.1.valueformat=HTML

textmode=true

If you don't want the initial grouping of Project/Task/Request, you can use this:

group.0.displayname=Source

group.0.valuefield=referenceObjectName

group.0.valueformat=HTML

textmode=true

If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf
tracy_foxAuthor
Level 5
April 20, 2021

Thank you so much William!

Worked as I had hoped.