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
6 REPLIES 6

Re: Hide Queries based on Groups and Roles

Creator
Creator

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. :) 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
Highlighted

Re: Hide Queries based on Groups and Roles

Creator
Creator

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

Re: Hide Queries based on Groups and Roles

Solution Partner Creator Solution Partner Creator
Solution Partner Creator

Hello: @ZsCsaba 

 

I met the same needs as you, but I am also so configured, did not take effect!

Here's my configuration.

 

help me,Please!  think you.

微信图片_20190312133430.png

Re: Hide Queries based on Groups and Roles

Solution Partner Experimenter Solution Partner Experimenter
Solution Partner Experimenter
Hi tranyao,

Remove the "<“ and “>" characters.
If it still doesn't work, just let me know.

Br,
Csaba