Help with report view text mode - aggregating notes from multiple child tasks into a single column | Community
Skip to main content
J
JessicaEa
October 12, 2024
Question

Help with report view text mode - aggregating notes from multiple child tasks into a single column

  • October 12, 2024
  • 1 reply
  • 1318 views

Hi,

I am trying to generate a custom column in a view in a report which lists all the notes sitting under a parent task, but this is pulling nothing.

Is there a way to do this?

displayname=Last Note
listdelimiter=<br>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF(ISBLANK({lastNoteText}), "", CONCAT({lastNoteDate}, " ", {lastNoteOwner}.{name}, " said: ", {lastNoteText}))
valueformat=HTML

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

1 reply

Sven-atClient
Sven-atClient
October 12, 2024

Hi @jessicaea 
I would counsel against this approach - due to the large number of notes you're going to iterate through on each parent task.

A parent tasks' parent would display duplicates, too. 

 

also lastNote doesn't give you "all the notes" - it's simple the latest Update on the object. 

J
JessicaEaAuthor
October 13, 2024

Hi @sven-atclient 

Thank you for your advice.

Can you further explain your comment "A parent tasks' parent would display duplicates, too."?

You are correct the lastNote doesn't display all notes. Thank you as that clarifies things for me - I am actually looking to list all  last notes on any child task of the parent task listed in the report.

If you think this isn't the best approach, can you advise what might be a better way forwards?

J
JessicaEaAuthor
October 19, 2024

Hi @jessicaea 

OK - so only the late note = that makes sense as a report

 

RE duplicates: I was wrong (and edited this response) 

lastNote is the update put in at the specific task, so there's no duplication. 

 

You don't need to iterate but yoru textMode was off. 

use this:

valueexpression=IF(ISBLANK({lastNote}.{noteText}), "", CONCAT({lastNote}.{entryDate}, " ", {lastNote}.{enteredBy}.{name}, " said: ", {lastNote}.{noteText}))

 

check the API explorer where you can see that lastNote is an object a Task refers to. and lastNote in turn has attributes. 


Hi Sven, thank you for the advice! I did need to iterate to pick up all last notes on all children of the task. This is the code that worked for me:

 

displayname=Last Note
listdelimiter=<p>
listmethod=nested(children).lists
textmode=true
type=iterate
valueexpression=IF(ISBLANK({lastNote}.{noteText}),"",CONCAT({lastNote}.{entryDate}," ",{lastNote}.{owner}.{name}," said: ",{lastNote}.{noteText}))
valueformat=HTML

Terms & ConditionsAccessibility statement

Loading footer...