Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

How to group by Custom Date Field Two Tables away

Avatar

Level 1

Hi,

I have created a proof approval report within which I need to group the results by a custom date field.

I have been sucessfull in pulling the date field "Internal Due Date" from both the Project custom form and then advised to pull it from the Document Custom Form.

The data is coming in and showing on the report.

I now want to group by this column; below is the grouping Text Mode I am trying to use, but it just cannot seem to pull the data.

group.0.linkedname=approver

group.0.namekey=view.relatedcolumn

group.0.namekeyargkey.0=approver

group.0.namekeyargkey.1=name

group.0.valuefield=approver:name

group.0.valueformat=string

group.1.displayname=Project Internal Due Date

group.1.linkedname=documentVersion

group.1.namekey=view.relatedcolumn

group.1.namekeyargkey.0=document:DE:EACG Project Internal Due Doc

group.1.valuefield=documentVersion:document:DE:EACG Project Internal Due Doc

group.1.valueformat=fullAtDate

textmode=true

(ignore group.0.; this works fine)

Below is the text mode I am using to pull the custom field date into the report itself (just as an FYI)

displayname=Project Internal Due Date

querysort=documentVersion:document:DE:EACG Project Internal Due Doc

textmode=true

valuefield=documentVersion:document:DE:EACG Project Internal Due Doc

valueformat=fullAtDate

Can someone please advise on the grouping; I am stumped and not sure how to get around it. Please help you genius people out there!

Nitesh

Topics

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

1 Reply

Avatar

Employee

@Nitesh D'Souza‚ If you were to swap your valuefield line to a valueexpression, that should do the trick. With custom fields, the DE: can oftentimes mess up a grouping because it's thinking it's referencing another field/table.

group.0.linkedname=approver

group.0.namekey=view.relatedcolumn

group.0.namekeyargkey.0=approver

group.0.namekeyargkey.1=name

group.0.valuefield=approver:name

group.0.valueformat=string

group.1.displayname=Project Internal Due Date

group.1.linkedname=documentVersion

group.1.namekey=view.relatedcolumn

group.1.namekeyargkey.0=document:DE:EACG Project Internal Due Doc

group.1.valueexpression={documentVersion}.{document}.{DE:EACG Project Internal Due Doc}

group.1.valueformat=fullAtDate

textmode=true