Expand my Community achievements bar.

Richard_Le_
Richard_Le_
Offline
Type
  • All
  • Questions
  • Discussions
  • Ideas
  • Blogs
Filter by user contributions
  • Hey Doug,   Thanks for the comprehensive response and all your efforts looking into this my friend. Greatly appreciated.   I was hoping to avoid calling the Notes object directly, since this will return multiple bundles and will require some creative filtering. C'est la via. Should still be able to ...

    Type

    Questions

    Views

    599

    Like

    1

    Replies

    0
  • That filter should work. Do you have other filter rules set up other than what you have pasted into your question?    

    Type

    Questions

    Views

    1.5K

    Likes

    0

    Replies

    1
  • I have a scenario built that will periodically check for On Hold Projects which and retrieve all updates (notes) made to that project since it was put on hold. If the Project sponsor has not provided an update since it was put on hold after a given timeframe, reminders will be sent out and/or the pr...

    Type

    Questions

    Views

    656

    Likes

    0

    Replies

    3
  • Hi Karen,   To display the project owner name in a task report, the following text mode in a column would do it:   displayname= Project Ownerlinkedname=projectquerysort=project:ownerIDtextmode=truevaluefield=project:owner:namevalueformat=HTML   Regards, Rich 

    Type

    Questions

    Views

    1.8K

    Likes

    0

    Replies

    4
  • Ahh, I've got you. You need an extra line of code in what I supplied to filter for tasks that are not yet complete then, this will do the trick:   EXISTS:a:$$EXISTSMOD=EXISTSEXISTS:a:$$OBJCODE=TASKEXISTS:a:actualCompletionDate_Mod=isnullEXISTS:a:name=Add instructorsEXISTS:a:name_Mod=cicontainsEXISTS...

    Type

    Questions

    Views

    1.8K

    Likes

    0

    Replies

    7
  • Can you clarify what it is you’re trying to achieve?   Are you trying to display all projects that contain a task with the name “Add instructors”. The code I have supplied as a text mode filter (not in a column) will work.    Or are you trying to show this task name in a column within your report. I...

    Type

    Questions

    Views

    1.8K

    Likes

    0

    Replies

    9
  • Hi Karen,   Are you wanting the report to only show projects that contain a task with that name? If yes, you will need to use an Exists filter and the following would do it:   EXISTS:a:$$EXISTSMOD=EXISTSEXISTS:a:$$OBJCODE=TASKEXISTS:a:name=Add instructorsEXISTS:a:name_Mod=cicontainsEXISTS:a:projectI...

    Type

    Questions

    Views

    1.9K

    Likes

    0

    Replies

    11
  • Hi Brendan,   Dates within the Workfront UI are controlled by your browser's Language settings, not settings in Workfront itself. If your browser is set to English (American) then dates will display as MM/DD/YYYY, but if your browser it set to English (United Kingdom) dates will display as DD/MM/YYY...

    Type

    Questions

    Views

    1.8K

    Like

    1

    Replies

    1
  • Hi Justin,   Try the following text mode:   displayname=Proofslistdelimiter=<p>listmethod=nested(documents).liststextmode=truetype=iteratevalueexpression=IF(!ISBLANK({currentVersion}.{proofID}),CONCAT({name}," - ",{currentVersion}.{entryDate}),"")valueformat=HTML   This will show all proofs that hav...

    Type

    Questions

    Views

    1.0K

    Like

    1

    Replies

    5
  • Hi,   This is possible to achieve, but it will involve adding calculated fields to your projects that capture a timestamp of when the project was set to a particular status. You would then be able to measure the difference between these timestamps and work out the duration that the project was in th...

    Type

    Questions

    Views

    747

    Likes

    0

    Replies

    0
Top badges earned by Richard_Le_
Customize the badges you want to showcase on your profile