Обсуждение: Either Find does not work or I don't know how to make it work
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.
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.
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.
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.
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.
Step 6: By ignoring all the fancy gui elements, and going back to plain old sql, I can **find** what I am looking for.
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?
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 background. Replace, 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
Вложения
On Mon, Feb 18, 2019 at 6:28 AM Malik Rumi <malik.a.rumi@gmail.com> wrote:
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.
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.
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.
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.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.
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.
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.
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 background. Replace, 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
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Вложения
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:
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.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.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.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.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.Step 6: By ignoring all the fancy gui elements, and going back to plain old sql, I can **find** what I am looking for.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?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 background. Replace, 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
