Hello,
I am having some troubles with client scripts and client scripts SQL. I am trying to create a client script that will get user_def9. When I run a test, I am able to get an alert for
- alert("TEST"); → Working
- alert(personID); → Working
- alert(selectedValue + "this is a test") → Alert only shows “this is a test”
- alert(personType) → Not working. Shows [object Object]
Below is what is in my client script
var screenName=getCurrentScreenName();
var personID=getUserInfo('personId');
var personType = getDBValues("select user_def9 from person where person_id ='JSMITH'");
var selectedValue = getDBValues("SP_USER_ROLE",personID);
alert("TEST");
alert(personID);
alert(selectedValue + "this is a test")
alert(personType)
This is what is in my Client Scripts SQL
select USER_DEF9 from PERSON where PERSON_ID = '{0}'
- For the web client only, are you able to use SQL queries within the brackets? or do they require an entry in Client Script SQL that needs to be called?
- Why isn't selectedValue showing what I want?