add FullTextContains quick search type (simple version of pull request …

…serenity-is#2200 that only support quick search with contains for performance reasons, thanks @marcobisio)
wojciechgl · Oct 12, 2017 · 8d73e23 · 8d73e23
1 parent acab19d
commit 8d73e23
Show file tree

Hide file tree

Showing 2 changed files with 6 additions and 1 deletion.
diff --git a/Serenity.Data/Mapping/SearchType.cs b/Serenity.Data/Mapping/SearchType.cs
@@ -6,6 +6,7 @@ public enum SearchType
         Auto = 0,
         Equals = 1,
         Contains = 2,
-        StartsWith = 3
+        StartsWith = 3,
+        FullTextContains = 4
     }
 }
diff --git a/Serenity.Services/RequestHandlers/List/ListRequestHandler.cs b/Serenity.Services/RequestHandlers/List/ListRequestHandler.cs
@@ -210,6 +210,10 @@ protected virtual void AddFieldContainsCriteria(Field field, string containsText
                     criteria |= new Criteria(field).Contains(containsText);
                     break;
 
+                case SearchType.FullTextContains:
+                    criteria |= new Criteria("CONTAINS(" + field.Expression + ", " + containsText.ToSql() + ")");
+                    break;
+
                 case SearchType.StartsWith:
                     criteria |= new Criteria(field).StartsWith(containsText);
                     break;