Updates/Notes of This Week in Task Report (valueexpression collections) | Community
Skip to main content
March 3, 2020
Question

Updates/Notes of This Week in Task Report (valueexpression collections)

  • March 3, 2020
  • 1 reply
  • 643 views
My final goal is to have a report showing column of "all note text from this week under each task" and filter the showing tasks for some assigned user. Filter is working good, but column is not working as I wanted. Assignment Users First Name Equal Jason and Assignment Users Last Name Equal Teng and Notes Entry Date Between $$TODAYbw and $$TODAYew I am trying to do this under Task Report. And, I had success on using collections with valuefield to display all update messages. example: displayname=Notes In This Week listdelimiter= < div > listmethod=nested(updates).lists textmode=true type=iterate valuefield=message valueformat=HTML But, whenever I try to use valueexpression to do more filtering (showing note of this week only). It will just become blank. example: displayname=Notes In This Week listdelimiter= < div > listmethod=nested(updates).lists textmode=true type=iterate valueexpression=IF({updateType}=="note",{message},"") valueformat=HTML Or valueexpression=IF(CONTAINS("note",{update}.{updateType}),{update}.{message},"") I have even tried to do valueexpression with no calculation/filter, but still blank. example: displayname=Notes In This Week listdelimiter= < div > listmethod=nested(updates).lists textmode=true type=iterate valueexpression={message} valueformat=HTML It seems that valueexpression does not work under updates collections. But, I have no idea why. I am able to get valueexpression working under regular non-collection column. I also need to filter showing notes in this week. I suppose I can do it with entryDate between $$TODAYbw and $$TODAYew . But, since valueexpression is not working, I have no way to test it yet. I would be appreciated if anyone can point me to a direction on how to make weekly notes report work.. Thank you! Jason Teng
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Level 3
April 24, 2020

Hello Jason,

I did some testing on this and when accessing the Updates from the Task table, Updates is dynamic so you will not be able to manipulate the data in a valueexpression. One option would be do use a note report and then group by Task Name.

Hope this helps,

JasonTeAuthor
May 4, 2020

Thank you for taking time to test this out. I will go for the alternative Note Report approach.