How to get Cost center in the catalog form

Samiksha2 — Mon, 17 Jul 2023 14:27:23 GMT

Hi,

I have a requirement to show the cost center in the catalog form from the custom table.

In the custom table we have only user id.

On change of user id in the form cost center should populate.

Script include:

Client script:

var user_id = g_form.getValue('requested'); var ga = new GlideAjax('requestor_details'); ga.addParam('sysparm_name', 'getUserDetailsInternal'); ga.addParam('sysparm_user', user_id); ga.getXML(EmployeeDetailsLookup); } function EmployeeDetailsLookup(response) { var answer = response.responseXML.documentElement.getAttribute("answer"); var result = JSON.parse(answer); alert(result); g_form.setValue('cost', result); }

Please help in this.

Thank you!

Samiksha

Re: How to get Cost center in the catalog form

brianlan25 — Mon, 17 Jul 2023 14:38:12 GMT

The problem appears to be in your script include. You are doing a search against your custom table but your query is only if u_user_id is not empty. I would think you just need to use the andQuery('u_user_id', userName).

Re: How to get Cost center in the catalog form

Samiksha2 — Mon, 17 Jul 2023 14:45:02 GMT

Hi Brian,

Yes, you are right. It is working fine.

Thank you.

question How to get Cost center in the catalog form in ITSM forum

How to get Cost center in the catalog form

Re: How to get Cost center in the catalog form

Re: How to get Cost center in the catalog form