Print Page | Close Window

Query builder component?

Printed From: TMS Software
Category: General
Forum Name: Feature Requests
Forum Discription:
URL: http://www.tmssoftware.com/site/forum/forum_posts.asp?TID=5834
Printed Date: 13 Nov 2019 at 4:01pm


Topic: Query builder component?
Posted By: Kovacevic Zeljko
Subject: Query builder component?
Date Posted: 29 Oct 2015 at 8:12pm
Do you already have it?



Replies:
Posted By: Bruno Fierens
Date Posted: 29 Oct 2015 at 8:16pm
See:
http://www.tmssoftware.com/site/qs.asp
http://www.tmssoftware.com/site/tmsiwqs.asp


Posted By: Kovacevic Zeljko
Date Posted: 29 Oct 2015 at 8:27pm
I'm not sure if this is what I need.. More pictures would be helpful though.

For example, my database contains over 170 tables and the biggest problem is how to join them when writing sql query. My users must be able to have the option to choose tables, graphically join 10 or more tables (thus, automatically generating sql in the background), choosing result fields (group, sum etc..).


Posted By: Bruno Fierens
Date Posted: 31 Oct 2015 at 9:46am
Our Query builder products use a tree to define tables and joins and tries to represent tables/joins/filters/groups in a natural language form. Not sure what exactly you are visually after, but the focus of our Query builder products is the natural language representation / entry for complex queries.


Posted By: Kovacevic Zeljko
Date Posted: 31 Oct 2015 at 10:59am
I don't have time to investigate each and every component. I asked nicely for additional pictures that show component's key features but I see it's not gonna happen :)



In short, this is what I need. A classical "view creator" like in sql server management studio.


Posted By: Kovacevic Zeljko
Date Posted: 31 Oct 2015 at 11:00am
http://i.ytimg.com/vi/NkbCz8g7jsg/maxresdefault.jpg


Posted By: Bruno Fierens
Date Posted: 31 Oct 2015 at 1:04pm
As I explained, our Query builder provides a natural language interface, not a visual / graph based interface.


Posted By: Kovacevic Zeljko
Date Posted: 31 Oct 2015 at 1:09pm
Thanks. I'll look elsewhere.



Print Page | Close Window