- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-28-2022 10:38 AM - edited 12-29-2022 06:37 AM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-29-2022 10:15 AM - edited 12-29-2022 10:17 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-29-2022 11:33 AM
Hey saurav,
Actually his query also wrong because two AND condition for same type field won't be possible
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-29-2022 11:39 AM
Try this then
addEncodedQuery("type=PPM Agile Group^ORtype=PPM Work Center");