Please, help me to understand what i need to create a SQL KPI for:
- Reopened incidents
- Incidents transfered more tha n times
- incidents resolved by analys from specific rol
Thanks for your help.
John, objects/attributes should be used in SQL query for SQL type KPI.
Attributes include aliases. For example, for the exmaple I copied here
change_chg_ref_num is not an attribute for chgalg object but it is
an alias as the following:
so what it really means is change_id.chg_ref_num.
Using aliases is common as it gives SDM admin the convenince
to relate the relations easily. Hope this helps. Thanks _Chi
John, I took a quick look at some out of box SQL KPI ...I think some
of the existing ones can give some help. For example
SELECT COUNT(*) FROM chg WHERE active = 1 AND chg_ref_num IN (SELECT change_chg_ref_num FROM chgalg WHERE type = 'RO')
for "Count of Reopened Change Orders".
Please take a look at those out of box ones to see some examples. Thanks _Chi
Yes, in fact, i try that but, don't know what attribute use because change_chg_ref_num doesn't exist in chgalg object or table. So, trying to update on incidentes fail.
Did you know what reference use? physical or object or what?
Thank you Chi.
Did Chi's response clear up the question you had on this thread? Thank you
Chi, thank you very much.
It's important to mention that attribute alias are not documented but they're available in Administration tab/Service Desk/Application Data/Codes/Attribute Alias.
Using this reference query works fine.
Example for "Total active reopened incidents"
In this example request_ref_num is an alias on alg object pointing to call_req_id.ref_num
Again, thanks and regards.
Retrieving data ...