CA Service Management

Hi! I have an offering that has more than 250 products to offer. We need to order them alphabetically. Is there a way to do it automatically? With the out of the box option we can order them manually but with so many options Service Catalog's performance goes down and it is also impossible to do it.

Regards

Sebastian

Good Afternoon Sebastian.

Please explain in detail which sort order you are refering to?
1 The order of Offerings from within an Offering Folder?
2 The order of SOGs from within an Offering?
3 The order of Options from within an SOG?

Thanks in advance and kind regards, Louis.

Hi Louis! Thanks for your answer

I mean number 3: The order of the options from within a SOG

In this case I use it to list all our software available to request to install.

Regards

Good Afternoon Sebastian.

Open an SOG:

And click on the 'Organize Options' button:

Then you can drag and drop to re-order the options.

Unfortunately, there seems no way to re-order the options in an overall view/setting/definition.

Kind regards, Louis.

Thanks Louis! I know that option but unfortunately when you have more than 250 options it is not efficient and also the performance is really painfull.

Do you know if there is another way? Even throug the DB

Good Afternoon Sebastian.

I anticipated on that question, yes.

1. For a possible mdb update, search for offering_id
select offering_id,offering_name from usm_offering where offering_name like '%Desk Phone Acc%'

2a. Take offering_id from 1-result. The offering_id shows 10121. And the next query then is:
select
o.offering_id,o.offering_name,
ori.id,ori.parent_id,
rp.rate_plan_id,rp.rate_plan_name,rp.description,
rd.rate_plan_id,rd.rate_row,rd.rate_col,rd.item_text,rd.text_1,rd.category,rd.category_class
from usm_offering o,usm_offering_rplan_inclusion ori,usm_rate_plan rp,usm_rate_definition rd
where o.offering_id=10121
and o.offering_id = ori.parent_id
and ori.child_id = rp.rate_plan_id
and rp.rate_plan_id = rd.rate_plan_id
order by rate_row,rate_col asc

The rate_row and rate_col values, determine the order in which the options appear in the SOG.
Which seems not to be easy to change that through an mdb update query.
-----
2b. To only select the SOG-option names:
select
o.offering_id,o.offering_name,
ori.id,ori.parent_id,
rp.rate_plan_id,rp.rate_plan_name,rp.description,
rd.rate_plan_id,rd.rate_row,rd.rate_col,rd.item_text,rd.text_1,rd.category,rd.category_class
from usm_offering o,usm_offering_rplan_inclusion ori,usm_rate_plan rp,usm_rate_definition rd
where o.offering_id=10121
and o.offering_id = ori.parent_id
and ori.child_id = rp.rate_plan_id
and rp.rate_plan_id = rd.rate_plan_id
and rate_col = 0
order by rate_row,rate_col asc

Should you decide >> Please be careful!!

Stop all mdb processing and make a backup first.

Kind regards, Louis.

Great! I got the right list, so to order them i should change the values on rate_row?

Regards

Good Morning Sebastian.

Yes indeed. To re-order change the value of the rate_row column.

As you executed query1, you'll see that there are multiple rows with the same rate_row value.

And while updating, you then (of course) need to update them all.

Please be careful in updating such in the mdb though.

I am not sure whether there is a link to other tables in the mdb, based on this rate_row column value.

Which gets corrupted while updating.

And stop all mdb access (SC, SDM, ITAM, ??) and make a backup up front.

Kind regards, Louis.