Hello,
I am having trouble setting up the logic for the Assignment Group in the Project Task form.
I have created a custom field called 'PPM Group Type' with two options:
(PPM Agile Group) and (PPM Work Center).
I want the 'Assignment Group' to show all the Groups associate with the (Agile Team AND PPM Work Center) type when (PPM Agile Group) is selected.
Query:
active=true^typeLIKEe350a0be2ff31110bd13a85df699b69b^typeLIKE1c5064fe2ff31110bd13a85df699b60b
I want the 'Assignment Group' to show all the Groups associate with the (PPM Work Center) type when (PPM Work Center) is selected.
Query:
active=true^typeNOT LIKEe350a0be2ff31110bd13a85df699b69b^typeLIKE1c5064fe2ff31110bd13a85df699b60b
Currently, the 'Assignment Group' has a reference qual condition in place.
Thank you for your help with this.
Hey ,
1. Whenever in reference qualifier if you write script first put javascript : and then write the logic.
2. Kindly check in the dictionary override tab, the table is there or not on which you want this assignment group to to show records. We need to make changes in child table's reference qualifier and leave the parent table field (assignment_group) as it is.
e.g. - below assignment_group is on task table but i want to change reference qualifier on pm_project_task table which is child table of 'task' table.
So, I'll do the change in child table (pm_project_task) of override reference qualifier.
After javascript followed by colon sign , you can write your logic.
Hope this helps!
Kindly mark my responses helpful if it guides you to solutions or help you to understand.
Regards,
Kartik
Check like below, it's working for me.
Give me sometime, I need to replicate your scenario.
Regards,
Kartik
Hi Kartik, thank you so much for all your time. It works. I re-wrote the script include and the Overrides Reference Qualifier and it works.
Here is the script include I wrote:
Then under the 'Assignment Group' > Dictionary Overrides > 'pm_project_task' table > Override reference qualifier I apply this script below:
and here is the results:
Thanks again, Kartik, you saved my day.
Thanks. Yes, I already did remove the script from the Parent Table's reference qualifier. Now, in that reference qualifier has this query:
I have replicated the same (without PPM group condition for now). Have a look for future reference.
Script Include method -
Reference Qua-
Assignment Group-
______________________________________________________________________________________
I want to understand one point, when I use the same filter with AND condition for TYPE field.
I don't get any records.
Regards,
Kartik Choudhary
