JavaScript 布尔搜索查询生成器接口库?

发布于 2024-12-28 22:02:15 字数 283 浏览 4 评论 0原文

是否有任何(好的/可用的/不难看的)JavaScript/接口库用于管理自定义布尔样式查询的创建,类似于 Google Analytics Advanced Segment 接口?

基本上,这是一个用于查询构建的动态接口,可用于连接到后端的自定义查询构建器(在我的例子中是 MySQL,但它不必特定于数据库)。

我四处搜寻,没有发现任何有帮助或可用的东西。

Google Analytics 查询生成器

Are there any (good/usable/not ugly) JavaScript/interface libraries for managing the creation of custom boolean style queries, similar to the Google Analytics Advanced Segment interface?

Basically, a dynamic interface for query building that can be used to connect to a custom query builder on the backend (in my case, MySQL, but it needn't be database specific).

I've searched around, and haven't found anything helpful or usable.

Google Analytics Query Builder

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(5

云之铃。 2025-01-04 22:02:15

http://redquerybuilder.appspot.com/ 不太漂亮,但旨在供非技术人员使用。

我应该明确表示我是这个项目的作者之一。

http://redquerybuilder.appspot.com/ is not pretty but aiming to be usable by non-techy people.

I should make it clear that I'm one of the authors of this project.

思慕 2025-01-04 22:02:15

我在 Elastic Search 论坛上发现了这个问题,与您的问题非常相似。建议使用弹性搜索js客户端库: http:// /elasticsearch-users.115913.n3.nabble.com/javascript-query-builder-td1860558.html

ExtJS 的网格控件有一个查询生成器扩展: http://www .developerextensions.com/index.php/extjs-grid-query-builder(查找表格上方显示“查询生成器”的链接)。

我还发现了这个“Active Query Builder”: http://aspquerybuilder.net/default.aspx
功能列表为: http://www.activequerybuilder.com/featurematrix.html?show =asp 。它是一个使用 jQuery 的付费 ASP.NET 组件。它非常强大,可能超出您的要求,也可能与您的框架兼容或不兼容(您没有指定),但它看起来确实很酷。

更多基于 ASP.NET 的查询生成器链接自:基于 Web 的可视化查询生成器

I found this question on the Elastic Search forum, that is very similar to yours. An elastic search js client library is suggested : http://elasticsearch-users.115913.n3.nabble.com/javascript-query-builder-td1860558.html .

ExtJS has a Query Builder extension to their Grid control: http://www.developerextensions.com/index.php/extjs-grid-query-builder (look for the link above the table that says Query Builder).

I also found this, "Active Query Builder": http://aspquerybuilder.net/default.aspx
The feature list is : http://www.activequerybuilder.com/featurematrix.html?show=asp . It's an paid ASP.NET component that uses jQuery. It's pretty robust and may be more than you are looking for and also may or may not be compatible with your framework (you didn't specify), but it does look pretty cool.

Some more ASP.NET-based query builders are linked from : Web based visual query builder.

风吹短裙飘 2025-01-04 22:02:15

这是我最近遇到的网络服务:Advangle

看起来他们使用了一种 JavaScript 库,其 UI 与您所要求的类似。

Here is web-service I came across recently: Advangle.

Looks like they use a kind of JavaScript library with UI similar to what you requested.

国粹 2025-01-04 22:02:15

jQuery QueryBuilder 是一个相当新的工具,可以在这里找到:http://querybuilder.js.org/

它支持以下逻辑和过滤运算符:

  • and
  • equal / not equal
  • in / not_in
  • 开头为 / not 开头为
  • contains / not contains
  • 结尾为 / not 结尾为
  • isempty / is notempty
  • is null / is not null
  • less / less or等于/大于/大于或等于
  • /不在之间

基本输出是 JSON,但也可以使用 SQL 或 MongoDB 语法导入/导出插件。

一些演示可以在这里找到:http://querybuilder.js.org/demo.html

A fairly new one is the jQuery QueryBuilder which can be found here: http://querybuilder.js.org/

It supports the following logical and filter operators:

  • and
  • or
  • equal / not equal
  • in / not_in
  • begins with / not begins with
  • contains / not contains
  • ends with / not ends with
  • is empty / is not empty
  • is null / is not null
  • less / less or equal /greater / greater or equal
  • between / not between

The basic output is JSON but plugins for SQL or MongoDB syntax import/export are available too.

Some demos can be found here: http://querybuilder.js.org/demo.html

温柔戏命师 2025-01-04 22:02:15

还有一个基于 Sencha ExtJS 框架的类似 MS Access 的 javascript 可视化 SQL 查询生成器。 http://www.sencha.com/forum/showthread .php?208444-Ext.ux.window.VisualSQLQueryBuilder

There is also an MS Access like javascript visual sql query builder based on the Sencha ExtJS Framework. http://www.sencha.com/forum/showthread.php?208444-Ext.ux.window.VisualSQLQueryBuilder

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文