Query Builder Admin Tool collections
We would like to ask a BOE XI 3.1 SP3 CMS Repository (ORACLE 11.2) for Users that only have one alias and that alias is Enterprise.
Firts we would like to do that using the web admin tool Query Builder, but we have problems with SI_ALIASES property because it is a collection of objects with their own properties and we don't know how to filter for that properties in a SQL Query.
How can we peform these kind of queries?. Those queries that filter for the SI_ALIASES object properties. For example... si_name (alias name)
We supposed that it could be solve with a little java program using java sdk also.
There is not much information about these issues.
Does anyone have the same problem?. How do you solve it?
Thanks in advance,