Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings

Have a "technician/admin mode" in Query Builder

Status: New
by Copper Super Contributor crs-wandreas on ‎10-22-2014 11:56 AM

It would be nice to have an option in query builder to switch from display names for tables and columns to the original names in the database.

 

This could be accomplished with a simple check box name "technical view" or similar.

The default should be the current behavious, i.e. to show the display names ("end user mode").

 

This would be very helpful for admins or consultants in heavily customized or - more important - localized versions of the client to "translate" the users intent expressed in domain model names into the "real" world of the underlying database and would make much easier to find tables and columns in SSMS if needed.

 

If considered, this option should be present in LAN as well as in web.

Comments
by Gold Super Contributor RJLedger
on ‎10-22-2014 01:36 PM

... AND have the ability to directly edit the Group SQL. If you do this then the "graphic" mode for THIS group/query is automatically "disabled".

 

To see a GREAT working example of hos this works - take a look at the query building in TaskCentre. This is this is the modern way to do things.. QB is basically the same as it was when SLX was first developed/released over 15 years ago - time to get "modern" ;-) 

 

 

Suggest this be built in such a way it could be shared with Web and LAN.

by
on ‎10-23-2014 04:07 AM

Absolutely agreed! QB is long overdue an overhaul to bring it in to the 21st century. As it is, it's very confusing for most users, and even some more technically minded folks alike.

 

I'd personally like to see a more graphical representation of the query which shows joins and join directions in a similar way to SSMS's query builder along with the added ability to easily edit column definitions without having to click in to new dialogs all the time.

 

Love your idea to allow direct editing of the SQL, RJ!

by Gold Super Contributor RJLedger
on ‎10-23-2014 07:49 AM

@Kev - here's a link to how #TaskCentre does it - a great way to deal w/query:

 

by Copper Contributor SamMitchell
on ‎10-27-2014 02:58 AM

Great idea and 100% agree that it's long overdue an overhaul. Trying to train users in utilising the query builder is something of a pain right now because of it's complexity. It's time to display field labels instead of SQL field names and allow users to search for the field they wish to include on their query.

 

Classic example of where this is a pain is the owner field, known as seccodeid in the database. Try explaining that to a group of company directors that want to create their own reports. I promise you'll get a sea of vacant expressions.

We want to hear your cool ideas for enhancing Saleslogix products and services. So add your own ideas or kudo (vote) on the ideas of others here! Watch the most valuable bubble to the top!

I have an idea! How do I get started?

One
Read our submission guidelines.

Two
Search for your idea. If you don't see it, submit a new one!

Three
Provide feedback on the ideas of others by voting with kudos and adding comments.
For more information about using ideas, read this thread.

Four
Track your ideas and those you like. Once you've posted or kudoed and idea, subscribe to be notified via email of the latest updates to the idea. From within the idea, click "Idea Options" which appears above the idea title and choose, "Subscribe to this idea".

Be sure to check back from time to time to see new ideas and status updates!

Here is a quick list of the recent ideas for speedy browsing!
Labels