Hello,
I'm trying to create a report for users to run to get all groups they are the primary or secondary owner of.
I have the first part which is the primary owners but having difficulty with the secondary owners. Since they are not linked to a table and just a string it's difficult.
In my report I have a parameter for the UID_Person and also the CentralAccount for the person running the report.
In the edsvaSecondaryOwners for secondary owners it just has distinguishedName for anyone who is an additional owner.
I would be able to get the result if I did (edsvaSecondaryOwners like '%@centralaccount%'). The problem is how do i do a like in the data sources on the report and include the %?
Here is my condition which would work perfect if I could get the % in the @centralaccount parameter.
Is it even possible to do a like with a parameter or add the % to the parameter with a script in the parameter options?
Thank you for any guidance
_______________
( EXISTS
(
SELECT 1 FROM
(SELECT xobjectkey FROM ADSAccount WHERE EXISTS
(
SELECT 1 FROM
(SELECT UID_Person FROM Person WHERE UID_Person = @ReportScheduledBy) as X
WHERE X.UID_Person = ADSAccount.UID_Person
) ) as X
WHERE X.xobjectkey = ADSGroup.OBJECTKEYMANAGER
) )
or
(edsvaSecondaryOwners like %@centralaccount%)
