Does anyone know of a reference for the database values of the SandboxProcess.Status field in the Tooling API?
I want to query SandboxProcess, but filter out the Deleted and Deleting records in the query. I couldn't get my filter on Status to return any records, though. I read this known issue:
The issue says that:
Tooling API query on SandboxProcess returns no rows if we use the status field as a filter.
If we use, Status='Deleted' it does not return any records.
The workaround is:
If we used DB values, not API or translated values, expected rows are returned.
select id, status, sandboxname from sandboxprocess where Status='D'
That's fine, but I don't know what the DB values corresponding to the API values are. And I haven't been able to find it anywhere in poking at my org or by Googling. Obviously, I know that D=Deleted, but it would be useful to have a complete list of them.