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

On Mon, Feb 18, 2019 at 6:28 AM Malik Rumi <malik(dot)a(dot)rumi(at)gmail(dot)com> wrote:

> [image: 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.

>
> [image: 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.

>
> [image: 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.

>
> [image: 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.
>
> [image: 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.

>
> [image: 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.

>
> [image: 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.

>
>
> [image: 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(dot)ascentgl(at)gmail(dot)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(dot)a(dot)rumi(at)gmail(dot)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(dot)ascentgl(at)gmail(dot)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(dot)a(dot)rumi(at)gmail(dot)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(at)pgadmin(dot)org> wrote:
>>>>>
>>>>>> On Tue, Feb 12, 2019 at 8:26 PM Malik Rumi <malik(dot)a(dot)rumi(at)gmail(dot)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