How to create custom field in database view in service now?

[vickyc]

Hi  Team,

Can we create a custom field in Database view in service now.

For Example

we have a employee table and have joined with Department table.

And In Department table we have a field called Name .Its contains values like  'ABC. Managed', 'FDC.Unmanaged', 'XYZ.SemiManaged' etc.

however instead of showing complete string from Name field , we have to display like

Case when Name like '*Managed' then 'Managed' else case when Name like '*unmanaged' then 'Unmanaged' else case when name like '*SemiManaged' then Semimanaged else Name END END END.

Please confirm how we can achieve in this reporting .

thanks in advance

[Padmanabam Tiru]

Hi,

You can use scripted breakdowns for this. Create your indicator on the database view table to return all employees with any specific criteria if you have any. Then create a bucket group with elements as Managed, UnManaged, SemiManaged etc as you wish and define ranges for them. Now create breakdown source using this bucket group and create a breakdown using this breakdown source and in breakdown mapping use a script for mapping. The script should be coded in  such a way that it takes input as Name of user and chek if user has name Managed return it to bucket Managed, else UnManaged return it to UnManaged group and so on. When you collect the scores , this breakdown will show all users which are falling under different buckets like Managed, Unmanaged etc., For more details of Buckets and script mapping refer to below urls:

https://docs.servicenow.com/bundle/kingston-performance-analytics-and-reporting/page/use/performance-analytics/concept/c_BucketGroups.html

https://docs.servicenow.com/bundle/kingston-performance-analytics-and-reporting/page/use/performance-analytics/task/example-script-mapping.html

[Ulrich Jugl]

If you are talking only reporting, you might check out Reporting Ranges (here). Maybe this can solve your challenge if your field is a choice list.

[Kuldeep Kumavat]

You can try using Multiple Data sets in a report. This feature required Performance Analytics Premium for versions prior to Jakarta, from Jakarta they have made it available to all users.

You can create different Data Sets for UnManaged and SemiManaged. You can filter the conditions of the main report to display only "Managed" records

Regards,

Kuldeep