It doesn't look like my "raw" text is being posted. This is the code:

    UserService service = client.getService(UserService.class);
    AnyQuery query = new AnyQuery.Builder()
        .page(page)
        .size(pageSize)
        .orderBy(orderBy)
        .realm("/")
        .build();
                
    return service.search(query);

And this is the exception:

org.apache.syncope.common.lib.SyncopeClientException: DataIntegrityViolation
[ERROR: UNION types integer and text cannot be matched
  Position: 158 {prepstmnt 58276975 SELECT u.any_id,sva.stringvalue AS email
FROM (SELECT DISTINCT any_id FROM user_search WHERE id IS NOT NULL) u,
(SELECT * FROM user_search_attr UNION SELECT * FROM user_search_null_attr)
sva WHERE u.any_id=sva.any_id AND sva.schema_id='email' AND u.any_id IN
(SELECT any_id FROM user_search WHERE realm_id IN (SELECT id AS realm_id
FROM Realm WHERE id=?)) ORDER BY email ASC} [code=0, state=42804]]

-----
Paul Fullbright
--
Sent from: http://syncope-user.1051894.n5.nabble.com/

Reply via email to