ServiceNow Reference Qualifiers | Complete Guide with Practical Examples | ServiceNowWithAK — Transcript

Full transcript

1. 0:00Now, next thing I want to show you about
2. 0:03a reference qualifier. What is a
3. 0:04reference qualifier?
4. 0:06This question was asked from me at least
5. 0:09more than 25 or 30 interviews. What is a
6. 0:12reference qualifier? What are the types
7. 0:13of reference qualifier?
8. 0:15And other things as well.
9. 0:17So,
10. 0:18the name reference qualifier itself has
11. 0:20a reference in the topic.
12. 0:23So, which are reference field over here?
13. 0:25Can anyone highlight?
14. 0:28>> Caller.
15. 0:31>> Yes, caller and
16. 0:34Which one?
17. 0:35>> Uh assignment group.
18. 0:37Sign group.
19. 0:37>> Okay.
20. 0:38Yes.
21. 0:43>> Configuration item location are the
22. 0:45reference field.
23. 0:46>> Yes. And I told you that we have this
24. 0:49watch list also and work notes also. We
25. 0:51are list type where we are also
26. 0:53reference referencing to some different
27. 0:55table.
28. 0:56See, we are referencing to the sys_user
29. 0:59table.
30. 1:00So, this
31. 1:01>> Assignment group.
32. 1:03>> This reference qualifier will apply only
33. 1:05to this to this two fields, two field
34. 1:07types.
35. 1:08Reference field and list field.
36. 1:11Got it?
37. 1:12So, right now, if you will hover here
38. 1:15here and if you will click here,
39. 1:17how many users you will able to see?
40. 1:23How many it is?
41. 1:24>> 621.
42. 1:26>> 661? If I will refresh on the user
43. 1:29table,
44. 1:30here also you will find 661.
45. 1:34Are you all getting it?
46. 1:36So, my requirement is
47. 1:38I need only active users on my form. If
48. 1:41I will select this, I need only active
49. 1:44users over here. I want to see only
50. 1:46active users. I don't want to see all
51. 1:48the users.
52. 1:50So, if you will come to user table and
53. 1:52here it is active, if you will show
54. 1:53matching with the active only,
55. 1:56you see 560?
56. 1:58So, only 560 users I want to show to
57. 2:01some end users. So, instead of the 661,
58. 2:05I want to show 560. So, how we can do
59. 2:07that?
60. 2:09With the help of reference qualifier.
61. 2:11If we'll go here, configure dictionary.
62. 2:21You see reference specification.
63. 2:23And one minute, let me make it advanced
64. 2:26view.
65. 2:32You can see when I make the advanced
66. 2:33view, you can see use reference
67. 2:35qualifier. And now reference qualifier
68. 2:37condition I have to give. So, I need
69. 2:39only active true.
70. 2:42Whatever user is active, reference field
71. 2:44is always user because I have selected
72. 2:46the user field.
73. 2:48So, I have selected active is true. Now,
74. 2:50I will save it.
75. 2:56And now
76. 2:59it is
77. 3:00saving.
78. 3:05Now, if we'll come here and refresh it,
79. 3:10you will see
80. 3:11only 560 field. Correct? You are not
81. 3:14able to see whole fields now,
82. 3:17which is
83. 3:18661.
84. 3:20You will be able to see only 560 field,
85. 3:22which are active only.
86. 3:25Same as it is, if I will go to this
87. 3:27assignment group, here you can see I am
88. 3:30able to see 79 groups.
89. 3:32So, here also you can apply reference
90. 3:34qualifier.
91. 3:36And here also in watch list, I am able
92. 3:38to see all the users. Suppose in watch
93. 3:41list,
94. 3:42I will make it configure dictionary.
95. 3:50And
96. 3:51in that one's view
97. 4:03Now, I will take some another condition
98. 4:06suppose department.
99. 4:08Whose department is suppose
100. 4:11I need only finance department
101. 4:13people on my watch list.
102. 4:16So, I have used department is finance.
103. 4:19Now, I will save it.
104. 4:23So, only finance related department
105. 4:25people will come to the watch list one.
106. 4:31If I will refresh
107. 4:35in the watch list
108. 4:37>> [clears throat]
109. 4:38>> you see only 38 field we are able to see
110. 4:41and this 38 are
111. 4:43finance department. If you will go to
112. 4:45this one and department uh
113. 4:48finance one if I will show matching
114. 4:51you see 38
115. 4:53and same one you are able to see over
116. 4:55here 38.
117. 4:58So, now you got it what is the use of
118. 4:59this reference qualifier?