Query table data to display in a Service Catalog field

[L_10]

Hi Community,

I have a question about Service Catalog variables.

<field A> A user selects an item name (in the image below, the variable name is "u_item_name_men")

<field B> A user selects whether or not s/he wants the item new or second hand ("u_item_newreuse_men")

             (this is not yet described in the code below, just wanting to add in the future)

<field C> Unit price of A item depending on A&B's selection ("u_item_unitprice_men")

A, B, and C are in the same variable set "u_vset_men".

The table I want the data to reference is "u_uniform_item_master".

The Catalog Client Script is like the image below:

As the result, nothing is displayed...

What part do i write wrong?? Could anyone give me some tips??

Thanks in advance.

Lit

[L_10]

Hi Omkar,

thank you for your reply.

It's... It's... already checked...

And still causing null error...

Cheers,

Lit

[Omkar Mone]

Hi 

Did you create a new one?

Create a new one a let me know.

[L_10]

Hi Omkar

No, but I remember it was checked when I first created.

Probably I better try anew anyway.

Cheers,

Lit

[Priya Shekar]

Hi,

is the client side code written in the onchange client script of "item name" field. Tat alert is being popped up by a onchange client script of "item name"

Can you please check that.

If my reply has helped you,Kindly click the Helpful button.
If my reply is the answer you were looking for, Kindly click the Accepted Solution button.

Thanks,
Priya

[L_10]

Hi Priya,

thanks for your reply.

Would the following images give supplementary information?

Thanks a lot for your help

Lit