Synchro Script Comparison between two Start Dates

Question

Hello, 
 
 I want to assign an Apperance Profile. Therefore I need 3 conditions. 
 1. I only want Tasks from the same segment which is written in the column "Name" of Task (in this example " TTT") 
 2. I only want the Tasks which have the user field value "XXX" and "YYY" in the User Field "BB" 
 3. I only want the tasks, if they have the same start date. 
 That is what I got so far: 
 TASK.ASSIGNMENT (TASK(TASK.UFV("BB")>="XXX" ).PROPERTY("Start") == TASK.(TASK.UFV("BB")>="YYY" ).PROPERTY("Start") AND TASK.NAME>="TTT" ) SET_PROPERTY ( PROPERTY("Appearance Profile"), ALL_USE_PROFILE( NAME>= "XXX + YYY" )) 
 
 I know that following things work: 
 TASK.ASSIGNMENT(TASK.NAME>="TTT" ) SET_PROPERTY ( PROPERTY("Appearance Profile"), ALL_USE_PROFILE( NAME>= "XXX + YYY" )) 
 
 But I don't have a solution for the comparison. 
 
 Thanks for your help

Arpit Prakash · Accepted Answer

Hi Margaretha, Thank you for the clarifications and really sorry for the delayed response! 
 Unfortunately, you will not be able to achieve the desired result using just a singular script. The issue here is that there's no way of comparing self-referenced data within a filtered task list. However, with a bit of manual work, you can still get the same result - 
 
 Create a Task Filter for the first two conditions - Alternatively, you can write a script as well but to create a new User Field for filtering the Tasks - TASK(NAME<>"TTT" AND UFV("BB")=="XXX" OR UFV("BB")=="YYY" ) ASSIGN_UF("Filter", STRING, "Yes") 
 Now that you have a list of the filtered Tasks, you can manually sort our the Start Date/Finish Date, thus fulfilling the third condition - 
 And lastly, you select these Tasks and run the script to assign the Appearance Profile - TASK(SELECTED).ASSIGNMENT SET_PROPERTY ( PROPERTY("Appearance Profile"), ALL_USE_PROFILE( "Appearance Profile Name)) 
 
 Another workaround could be through using MS Excel, where similar formula as above could be easily applied and get a User Field imported in, with the correct Appearance Profile data. That might save you a few manual steps if working with a large data and you have to run this multiple times. 
 Hope this helps a bit!

Synchro Script Comparison between two Start Dates

Top Replies