Adding username from database with external authentication JasperServer 7.1

[sustain_1]

Hello !

I want to get username (like full name) from my database via external authentication. But number and order of columns in query is fixed - 

name="usersByUsernameQuery" - so i take only username(User ID) and password.

But i need to add full name in User name pole of JasperServer instead User ID.

How can I do it ?

here is my bean:

<bean id="externalUserDetailsService" class="com.jaspersoft.jasperserver.api.security.externalAuth.db.ExternalJDBCUserDetailsService">

<property name="dataSource" ref="externalDataSource"/>

<property name="usersByUsernameQuery" value="SELECT u.JR_USER, u.JR_PWD, 1 FROM JASPER_USERS u WHERE u.JR_USER = ?"/>

<property name="authoritiesByUsernameQuery" value="SELECT u.JR_USER, u.JR_ROLE FROM JASPER_USERS u WHERE u.JR_USER = ?"/>

</bean>

 

thanks for help.

[sthomas_3]

What is the purpose of getting full name while authenticating?