Simple List Report

HI,

I have created a simple list report which will show the status of a Attestation policy on a particular run version 7.1.5.

I have two user prompt fields where user can select the Attestation Policy and Attestation Run.

My requirement is how to restrict showing all the Attestation Run instead of that show run's which is mapped to a policy. Am not sure how to give a filter.

Thanks,

AAD

Top Replies

Markus Weiss-Ehlers over 3 years ago in reply to Aadvik17 +1 verified

If you look at the thread or the documentation, you will find that you need to use $PC(Ident_AttestationPolicy)$ in your query.

Condition (query)
(Only for data source Table) Limiting condition (WHERE…

0 Markus Weiss-Ehlers over 3 years ago

You can reference other parameters in the condition. Check here https://www.oneidentity.com/community/identity-manager/f/forum/22351/where-to-utilise-report-parameters and here https://support.oneidentity.com/de-de/technical-documents/identity-manager/8.1/configuration-guide/79#TOPIC-1134386
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Aadvik17 over 3 years ago in reply to Markus Weiss-Ehlers

Hi Markus,

I tried with the condition with @Ident_AttestationPolicy. and getting the below error.

Then I added Declare @Ident_AttestationPolicy varchar(max), still no luck.

Please advice.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

+1 Markus Weiss-Ehlers over 3 years ago in reply to Aadvik17

If you look at the thread or the documentation, you will find that you need to use $PC(Ident_AttestationPolicy)$ in your query.

Condition (query)

(Only for data source Table) Limiting condition (WHERE clause) for selecting the value through a table column. You can select a value from the result set. You can select several values from this set if the report parameter is multi-value, as well.

You can reference other report parameters in the condition using the following syntax:

$PC(<Parametername>)$

Example:

UID_Database = $PC(UID)$

where UID is the name of the referenced report parameter.

Endpoint Privilege Management

Simple List Report

Top Replies