Support querying of multitenancy / softdelete candidate classes

[andyjefferson]

When we do a JDOQL/JPQL query of a candidate that has a multitenancy or softdelete column we need to restrict the candidate by the associated surrogate column(s). So, for multitenancy, restrict just to the current tenant, and for softDelete, restrict to the delete flag being FALSE.