How to use a filter on the access control for a form?

[former_member557511]

Hi IdM Experts!

I tried to set up a filter in version 8 on a form's access control tab to limit which users can be selected. It is required that only users which are not disabled (MX_Disable <> 1) can be selected for the task. Unfortunately the filter does not seem to work, and even if I create the SQL statement myself it is not any better. If the filter (or SQL statement) is applied I cannot select any user, not even those which would be allowed.

Has anyone experienced the same thing?

Thanks for any help in advance!

zkormany

[Steffi_Warnecke · Accepted solution]

@Zoltan & @ Deva,

you guys use a lot of joins and views (e.g. vallink for a normal attribute) with too much info. And it looks like you never came across "not in".

select mcmskey as mskey from idmv_entry_simple with (nolock) where mcentrytype = 'MX_PERSON'
and mcmskey not in (select mskey from idmv_value_basic with (nolock) where attrname = 'MX_DISABLED')

.

The needed query does not seem too complicated to me. Or am I missing something?

.

Regards,

Steffi.

[former_member557511 · Accepted solution]

Hi Steffi,

that solved it. I don't know why but your query gets accepted by the filter and my previous one was not. Maybe it can't interpret joins?

Anyhow thank you for your help!

Kind regards,

Zoltan

[Steffi_Warnecke · Accepted solution]

You're welcome. 🙂

Try to create the simplest query possible. The access control is a bit sensitive, not everything works, that should work. It's the same with IDM 7.2 (which we use).

.

Regards,

Steffi.

PS: If you don't reply to my post, I won't get an info, that there is a reply. ^^ So I changed your answer to a comment on my answer.