Need Recommendation on best approach

[dvelloriy]

Hello All,

I have a requirement where i need your suggestions.

We have a custom table "x_piece_description". Here we are storing different Parts related data like HDMI cable, Docking stations, Powe supply, USB mouse, keyboards etc. There are few columns which indicate the device type, model, model category for all these parts.

This table is being referenced in one of our catalogs for Break- fix form. There is a variable to add parts, which provides a list of all parts from Piece description table to select from.

Requirement is to add some sort of ranking or sorting to piece description table so they appear in a certain sequence when you click on Add parts variable on catalog form. Please note that data in piece description table is dynamic in the sense customer is adding/removing parts on daily basis. so they need an ability to assign some order to these piece descrption records so they appear in a seqential order on the form.

Like we have usb monitor 1, usb monitor 2, usb monitor 3, and so on.

if i assign ranking 10 to usb monitor 1, 

20 to usb monitor 2

then usb monitor 1 should appear first.

I think we would need a new field "ranking" to be created on the piece descrption table, assign ranking for all records and let customers maintain that field going forward.

How can we leverage this new field to define sequencing on "Add parts" variable on form is something i need inputs on?

[Allen Andreas]

Hello,

Yes, you can create a sequence/ranking/order, whatever you want to call it for your custom table. Previous discussion can be found here: https://www.servicenow.com/community/developer-forum/can-i-add-an-quot-order-quot-filed-in-custom-lo... 

Additional documentation to help is here: https://docs.servicenow.com/bundle/washingtondc-platform-administration/page/administer/list-adminis... 

[Allen Andreas]

Hi @dvelloriy 

Let me know if you have any other questions and I'll do my best to assist.

If I've helped guide you correctly, please mark my above reply as "Accept Solution".

Take care! 😀

[dvelloriy]

Thanks Allen, this is helpful, will try this out shortly.

Also 1 more thing. We are planning to create 1 more custom field "Group" on piece description table. This will refer to groups table and will mainly be populated with 3 existing groups.

Requirement is to filter the piece description list and display values based on groups.

So, if USB monitor and Docking station is tagged to Group "ABC". If member of Group ABC is creating a request, he should just see USB monitor and docking station only not other piece description values.

This will be true for other 2 groups as well.

What is the best way to do that? Do we need to configure ACL's for each group?

[Allen Andreas]

Hi,

On the request (catalog item, form, whatever) where you have this reference field and they are picking values, you'd want to add additional reference qualifier to that field to say

• group is dynamic one of my groups

So essentially, you'd limit the results to only show them records from this table that have a group field that matches one of the groups they are a member of.