REL-Function "All Users"

[Former Member]

Hello,

I want to create a jobdefinition with a parameter which is a list of all users defined in Security/Users and owner of a jobdefinition.

The Statement

select distinct s.Name from Subject s, Job j where s.Name like '%@xxx.com' and j.OwnerSubject=s.UniqueId

gives me the right list.

How can I insert this in the parameter?

The REL-Expression

=Query.getString('select distinct s.Name from Subject s, Job j where s.Name like ? and j.OwnerSubject=s.UniqueId',['%@xxx.com'])

is empty and gives no error.

Best regards

Dana

[nanda_kumar21]

can you try escaping "%" character?

=Query.getString('select distinct s.Name from Subject s, Job j where s.Name like ? and j.OwnerSubject=s.UniqueId',['%%@xxx.com']) 

thanks

Nanda

[Former Member]

Hello Nanda,

unfortunately it has no impact. The field is still empty.

Best regards

Dana Ullrich