Group Members function in data source filter with "person or group" field as parameter

0

Hi,
I added the filter for a field type "Personal of group".
I added the field with values for the funciton "gropup members" from the process.
I press the button show and the values were show in the script.
Can you tested the sql from the "Expression preview" in the SSMS?

Thanks,
Raluca

Hi,
I think the problem is the use of "login and name" in the filter.

I checked and indeed, there is a small problem.
As Raluca pointed out - you can see what the SQL query for filtering looks like.
WEBCON changes the text formatting by adding '.
The easiest way would probably be to change it to Advanced Filtering and add the appropriate entry

Hi,

thanks for your help both of you!

Indeed I can confirm this quote problem:
COS_ID IN (SELECT COSET_COSID FROM [dbo].[CacheOrganizationStructureExtendedTokens] WHERE [COSET_TokenPart] IN ('''testgroup'''))

Using this as advanced filter with the field [AD-Group (Login)] works as it expected:
COS_ID IN (SELECT COSET_COSID FROM [dbo].[CacheOrganizationStructureExtendedTokens] WHERE [COSET_TokenPart] IN ('{I:123}'))

Thanks a lot for this workaround! Much better than setting the values in a technical field and so on ... :)

@Webcon: Would it be possible to "fix" this quote problem? It would be great if one could use the visual filter with group members out of the box.

Kind Regards
Sébastien