java table schema names

[travemole]

Dear All,

As some parts of the tool require queries that are written using the internal properties and class names that are case sensitive I would like to have it somewhere in the documentation the full list of classes and properties names.

Example: select a from Users a where a.id in ('${users.id}') --> if users table is not written like "Users" then the query fails as it says the class does not exist.

Can someone share that information that is only available inside the jar files?

Kind regards,

Albert.

[rushikeshvartak]

Can you share where are you trying to use above configurations 

[travemole]

Hi @rushikeshvartak ,

For example in the sav roles queries:

Whom to request for example.

There's other places where it uses java class names but this one is the most painful one as you need to login as different user every time you want to do changes to a role.

Kind regards,

Albert.

[rushikeshvartak]

Below are Java Class names

Users

Usergroups

SavRoles

Roles

Entitlement_values

Endpoints

Accounts

Securitysystems

Dataset_Values

[travemole]

Hi @rushikeshvartak @Rajesh-R ,

Can I have ALL of the class names? Like for Organizations and any other object? This for me is something that should be in the official documentation somewhere because it takes a lot of time to make it work.

Other ones that I've managed to get in case someone else is searching for this.
Usergroup_users
UserGroup_Owners

Kind Regards,
Albert.

[Rajesh-R]

@travemole 

The following is one sample

select a from Users a where a.id=${users.id} and a.employeeclass in ('Employee')