Editor - .NET Select Query.Where use NOT IN (or IN) for Options
Editor - .NET Select Query.Where use NOT IN (or IN) for Options
michaeln
Posts: 8Questions: 4Answers: 0
I am following the sample code here [ https://editor.datatables.net/manual/net/joins ] to populate the Select data
Sample code:
new Field("users.site")
.Options("sites", "id", "name", q => q.Where("name", "L%", "LIKE") );
I am trying to select sites that is NOT IN("London", "New York"). I tried
new Field("users.site")
.Options("sites", "id", "name", q => q.Where("name", "("London", "New York")", "NOT IN") );
and
or try something with IN
new Field("users.site")
.Options("sites", "id", "name", q => q.Where("name", "("Seattle", "Chicago" )", "IN") );
and
I try escape using double quote or backslash.
None of them work.
Does IN or NOT IN work with Query.Where ?
Thanks
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
Your second one is very close, but you need to also pass in the fourth parameter to tell DataTables to not bind the values:
See the WHERE condition documentation for more details.
Allan