My favorite code snippet for reporting... what's yours?

Hi Narayan,

Thanks for posting! This is a great addition to status reports. How did you decide on the 140 character limit, just following Twitter's model? Also, is it possible to include the Time of Day on the entry date?

Andrew Beard

It just displays reasonably without adding too much vertical scroll and gave us enough information for a preview. Twitter was pretty successful with that count, so they must be doing something right. ‚ò∫

I don’t believe it’s possible to accomplish the time of day on the entry in a single calculated expression. I was able to adjust it and add a second column for the date and time of day, then setup a shared column, to achieve this. It’s not quite as straight-forward, but gives you what you need to get the following format:

Hey, was this just an older request related to the report I provided today giving insight into the BIO, or is this a little ...(open for more) -- Narayan Raum on 10/27/16 7:37 PM

The code behind the columns is:

column.12.displayname=Latest Update

column.12.namekey=latest update

column.12.sharecol=true

column.12.textmode=true

column.12.valueexpression=IF(LEN({lastNote}.{noteText})>140, CONCAT(SUBSTR({lastNote}.{noteText},0,139),"...(open for more) -- ", {lastNote}.{owner}.{name}," on "), IF(LEN({lastNote}.{noteText})>0, CONCAT({lastNote}.{noteText}," -- ", {lastNote}.{owner}.{name}," on ")))

column.12.valueformat=HTML

column.13.sharecol=true

column.13.textmode=true

column.13.valueformat=HTML

column.13.width=1

column.14.displayname=

column.14.linkedname=lastNote

column.14.namekey=view.relatedcolumn

column.14.namekeyargkey.0=lastNote

column.14.namekeyargkey.1=entryDate

column.14.querysort=lastNote:entryDate

column.14.textmode=true

column.14.valuefield=lastNote:entryDate

column.14.valueformat=longAtDate

This should work. This will just include the description, not any "last updated" information:

displayname=Description

namekey=description

textmode=true

valueexpression=IF(LEN({description})>140, CONCAT(SUBSTR({description},0,139),"...(open for more) -- "), IF(LEN({description})>0, {description}))

valueformat=HTML

I like this Narayan! Thanks.

I'll add one that I like that Kathy Leeman gave on this community earlier (for those that missed it). This text mode displays a blue circle if there is a detail description (can be used for both Tasks and Issues). And when you mouse over the blue dot, it displays the text. I like this because it saves space on the view, yet you can see the detail without clicking into the Task or Issue.

displayname=

image.case.0.comparison.icon=true

image.case.0.comparison.leftmethod=description

image.case.0.comparison.lefttext=description

image.case.0.comparison.operator=notblank

image.case.0.comparison.operatortype=string

image.case.0.comparison.righttext=

image.case.0.comparison.truetext=/static/img/r15/icons/casebuilder/light_blue.gif

image.namevalue=string(description)

image.valuefield=description

linkedname=direct

shortview=false

textmode=true

valuefield=description

valueformat=HTML

My favorite snippet of code is doing a task collection on a project report. This way I can get all the project information for a status report but can also include the incomplete tasks due in the next week.

[Side note: One issue that makes some groups not like this is that tasks don't come back in chronological order. Wanted to give you that heads up]

displayname=Tasks For The Next Week

listdelimiter=

listmethod=nested(tasks).lists

textmode=true

type=iterate

valueexpression=IF({plannedCompletionDate}<$$TODAYe+5d,IF(ISBLANK({actualCompletionDate}),CONCAT({name}," (",{plannedCompletionDate},") || ")))

valueformat=HTML