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

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(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.
>
> [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.
>
> [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.
>
> [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.
>
> [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.
>
> [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?
>
>
> [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?
>
>
> 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
>>>>>>
>>>>>