Populate Category and Subcategory based on CI

[saisowmya]

Hello All,

We have a requirement on Incident form where the category and subcategory should be populated based on CI and also if category and sub category is changed the CI should be modified.

We have a table 'ABC' which contains all the 3 fields Category, subcategory and their respective CI.

Now my question is I'm able to do the first scenario ie, populating the category and subcaterogy based on CI. But to do achieve the second scenario my two fields category and subcategory cannot be normal string fields, they should be referencing to my ABC table, but the display value of my ABC table is the CI name.

Can anyone tell me how can I achieve this by using the same table.

[larstange]

Hi

You don't have to change the catagory and subcategory fields - keep them as strings.

You can build it in a client script or a business rule, depending on when you want the fields to change (real time or when the record is saved)

The client script or business rule will run when the category and subcategory fields are changed and will query the ABC table for the specific combination.

The record which matches, will contain the CI while you will then apply to the CI field on the incident.

[Saroj Patel1]

//create onchange for configuration item field and remove dependancy between company and ci in incident form

function onChange(control, oldValue, newValue, isLoading, isTemplate) {

    if (isLoading) {

        return;

    }

    var category = Array.from(g_form.getElement('category')).map(function(item) {

        return item.text;

    });

    var ci = g_form.getReference('cmdb_ci', setRelatedValue);

    function setRelatedValue(cmdbCI) {

        var ciCompany = cmdbCI.company || '';

        var ciCategory = cmdbCI.category || '';

        var ciSubcategory = cmdbCI.subcategory || '';

g_form.setValue('company', ciCompany);

        g_form.setReadOnly('company', Boolean(ciCompany));

        if (category.includes(ciCategory)) {

            g_form.setValue('category', ciCategory);

            setTimeout(function() {

                var subcategory = Array.from(g_form.getElement('subcategory')).map(function(item) {

                    return item.text;

                });

                if (subcategory.includes(ciSubcategory))

                    g_form.setValue('subcategory', ciSubcategory);

            }, 1000);

        }

    }

[SanaPR]

Hi Sowmya,
Were you able to achieve both the scenarios? Can you share your insights for both solutions please?
Thank you!