Forum Discussion

skatiyar's avatar
skatiyar
Expert
6 years ago

Issue LiQL query

I am getting  error while trying to get list of deleted users. Query works in other cases where I put condition against login. Can someone help with the issue. Query: Select id, email, deleted from ...
  • srujanayeruvaka's avatar
    srujanayeruvaka
    6 years ago

    Hi skatiyar,

    'where deleted = true' is not a supported constraint in the WHERE clause of the query. You can filter by a datetime range between which user accounts were closed/deleted.

    Please refer to this documentation for the supported constraints. 

    Thanks,
    Srujana.

srujanayeruvaka's avatar
srujanayeruvaka
Champion
6 years ago

Hi skatiyar,

'where deleted = true' is not a supported constraint in the WHERE clause of the query. You can filter by a datetime range between which user accounts were closed/deleted.

Please refer to this documentation for the supported constraints. 

Thanks,
Srujana.