Assigned group and Assigned to fields adjustments.

Nataliia_Lova
Tera Guru

Hello, Community
The advice from you is needed:
I have a scope application; my Table was extended from Task.
I need some adjustments for the "Assignment group" and "Assigned to" fields.
The "Assigned group" field has to refer to appropriate groups: Finance Admin, Finance Team, Finance Dispatching (parent group is Finance Team), Finance User.
The "Assigned to" field has to refer to members of these groups.

Where can I get information about how to adjust it?

I need a low-code or no-code solution.
1 ACCEPTED SOLUTION

1. On the finance department form, click the context menu icon top left and then click "copy sysid"
2. In the reference qualifier field (in my previous screenshot), write type=numberofyoursisid 

If you want more conditions then just the type:
1. Filter navigator -> type sys_user_group.list
2. Enter any conditions you want, example:

JaeggerLegane_0-1704895640001.png

3. Right-click and choose copy query:

JaeggerLegane_1-1704895686977.png

4. Copy paste that to the reference qualifier field

 

--------------------------------------------------------------------------------
If my post helped you, please click the accept solution button and hit the thumbs up! Thank you!

View solution in original post

12 REPLIES 12

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Nataliia_Lova 

 

You want to show only these groups in Assignement group?

 

If yes

 then create a a new group type and use that as below

LearnNGrowAtul_0-1704891287423.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

JaeggerLegane
Kilo Sage

This should be achievable with following steps:
1. Search the fields in dictionary

2. Create a dictionary override so that your changes don't affect the task table or any other extended tables

JaeggerLegane_0-1704891243519.png
3. In the disctionary override selectyour custom table
4. Set override reference qualifier
5. In the reference qualifier field, enter the query which contains your conditions that select only those specific groups. 
In my example below you'll see that it queries only groups with a specific type.

JaeggerLegane_1-1704891387238.png

 

--------------------------------------------------------------------------------
If my post helped you, please click the accept solution button and hit the thumbs up! Thank you!

I create a new Type in sys_user_group_type_list.do. 

2.png

There are only two fields for specifications.

1.png

5. In the reference qualifier field, enter the query which contains your conditions that select only those specific groups. 

👆Where can I create my conditions?

1. On the finance department form, click the context menu icon top left and then click "copy sysid"
2. In the reference qualifier field (in my previous screenshot), write type=numberofyoursisid 

If you want more conditions then just the type:
1. Filter navigator -> type sys_user_group.list
2. Enter any conditions you want, example:

JaeggerLegane_0-1704895640001.png

3. Right-click and choose copy query:

JaeggerLegane_1-1704895686977.png

4. Copy paste that to the reference qualifier field

 

--------------------------------------------------------------------------------
If my post helped you, please click the accept solution button and hit the thumbs up! Thank you!