Merge pull request umbraco#415 from rustyswayne/7.1.5-templatequery

nul800sebastiaan · nul800sebastiaan · commit ba89aec34fd2 · 2014-06-10T17:48:59.000+02:00
Query Builder - Fix Date sort fields and format returned query
diff --git a/src/Umbraco.Web.UI/umbraco_client/Editors/EditView.js b/src/Umbraco.Web.UI/umbraco_client/Editors/EditView.js
@@ -79,7 +79,9 @@
                 template: "views/common/dialogs/template/queryBuilder.html",
                 callback: function (data) {
 
-                    var code = "\n@{\n" + "\tvar selection = " + data + ";\n}\n";
+                    var dataFormatted = data.replace(new RegExp('[' + "." + ']', 'g'), "\n\t\t\t\t\t.");
+
+                    var code = "\n@{\n" + "\tvar selection = " + dataFormatted + ";\n}\n";
                     code += "<ul>\n" +
                                 "\t@foreach(var item in selection){\n" +
                                     "\t\t<li>\n" +
diff --git a/src/Umbraco.Web/Editors/TemplateQuery/TemplateQueryController.cs b/src/Umbraco.Web/Editors/TemplateQuery/TemplateQueryController.cs
@@ -59,11 +59,11 @@ public TemplateQueryController(UmbracoContext umbracoContext)
 
         private static readonly IEnumerable<PropertyModel> _properties = new List<PropertyModel>()
             {
-                new PropertyModel() { Name = "Id", Alias = "id", Type = "int"  },
-                new PropertyModel() { Name = "Name", Alias = "name", Type = "string"  },
+                new PropertyModel() { Name = "Id", Alias = "Id", Type = "int"  },
+                new PropertyModel() { Name = "Name", Alias = "Name", Type = "string"  },
                 //new PropertyModel() { Name = "Url", Alias = "url", Type = "string"  },
-                new PropertyModel() { Name = "Creation Date", Alias = "createDate", Type = "datetime"  },
-                new PropertyModel() { Name = "Publishing Date", Alias = "publishDate", Type = "datetime"  }
+                new PropertyModel() { Name = "Created Date", Alias = "CreateDate", Type = "datetime"  },
+                new PropertyModel() { Name = "Last Updated Date", Alias = "UpdateDate", Type = "datetime"  }
 
             };
 
@@ -82,7 +82,6 @@ public QueryResultModel PostTemplateQuery(QueryModel model)
             timer.Start();
 
             var currentPage = umbraco.TypedContentAtRoot().FirstOrDefault();
-            
             timer.Stop();
 
 
@@ -201,7 +200,7 @@ public QueryResultModel PostTemplateQuery(QueryModel model)
 
                     var direction = model.Sort.Direction == "ascending" ? string.Empty : " desc";
 
-                    sb.AppendFormat(".OrderBy(\"{0}{1}\")", model.Sort.Property.Name, direction);
+                    sb.AppendFormat(".OrderBy(\"{0}{1}\")", model.Sort.Property.Alias, direction);
                 }
 
                 if (model.Take > 0)
