HTML OData 查询生成器

Question

我开发了一个公开我的 Entity Framework 模型的 OData 网络服务，现在我需要开发一个这样的查询生成器，

http://odata.intel.com/QueryBuilder

有没有我可以使用的 HTML 或 JS 插件，我愿意使用 JQuery 或 Angularjs、bootstrap 或任何其他可用的插件，而不是重新创建 wheel。

Answer 1

1. https://odataquerybuilder.codeplex.com/

var url = 'https://services.odata.org/V4/Northwind/Northwind.svc';
var builder = new Xrm.oData.QueryBuilder(url)
			.setEntity('Orders')
			.setColumns('OrderID,CustomerID,ShipCountry')
			.setExpand('Order_Details')
			.setFilters(new Xrm.oData.FilterInfo({
				filterType: Xrm.oData.FilterTypes.And,
				filterExpressions: [
					"ShipCountry eq 'Sweden'",
					'OrderID lt 10800'
				],
				filters: [
					new Xrm.oData.FilterInfo({
						filterType: Xrm.oData.FilterTypes.Or,
						filterExpressions: [
							"CustomerID eq 'BERGS'",
							'OrderID gt 10700'
						],
						filters: [],
					}),
				]
			}))
			.setOrders([
				new Xrm.oData.OrderColumn({
					column: 'CustomerID',
					order: Xrm.oData.OrderTypes.Asc
				}),
				new Xrm.oData.OrderColumn({
					column: 'OrderID',
					order: Xrm.oData.OrderTypes.Desc
				})
			])
			.setSkip(10)
			.setTop(5);

var queryString = builder.getQueryFiltersPart();
console.log(queryString);

<script src="http://yourjavascript.com/58162111474/odata-querybuilder-0-1-min.js"></script>

结果:$select=OrderID,CustomerID,ShipCountry&$expand=Order_Details&$filter=(ShipCountry eq 'Sweden') and (OrderID lt 10800) and ((CustomerID eq 'BERGS') or (OrderID gt 10700))& $orderby=CustomerID,OrderID desc&$skip=10&$top=5

1. https://odatasamples.codeplex.com/releases/view/115752

这个基于服务元数据生成 html ui。您可以通过修改它来根据您的需要对其进行自定义。下载后运行前，修改“datajs-1.1.1.js”，第2593行:

• 来自

  xhr.open(request.method || "GET", url, true, request.user, request.password; 
  

• 到

  xhr.open(request.method || "GET", "https://cors-anywhere.herokuapp.com/"+ url, true, request.user, request.password);

  <

** 错误修复 (http://stackoverflow.com/questions/30318371/northwind-odata-service-not-working)

enter image description here