different output

Confluence User - 23 Mar, 2016

 

attached aboce is the submitted request and the output below, my question is how can i fix the output of the "Name of Staff" because its value is different.

 

my selectbox from the "Name of Staff" is a JDBC procedure, i am getting a value from the database. how can i fix this

 

thank you!

user;forms;datalists

8


23 Mar, 2016
confluenceUser
confluenceUser

hi jedi, 

your #form hash variable is missing the '#' in front of it. it should be #form.useraccount.field13#

23 Mar, 2016
confluenceUser
confluenceUser

hi Kuhan, yeah i already fixed that, my concern is the "Name of Staff" output. the output is different. how can i fix that?

23 Mar, 2016
confluenceUser
confluenceUser

jedi, you may want to re-check your procedure to ensure you're passing the right parameters. based on your output, i think you're passing in the form's id.

23 Mar, 2016
confluenceUser
confluenceUser

what should i do to fix this?

23 Mar, 2016
confluenceUser
confluenceUser

i suggest you use the hash variable #performer.runProcess.firstName# to display a more accurate output. else, try to study your procedure properly and check where the data is grabbed from in your database to produce the output and amend accordingly

23 Mar, 2016
confluenceUser
confluenceUser

i cant use the performer because the "name of staff" field is from a datalist. it is not the performer of the form.

23 Mar, 2016
confluenceUser
confluenceUser

Try to use nested hash variable Hash Variable#NestedHashVariable

#form.staffTable.staffName[{form.existingHashVariable}]#

23 Mar, 2016
confluenceUser
confluenceUser

Hi Jedi, 

The form hash variable is only able to retrieve the value stored to the form data table. In your case, if the value of "Name of Staff" field is an username, then it will show you username in stead of the full name.

There are few way you can made it to appear as a full name in stead of username.

Method 1: using User Hash Variable with nested hash variable.

#user.{form.useraccount.field13}.firstName# #user{form.useraccount.field13}.lastName#

Method 2: if the name is not from user table and you need to code to retrieve the value, you may need to check the free Bean Shell Hash Variable in the marketplace which allow you to using bean shell script to return value.

Best regards.

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print