unclecheese

You quoted it in the join clause but not the from clause

unclecheese

Been a while since I’ve looked at this code, but from memory, the filtering inputs are a service, so it should be easy to plug into a nested query. I’ll look at it today and post something here.

unclecheese

Yeah, nested queries are a bit second class citizens at the moment. You might have to do this as a separate top-level query with filters for the primary key

😞 (1)
unclecheese

Ed paid for my Tesla

😱 (2) (1) 😂 (1)
unclecheese

Thanks. I was going to do this today but couldn’t remember which page it was 😜

unclecheese

For other custom fields, I don’t think we can do that because there is no “non null” in SilverStripe really

unclecheese

Seems like a simple patch for the scaffolder. All the core DB fields, ID, Created, LastEdited and ClassName should be wrapped in nonnull