Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

JonathanTh
JonathanTh
Offline

Badges

Badges
0

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
8

Posts

Posts
46

Discussions

Discussions
8

Questions

Questions
38

Ideas

Ideas
7

Blog Posts

Blog Posts
0
Top badges earned by JonathanTh
Customize the badges you want to showcase on your profile
Re: In/Not In Operator - Workfront Fusion 2.0 26-05-2021
Hi Stuart For the filter module you use "Contains", however what I was doing wrong was using it the wrong way around. I had my filter set as "Status" Contains "[ARRAY]" where it should have been "[ARRAY]" contains "Status" I also had the OR function working, however it turns out it wasn't working and this was Darin's explanation: The execution was using the “Boolean operator: Equal To” A Boolean comparison will used against a non-boolean field type like this will basically revert to standard jav...

Views

35

Likes

0

Replies

0
Re: Is there a way to calculate business days/hours between 2 dates with Fusion 2.0? - Workfront Fusion 2.0 16-04-2021
HI Krissy This is something that i have asked about in the past, and because you cannot perform a calculation such as WEEKDAYDIFF in FUSION i hit a bit of a brick wall. However there are two ways that this can be addressed (that i am aware of) You would have to spin up a calculated field and two date fields within Workfront itself (somewhere). If you populate the two date fields using FUSION and another module to read back the calculation using FUSION then you can take that result and use it whe...

Views

18

Likes

0

Replies

1
Re: In/Not In Operator - Workfront Fusion 2.0 14-04-2021
Hi Darin This is interesting as the reason I did this is because i had initially tried with the array but with no success. I've detailed out the two methods and an example of the results returned: OR Filter: This appears to work as expected and an example of the bundles passing through is here: Array / Contains Filter: This doesn't appear to allow anything through: So this is why i initially thought i was over complicating things....... Appreciate your time on this one, and hopefully you will be...

Views

35

Likes

0

Replies

0
Re: In/Not In Operator - Workfront Fusion 2.0 14-04-2021
‚ I have one question off the back of this..... This is great for the search module but can something similar be used on a filter between modules? The reason being i also face the same issue with repeating common criteria. An example to support this ask would be: Category ID = [Category ID 1]-and-Last Updated By != [User 1] -OR- Category ID = [Category ID 2]-and-Last Updated By != [User 1] It would obviously be much easier (especially if there a numerous Category ID's) to have a filter that says...

Views

35

Likes

0

Replies

0
Re: In/Not In Operator - Workfront Fusion 2.0 14-04-2021
Hi Darin Thanks for this, just what i needed! This will make things a whole lot easier as you say for not having to repeat common criteria! Thanks again

Views

35

Likes

0

Replies

4
In/Not In Operator - Workfront Fusion 2.0 31-03-2021
Hi All So i find myself a bit stuck with using the "In" operator. Fusion 2.0 suggests i should do this as i want to find all Projects that are either "AWA"" or "PLN" (I am aware my screenshot only shows "PLN" at present) What i cant seem to figure is how to do this in the above module? There will be several other "AND Rules" statements to follow this. I have written countless API queries and always end up going down the road of something like: proj/search?status=AWA&status=PLN&status_Mod=in So h...

Views

35

Like

1

Replies

12
Re: Add Issues to typeahead custom fields - Workfront 25-02-2021
I have the same request but for referencing a particular task.The use case is within a project there is a form where this is used to validate and move a task from a different project (and some other bits that Fusion would need to do) to the current project. I would hope to be able to filter the field to only point at a few projects where these tasks would always be until moved.

Views

19

Likes

0

Replies

0
Re: Layout Template based on type of Project - Workfront 20-10-2020
We definitely need something like this also. Out use case is that generally different groups of users have layout templates geared towards the way they work (especially pinned dashboards/views within a project).The issue we face is when we may want to a user from another group to work on a piece of work they wouldn't usually be involved with, and therefore the visibility if that project generally makes no sense due to the dashboards/views that are configured by their layout template. The only is...

Views

9

Likes

0

Replies

0
Re: Referencing the same field in a report filter AND statement - Workfront 09-09-2020
Just an quick update. I think this is simpler that i thought it was going to be as i can just use the following: categoryID=categoryID_Mod=notinobjectCategories:ID_Mod=notblank

Views

13

Likes

0

Replies

1
Re: Referencing the same field in a report filter AND statement - Workfront 09-09-2020
Hi Doug Thanks for the advice. I will give this a go. I have done a few things with objectCategories via the API in the past so i see where you are coming from here. I will update this thread when i have given this a go! Thanks

Views

13

Likes

0

Replies

0