Can a field used to filter not be in the select clause?

ServiceStack Auto Query
1

In other words … Is the code snippet below valid ?

public class QueryableCompany : QueryBase<Company>
{
    public int? Id { get; set; }
}
public class Company
{
    public string company { get; set; }
    public int companyNo { get; set; }
    public bool active { get; set; }
}

I want to filter on the Id field, but do not want to have it in the select statement.
I know how I can avoid to return it back to the client, however I would like to avoid to have it in the select clause … so that it does not travel from the DB to the service).

thank you
enrico

2

Please note AutoQuery should be inheriting QueryDb from v4.0.56 onwards.

You can use the ?fields=... QueryString to tell ServiceStack which fields it should select and return.