Generate list of users and groups from database in AppXtender
The following query will generate a list of all users and the groups they are part of in ApplicationXtender:
select a.usrnam, c.aliasname from ae_login a, ae_amap b, ae_als c
where
a.usrid=b.usrid and
c.aliasid=b.aliasid
order by c.aliasname, a.usrnam
Related Articles
Modifying User Settings in AppXtender Web
Changing User Settings To change the user's User Settings in ApplicationXtender Administrator: 1. Go to Application Management 2. Expand the data source by clicking on it 3. Choose Web Access User Settings 3. Click the X next to Default user ...
How to add item to user defined list field in ApplicationXtender
Here are the steps to add a new value to a user-defined list field in ApplicationXtender: 1. Open Application Administrator and log in as a user with Modify Application privileges 2. Go to Application Management and click on the Data Source 3. Click ...
Keyboard Shortcuts available in AppXtender Web Access
Here is a list of the available Keyboard Shortcuts in AppXtender Web Access: Open shortcut help ? Print ctrl + alt + p Previous Document alt + p Next Document alt + n Next Page alt + pagedown Previous Page alt + pageup Next Page Version alt + ⇧ + ...
Fix Database Collision condition in AppXtender in version 8x or above
ApplicationXtender Administrator web application does not include a feature to fix a database collision that was present in the Application Generator in earlier releases. The AE_SEQ table has to be modified directly to fix a database collision. ...
AppXtender Audit Trail Events
Below is the full list of Audit Trail Event ID codes for table ae_audit Audit Event Id IDL Event Id Description 0 axAuditID_LOGIN Login in 1 axAuditID_LOGOUT Logout ApplicationXtender 2 axAuditID_APPCREATE Create an AX Application 3 ...