Expand my Community achievements bar.

Richard_Le_
Richard_Le_
Offline
Type
  • All
  • Questions
  • Discussions
  • Ideas
  • Blogs
Filter by user contributions
  • Hey,   That's strange, it works in my instance.   Can you make sure that there is a Tab character inbetween "CUR" and "PLN"? Tab characters don't copy over from experience league into Workfront, so if you've done a straight copy and paste of my code this might be the problem.   Best Regards, Rich  

    Type

    Questions

    Views

    437

    Likes

    0

    Replies

    1
  • Hey,   Looks like you are nearly there. Since you are filtering one field against another, you need to tell Workfront you are doing this by adding "FIELD:" to your filter criteria. So "assignedToID=project:ownerID" will become "assignedToID=FIELD:project:ownerID"   assignedToID=FIELD:project:ownerID...

    Type

    Questions

    Views

    457

    Likes

    0

    Replies

    3
  • Hi,   No, i'm afraid that this isn't possible. Tasks are classed as a collection on the project object (since a project can have multiple tasks) and it's not possible to pull the values from every task into a single field.   If the desired outcome is to pass all of the task statuses on a given proje...

    Type

    Questions

    Views

    401

    Likes

    0

    Replies

    1
  • Hi,   It's possible to display all tasks with a specific custom form attached in a project report, however not as clickable hyperlinks. Tasks are classed as a collection in a project report (since a project can have multiple tasks) and to my knowledge, you can't output a clickable link from a collec...

    Type

    Questions

    Views

    447

    Likes

    0

    Replies

    1
  • Hi,   Give the following text mode a try:   descriptionkey=durationMinutes durationunitfield=durationUnit.value linkedname=direct listsort=intAsInt(durationMinutes) namekey=duration querysort=durationMinutes styledef.comparison.leftmethod=intAsInt(durationMinutes) styledef.comparison.operator=gt sty...

    Type

    Questions

    Views

    659

    Likes

    2

    Replies

    0
  • Hi,   Try using the following text mode filter on a Journal Entry Report:   entryDate=FIELD:project:actualStartDateentryDate_Mod=gt   This text mode should filter to any Journal Entries where the entry date is greater than the Project actual start date.   Best Regards, Rich.

    Type

    Questions

    Views

    305

    Like

    1

    Replies

    1
  • Hi,   I would have a go at creating a report on the Note object in Workfront. You can read more on this here.   You should be able to filter to notes (updates) where a specific team was tagged, as well as pull in high level information about the task or project the note was added to.   Best Regards,...

    Type

    Questions

    Views

    429

    Like

    1

    Replies

    0
  • Hi   That code is correct and works in my instance.   Is the custom field you have setup a single line or paragraph text field? If you are using a formatted text field to store the URL you will likely find that this wont work.   Other things to check are: Is the URL definitley correctAre there any s...

    Type

    Questions

    Views

    653

    Like

    1

    Replies

    1
  • Hi,   I don't believe this is possible whilst you are using a calculated column in your report view. Calculated columns calculate data in real time and they only exist in the view itself, the calculations are not stored anywhere for Workfront to be able to aggregate into an average or sum.   What I ...

    Type

    Questions

    Views

    422

    Like

    1

    Replies

    0
  • Hey @Madalyn_Destafney,   Sure thing, this following text mode should do it. This will only return proof approvals where the overall decision is still pending on projects where DE:Region - DX Campaign Ops = "Americas"   EXISTS:1:$$EXISTSMOD=EXISTSEXISTS:1:$$OBJCODE=DOCU EXISTS:1:versions:ID=FIELD:do...

    Type

    Questions

    Views

    441

    Likes

    0

    Replies

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