ServiceStack OrmLite AutoQuery Filter

Question

Should the following work: ?OpensContains=Something by querying the Name column on the db? It doesn't and I'm not sure why not?

 [QueryDbField(Field = "Name")]
 public string OpensContains { get; set; }

?NameContains=Something does work, the column exists, I was assuming that I could add a different Property to the request object that would query the same field using contains.

score 2 · Accepted Answer · answered Mar 02 '17 at 15:29

2

If you're customizing the field you need to provide the template otherwise it defaults to an = operand, i.e:

[QueryDbField(Field = "Name", Template = "{Field} LIKE {Value}", ValueFormat = "%{0}%")]

answered Mar 02 '17 at 15:29

mythz

141,670
29
246
390

Confirmed that worked though I don't recall reading that in the documentation. Thanks. – lucuma Mar 02 '17 at 15:36

ServiceStack OrmLite AutoQuery Filter

1 Answers1