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?

[dvelloriy]

Great. Do we know the outcome if the group field is empty. (no groups associated to parts).

In this case, we need to show the value to everybody.