Distinct in auto query

ServiceStack Auto Query
1

Hi
I use auto query in a view. I need to add distinct in the sql. How do i add “distinct”. I haven’t find it in the document.

Thanks

2

@benhaben there’s not support for distinct in AutoQuery, you would be best creating your own service for this query or using a custom AutoQuery implementation.

If you need more control over queries than what AutoQuery gives you, a lot of the time it might be better to just use OrmLite directly with a normal ServiceStack service.