how to dot walk in script include

[Sweety11]

Hi all,

I'm little bit confused, like how to link the fields from 2 different tables.

Ex: sys_user & cmn_location. In user table i can able to see city & country fields but the field names are populating as location for both. In this case I want to get those particular 2 fields from location table. How I do that in script include?

Sys_user > city want to get from cmn_location > city

Need some detailed understanding. Your inputs helps me to do this thing.

Regards,

Sweety.

[Sweety11]

I have marked 2 questions as helpful Aman. 

1.How to populate the incident list(that is answered by you) & one more question.

Community is helping me a lot and I'm learning new things from community.

[Aman Kumar S]

Please mark correct answers too, so somebody who is lookin for similar answers as you, will find it easy.

As far as your question goes, I think everybody has tried to give several solutions, and since you are learning, my suggestion would be try to debug using logs and alerts for each and every line, and see where your code is failing

For eg, you are writing glideajax on a onChange client script.

• Check with alert if your field that you are passing to Script include has some value.
• After the same value after getParameter at script include, add gs.info to check
• Do a gliderecord, the value lets say what others has been suggesting, check what value is coming after your glidrecord, what is the type of the value that you are getting, if it requires conversion to some other data type.

Lets take baby steps in learning, you will definitely grow a lot

Best Wishes!