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

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: Either Find does not work or I don't know how to make it work
Дата
Msg-id CA+OCxowKSjqhNb+0ZT-Oe7oUqM2666XPYm1YC-EkEbB0ve_nnQ@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


On Mon, Feb 18, 2019 at 6: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.

Use the Filter options to find rows matching your criteria. 
 

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. 

You told me in a previous email that you were trying to search in the query text. That is clearly not the case from your screenshot. As I said (as well as Richard), the search option in the SQL Editor text box is for searching the SQL Editor text.
 

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.

That's because nothing went wrong. Your search criteria doesn't match anything in the SQL Editor.
 

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.

Yes.
 

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.

If you're searching the results, then yes. That is how it is intended as SQL is *far* more powerful for such things. Not to mention that if you're working with anything more than a fairly trivially sized database trying to do that sort of searching on the client side would be insane.
 

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?

Yes.
 


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? 

You're starting the tool in one of two modes. Query Tool mode allows you to write arbitrary queries and view the results. View/Edit data mode allows you to view data and edit it. That mode does not allow you to edit the query as you could easily change it to something that is extremely difficult for pgAdmin to be able to figure out if the resulting dataset is updateable or 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


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

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

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

Предыдущее
От: Khushboo Vashi
Дата:
Сообщение: Re: Re: Re: pgadmin modify role properties
Следующее
От: "Michael Schulz"
Дата:
Сообщение: Antw: Re: Re: Re: pgadmin modify role properties