Forum Discussion

skatiyar's avatar
skatiyar
Expert
5 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 users where deleted = true

Response:

{
"status" : "error",
"message" : "Invalid query syntax",
"data" : {
"type" : "error_data",
"code" : 604,
"developer_message" : "",
"more_info" : ""
},
"metadata" : { }
}

 

Thanks,
Sachin

 

  • srujanayeruvaka's avatar
    srujanayeruvaka
    5 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
    5 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.