cancel
Showing results for 
Search instead for 
Did you mean: 

Hide Queries based on Groups and Roles

Valued Contributor
Valued Contributor

Hi guys,

 

In our environment we have a lot of queries created in Query Builder.

Some of them are not intented to be used by a 'normal user'. These are used in Workflows, Server Extensions, etc. Another part of them are relevant just for a given Group and/or Role.

 

Is there someone who knows a way, how these queries could be to hidden/shown based on the users's Group / Role?

 

Br,

ZsCsaba

Software Engineer
4 REPLIES

Re: Hide Queries based on Groups and Roles

Experimenter
Experimenter

For technical queries (e.g. for worflows), you can name it with suffix "__" (double underscore), these queries will be hidden for all except dba role.

Re: Hide Queries based on Groups and Roles

Valued Contributor
Valued Contributor
I knew this "double underscore" thing, but with a prefix. Smiley Happy And that part is working fine.
My biggest issue is with the queries, that should be visible only for a certain Group / Role.
Software Engineer

Re: Hide Queries based on Groups and Roles

Experimenter
Experimenter

My mistake, yes I wanted to say prefix.

The only possibility is to use ACL to filter, but take care about the collateral damage (TC is very sensible when you want to add acl rules on standard objects).

Re: Hide Queries based on Groups and Roles

Valued Contributor
Valued Contributor

You're right, I have managed to do it.

Here are the steps that needs to be done:
Has Class ( POM_application_object) -> Working (this one is OOTB)
   - ...
   - ...
   - Has Class( ImanQuery ) -> < General ACL, to add a new layer of indirection >
      - Has Attribute( ImanQuery:query_name=<your_query_name> ) -> New ACL

In this new ACL you can specify the groups and/or roles that should or shouldn't  see the <your_query_name> query.

Br,
ZsCsaba

Software Engineer