Calling the appian function from MySQL

Question

Hi All, 
 Is there a way to call the the appian functions/rules inside MYSQL query ? 
 For Ex: The value stored in DB is userid , would like to create a view which converts the userid to Display Name in Appian. 
 Is it possible? 
 Thanks 
 Rajesh

rommels · Answer

Hi Rajesh, 
 
Instead of using Appian function in MYSQL you can use rule!APN_displayUser() to get user fullname. 
1 Use query entity or query rule to get that column. 
2 Use above mentioned rule to display user name 
Thanks

aratim · Answer

Hi Rajesh, 
 
Instead of using Appian function in MYSQL you can use rule!APN_displayUser() to get user fullname. There is no way to directly call Appian function from MySQL, however you can do so by writing java code which will call these queries. 
Appian allows querying from DB using query rules or query entities. 
Thanks.

Jacob Grafenstein · Answer

Hi Rajesh, 
When you try to access the the userid from the view, call rule!APN_displayUser() and this will display the full name of the user. There is no way to call appian functions inside a MYSQL query. You should be doing all of your querying using query rules or query entities. 
Regards, 
Jake