Re: Either Find does not work or I don't know how to make it work

Поиск
Список
Период
Сортировка
От richard coleman
Тема Re: Either Find does not work or I don't know how to make it work
Дата
Msg-id CAGA3vBu1mob9M3eUue8kJNb8R415NH0pma+WB1QcnGtHoryZnw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Either Find does not work or I don't know how to make it work  (Malik Rumi <malik.a.rumi@gmail.com>)
Список pgadmin-support
Malik, 

As I had mentioned before, the find function doesn't work as a 'find my data' type of search function.  I will admit that the  View/Edit Data -> Filtered rows functionality really does need some work.  Not only is the Query Editor portion read only for some reason, it removes much of the impetus for having a GUI in that you need to remember and correctly spell the field names you are looking for. All it does is present you with a read only  "SELECT * FROM <table_name> WHERE " <data from the text box that you had entered>" Query Editor.  Personally I just create editable query windows by using the Query Tool menu option.  The only use I have for the find functionality presently available in pgAdmin4 is when I have a very long query in an editable Query Editor where I want to either find a particular string, or replace a bunch of them, such as replacing all 1/1/2017 with 1/1/2018, and I don't mind dealing with the disappearing find/replace GUI.  Otherwise I simply copy my query into a more capable text editor, do all of my find/replace operations and past it back into an editable query editor.  

You might want to submit a bug/feature request on the official RedMine site to deal with the above issues.

I wish I better news.

rik.  

On Mon, Feb 18, 2019 at 1:28 AM Malik Rumi <malik.a.rumi@gmail.com> wrote:
Nebraska_pg4_test1_edit.png

Step 1: An attempt to find Nebraska in my database while in the edit tab. If it doesn't work here, how is anyone supposed to find something to edit?
Note both the magnifying glass and the 'edit data' tab are highlighted.

Screenshot from 2019-02-17 23-38-30.png
Step 2: I have put my search term in. I am not using any regex. I just want it to find the string I gave it. 

Nebraska_test_3.png

Step 3: I hit 'Enter', and the whole thing vanishes without a trace - including any kind of result, or message as to what went wrong.

Nebraska_test_4_query.png
Step 4: An attempt to use the 'Query' tab - see upper right hand corner. But the result is the same: NOTHING. In fact, this attempt was so nothing, I can't even show you that I put the same string, Nebraska, in the little search "window", because as soon as I clicked on the screen picture taker, my input vanished, never to return - or bring any results with it. 

find_docs.png

Step 5: When all else fails, read the instructions - again. For the first time, I notice that 'find', and the magnifying glass icon that goes with it, is only for searching **code**, not data.

nebraska_works.png

Step 6: By ignoring all the fancy gui elements, and going back to plain old sql, I can **find** what I am looking for.

Nebraska_pg4_test1_edit.png

Step 7 - A Question: Then what is the purpose of the 'starter' set of sql that shows up in this window? I can't edit it. It's just there to tell me what ran?


nebraska_test2.png

Step 8: a second question: What is the purpose of this 'functionality' that acts like it wants to run a general purpose search for me, when in fact it does not? 


thank you.

“None of you has faith until he loves for his brother or his neighbor what he loves for himself.”


On Wed, Feb 13, 2019 at 11:58 AM richard coleman <rcoleman.ascentgl@gmail.com> wrote:
Malik, 

You are trying to Find in the Data Output?  I don't think pgAdmin's Find feature works in anything except the Query Editor (at least that's been my experience).  If you are looking at anything else on the screen you can try the browser's find functionality, but that will only work with what's displayed.  I think that might be where the disconnect is.  The Find/Replace feature in pgAdmin4 (including the magnifying glass menu) only work in the Query Editor, Query Tool.  When Dave Page said that it works fine for him, I don't think he realized that you were trying to use the Find feature in the Data Output section of pgAdmin.

I hope that helps, 

rik.

On Wed, Feb 13, 2019 at 12:49 PM Malik Rumi <malik.a.rumi@gmail.com> wrote:
Well, I am happy to learn it isn't just me....

But I am not getting the scroll and highlight behavior you describe. Hitting Ctrl+F and Cntrl+G just opens the Find on Chrome - which for whatever reason does not work to find anything in the pgadmin4 tables....


“None of you has faith until he loves for his brother or his neighbor what he loves for himself.”


On Wed, Feb 13, 2019 at 11:00 AM richard coleman <rcoleman.ascentgl@gmail.com> wrote:
Malik, 

Yes, I can confirm that it's rather counterintuative.  Ubuntu 18.10, Chromium here.  Cntrl-F in the query window causes the Search: bar to appear.  Doing anything other than clicking in the text box to the right of the Search: will cause the search bar to disappear.  Entering text into that text box and hitting the enter key will also cause that Search bar to disappear and it will scroll to the first instance of the result (if it isn't already on the screen and highlight all matches. Cntrl-G will select each match in order.  Selections are indicated by having a grey backgroundReplace, in my opinion, is worse.  More disappearing bars.  Enter the existing text after the Replace: then it disappears replaced by a With: that you enter what you want it replaced with, which then also disappears.  A UI that presented the end user with both Find: & Replace at the same time, and didn't keep disappearing would be most helpful.

Just my $0.02.

rik.

On Wed, Feb 13, 2019 at 11:45 AM Malik Rumi <malik.a.rumi@gmail.com> wrote:
I'm on ubuntu 17, Chrome 72.  I am happy it is working for you, but I repeat, once I hit Enter, I got nothing, nada, zip.



“None of you has faith until he loves for his brother or his neighbor what he loves for himself.”


On Wed, Feb 13, 2019 at 3:47 AM Dave Page <dpage@pgadmin.org> wrote:
On Tue, Feb 12, 2019 at 8:26 PM Malik Rumi <malik.a.rumi@gmail.com> wrote:
>
> I can't make heads or tails out of 'find'. When I click on the magnifying glass, I get a little
> Search:
> But once I put something in there, nothing happens, and if I hit Enter, it all just goes away like I hadn't done anything. I am looking at the docs  https://www.pgadmin.org/docs/pgadmin4/dev/query_tool.html
>
> and they don't help me at all.

I just tested here and it's working fine for me. I hit Cmd+F, type
BEGIN in the box and hit return, and it highlights all the occurrences
of BEGIN as well as selecting the first one. Cmd+G selects the next
one.

What are you searching for exactly? Are you using a regexp or plain string?

What platform and browser are you using? I'm on macOS 10.14 with
Chrome 71.0.3578.98.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Вложения

В списке pgadmin-support по дате отправления:

Предыдущее
От: "Michael Schulz"
Дата:
Сообщение: Antw: Re: Re: Re: pgadmin modify role properties
Следующее
От: 길P.day93
Дата:
Сообщение: Make.bat environment