• State Verified Answer
  • Replies 2 replies
  • Subscribers 95 subscribers
  • Views 1704 views
  • Users 0 members are here
Options
Related

Report Designer - Parameter 'user prompt' condition query dependent on signed in user

Martin.Ehlert
over 5 years ago

Hi community,

I want to create a report parameter which prompts the user to select attestation runs.

In this select-contol only AttestationRuns should be displayed, where the current user is owner (AttestationPolicy.UID_PersonOwner)

To filter the options for this parameter the property (Condition (query)) is used.

My problem is, I don´t know how to get the current user reference in this query.

Until now I tried to reference the user with a second parameter UserID as $PC(UserID)$ but this is not working (I don´t know why). The UserID-Parameter is initialized with 

If Provider.Contains("UID_Person") Then
Value = $UID_Person$
Else
Value = me.Connection.User.Uid
End If

but this seems only to evaluate on report run and not at the time of subscribing the report, so that limiting the options would be possible.

Parents
  • 0 over 5 years ago

    What version are you using?

    Where did you test this, in the Manager? If so, what type of authentication did you use? You need to use an authenticator that is able to identify the person that has been logged in.

    Then you can reference the logged-in person by using %useruid% in your condition.

    UID_PersonOwner = '%useruid%'

Reply
  • 0 over 5 years ago

    What version are you using?

    Where did you test this, in the Manager? If so, what type of authentication did you use? You need to use an authenticator that is able to identify the person that has been logged in.

    Then you can reference the logged-in person by using %useruid% in your condition.

    UID_PersonOwner = '%useruid%'

Children