#15533: Would like search feature in Query Builder Design Pane

samjacinto reported 2018-03-02T21:08:13Z · last modified 2018-09-19T11:17:54Z

Would like search feature in Query Builder Design Pane

Dev	harishkhattri
QA	juhisindhani

Priority	Minor
Complexity	Unknown

Component	Query Builder
Version	19.5

Customer: Primus Präzisionstechnik GmbH

User: Thorsten Voelz

Case: 00621299

Customer would like a search function added to Query Builder so that you can click on an object in the Design Pane and by typing a letter, or letter, go to a column name or group. Say if you have 100 columns instead of scrolling down the list you could type "P" and hop to the names starting with "P".

Ok no problem. I try to explain by mail:

I am working in a query design:

[cid:image001.png@01D3B0D8.AC0EEC40]

I try to find a table at the feature tree:
I press some letters in the tree and get a suggest table (1st Find) : Feature -1-

[cid:image002.png@01D3B0D8.AC0EEC40]

It works.
Now I am looking for a field in a Table in the design area:

[cid:image003.png@01D3B0D9.538BD0A0]

I activate the correct table via mouse:

[cid:image004.png@01D3B0D9.538BD0A0]

I type some letters – no reaction. I expect the same action as shown in Feature -1-

I hope now it is clear ☺

10 attachments

image003.png

2018-03-02T21:08:13Z

16 KB
image001.png

2018-03-02T21:08:13Z

90 KB
image005.png

2018-03-02T21:08:13Z

38 KB
image002.png

2018-03-02T21:08:13Z

9 KB
image004.png

2018-03-02T21:08:13Z

13 KB
Search.png

2018-03-02T21:08:50Z

46 KB
Column_View.jpg

2018-03-21T15:13:05Z

18 KB
QB_searchpanel.png

2018-09-06T12:59:42Z

67 KB
searchPanel.png

2018-09-13T17:27:42Z

116 KB
searchPanel1.png

2018-09-13T17:27:42Z

117 KB

All Comments (9) Change History

tomconrad 2018-04-03T14:49:59Z

Sort and Undo requests moved to issue's #15549 and #15550

harishkhattri 2018-09-06T13:01:29Z

UNIT TEST -

Connect to the database;select any database and right click ->Query Builder
Select particular table from left side Table data pane drag it to design pane(or right click -> ADD TO DIAGRAM)
Click on Search Icon and press any key to be searched.
The Column name starting with that particular key will be highlighted.
If column is not present, No match error will be shown in Search Text box (here) .

juhisindhani 2018-09-10T10:43:59Z · (edited)

We came across following issues for search feature in Query Builder Design Pane :

1.After clicking on search icon, the cursor should automatically point to search field.

2.'Search for:' text should be non-editable.

3.'(No match)' text should be displayed for only one time in search field. currently getting 'no match' text multiple times for single search.

4.Text box size is much bigger.

juhisindhani 2018-09-12T13:20:15Z

Observation:

1. It should not allow user to enter some text before 'Search for:' in search field.

2. If I move the cursor in the middle of the 'Search for:' text, it should not allow user to type anything in between.

Pankaj.Isarka 2018-09-13T17:33:02Z

Hi Tom
In this enchantment.
Is it fine if we not show "(no match)" text and just change the text color to "RED" if not found..?
Please check screenshot searchPanel and searchPanel1

tomconrad 2018-09-13T20:29:44Z · (edited)

Hi Pankaj,

A couple issues...

You should have (no match) for consistency
"Search For" should "Search for"
After the search is done and the search field loses focus, the "Search for" and text should be cleared.
For consistency with other searches, the search should be case insensitive.
Once the entity gains focus, just typing should take you to the search field. You should not have to click on the magnify icon to get access to the search only.

Asif, Thoughts on this as you know more about it than I do.

Thanks, Tom

abdullah 2018-09-17T16:42:18Z · (edited)

Hi Pankaj,

The search UI is not consistent with our other search UI. Checkout search in schema tree, the search should functionality and UI should be similar. There is no need for a permanent search icon.

Please undo the changes made and use following api to enable search option and its UI. We might have to tweak a bit to make the search work.

SearchableUtils.installSearchable(entityTable);

If you need more details please feel free to do a call.

Thanks

Hi Pankaj,

The search UI is not consistent with our other search UI. Checkout search in schema tree, the search should functionality and UI should be similar. There is no need for a permanent search icon.

Please undo the changes made and use following api to enable search option and its UI. We might have to tweak a bit to make the search work.

SearchableUtils.installSearchable(entityTable);

If you need more details please feel free to do a call.

Thanks

tomconrad 2018-09-18T16:11:43Z · (edited)

Hi Pankaj,

This new behavior looks a lot better.

Thanks, Tom

juhisindhani 2018-09-19T11:17:27Z

Tested on: windows, mac

Build version: ADS 19.5.0-dev-34

Search function added to the Query Builder is working fine. Hence, marking it verified.

Search Tips

Aqua Data Studio / nhilam

Would like search feature in Query Builder Design Pane

10 attachments

Issue #15533

Completion

2 issue links

Issue #15550

Issue #15549

Search Tips

Aqua Data Studio / nhilam

Title

Would like search feature in Query Builder Design Pane

10 attachments

Issue #15533

Completion

2 issue links

Issue #15550

Issue #15549