Handling more conditions operators #1054

rappen · rappen · commit d4358084336b · 2024-08-15T10:15:15.000+02:00
diff --git a/FetchXmlBuilder/Converters/SQLQueryGenerator.cs b/FetchXmlBuilder/Converters/SQLQueryGenerator.cs
@@ -215,6 +215,7 @@ private static string GetCondition(string entityname, string entityalias, FetchC
                 {
                     throw new Exception($"No metadata for attribute: {entityname}.{condition.attribute}");
                 }
+                var value = condition.value;
                 switch (condition.@operator)
                 {
                     case @operator.eq:
@@ -260,9 +261,36 @@ private static string GetCondition(string entityname, string entityalias, FetchC
                     case @operator.notlike:
                         result.Append(" NOT LIKE ");
                         break;
-                    //case @operator.beginswith:
-                    //    result.Append(" LIKE \"{0}%\"");
-                    //    break;
+
+                    case @operator.beginswith:
+                        result.Append(" LIKE ");
+                        value = $"{value}%";
+                        break;
+
+                    case @operator.notbeginwith:
+                        result.Append(" NOT LIKE ");
+                        value = $"{value}%";
+                        break;
+
+                    case @operator.endswith:
+                        result.Append(" LIKE ");
+                        value = $"%{value}";
+                        break;
+
+                    case @operator.notendwith:
+                        result.Append(" NOT LIKE ");
+                        value = $"%{value}";
+                        break;
+
+                    case @operator.containvalues:
+                        result.Append(" LIKE ");
+                        value = $"%{value}%";
+                        break;
+
+                    case @operator.notcontainvalues:
+                        result.Append(" NOT LIKE ");
+                        value = $"%{value}%";
+                        break;
                     //case @operator.@in:
                     //    result.Append(" IN ");
                     //    break;
@@ -286,11 +314,11 @@ private static string GetCondition(string entityname, string entityalias, FetchC
                         case AttributeTypeCode.State:
                         case AttributeTypeCode.Status:
                         case AttributeTypeCode.Picklist:
-                            result.Append(condition.value);
+                            result.Append(value);
                             break;
 
                         default:
-                            result.Append($"'{condition.value}'");
+                            result.Append($"'{value}'");
                             break;
                     }
                 }
