Re: Expand/Collapse Nodes in Query Window

I am aware of that. I said this feature was available in pgadmin 3. I was
also told it was put into pgadmin 4 but there was a technical issue with it
that was going to be patched with the most recent version. That didn't
happen. Can you please include my recap on my prior email in that thread?

On Mon, Jun 17, 2024 at 10:57 PM Aditya Toshniwal <
aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:

> Hi Cody,
>
> pgAdmin 3 is not supported. Only latest version of pgAdmin 4 is supported.
>
> On Mon, Jun 17, 2024 at 8:49 PM Cody Boorman <cboorman(at)nabancard(dot)com>
> wrote:
>
>> I don't have access to a github account with my organization. Can you
>> please add to the ticket on my behalf? I've copy/pasted a recap of the
>> issue along with two screenshots below:
>>
>> I'm having some trouble opening and saving SQL files. I tried changing
>> the default program to open SQL files as SQL but it still gives me the same
>> error which I've attached here. As you can also see from the first
>> screenshot, the icon is coming through as a .txt file by default as well.
>>
>> Because of this, I am unable to save SQL files or open them directly in
>> pgadmin. I have to use a workaround of copy/pasting into pgadmin, changing
>> my dates and then copy/paste back into the text file and save but there's
>> some issues with this.
>>
>> IT at NAB wasn't able to figure it out and remoted in to both my system
>> and my manager's system to see if there were any differences in settings
>> but couldn't find any. Would you be able to look into this further? I am
>> using version 1.22.2.
>>
>> Thanks,
>> Cody
>>
>> On Mon, Jun 17, 2024 at 8:52 AM Aditya Toshniwal <
>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>
>>> Hi Cody,
>>>
>>> The code folding in pgAdmin currently is not really in a very good state
>>> due to an upgrade of an underlying package(CodeMirror). We're continuously
>>> working to make it better. What you can do is mention your suggestion on
>>> the ticket I mentioned.
>>>
>>> On Mon, Jun 17, 2024 at 7:55 PM Cody Boorman <cboorman(at)nabancard(dot)com>
>>> wrote:
>>>
>>>> Hello, that looks to be referring to just begin/end if statements. I'm
>>>> referring to any long list of data being selected in a parentheses (ie,
>>>> WHERE ID Number IN (a, b, c, d, etc) where there might be hundreds or
>>>> thousands of items. PGAdmin 3 used to have an expand/collapse button so you
>>>> can see your code more clearly by collapsing the list of IDs found in the
>>>> where clause and PGAdmin 4 doesn't have the expand/collapse buttons.
>>>>
>>>> On Sun, Jun 16, 2024 at 10:38 PM Aditya Toshniwal <
>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>>>
>>>>> Hi Cody,
>>>>>
>>>>> You can track - https://github.com/pgadmin-org/pgadmin4/issues/7280
>>>>>
>>>>> On Fri, Jun 14, 2024 at 7:20 PM Cody Boorman <cboorman(at)nabancard(dot)com>
>>>>> wrote:
>>>>>
>>>>>> Hello,
>>>>>>
>>>>>> Please update me on this.
>>>>>>
>>>>>> Thanks,
>>>>>> Cody
>>>>>>
>>>>>> On Tue, May 14, 2024 at 12:28 PM Cody Boorman <cboorman(at)nabancard(dot)com>
>>>>>> wrote:
>>>>>>
>>>>>>> Hello,
>>>>>>>
>>>>>>> Just following up on this.
>>>>>>>
>>>>>>> On Mon, May 6, 2024 at 10:51 AM Cody Boorman <cboorman(at)nabancard(dot)com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Hello,
>>>>>>>>
>>>>>>>> Looks like this is still happening with the most recent version. Is
>>>>>>>> this known?
>>>>>>>>
>>>>>>>> On Mon, Feb 19, 2024 at 2:25 AM Aditya Toshniwal <
>>>>>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>>>>>>>
>>>>>>>>> Hi Cody,
>>>>>>>>>
>>>>>>>>> pgAdmin does a release every month. So it would be in the week of
>>>>>>>>> 7th March.
>>>>>>>>>
>>>>>>>>> On Wed, Feb 14, 2024 at 9:17 PM Cody Boorman <
>>>>>>>>> cboorman(at)nabancard(dot)com> wrote:
>>>>>>>>>
>>>>>>>>>> Thanks! ETA on when that'll be released?
>>>>>>>>>>
>>>>>>>>>> On Tue, Feb 13, 2024 at 11:46 PM Aditya Toshniwal <
>>>>>>>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>>>>>>>>>
>>>>>>>>>>> Hi Cody,
>>>>>>>>>>>
>>>>>>>>>>> This is a known bug. It will be fixed in the next release of
>>>>>>>>>>> v8.4.
>>>>>>>>>>>
>>>>>>>>>>> On Tue, Feb 13, 2024 at 3:21 PM Cody Boorman <
>>>>>>>>>>> cboorman(at)nabancard(dot)com> wrote:
>>>>>>>>>>>
>>>>>>>>>>>> Hello,
>>>>>>>>>>>>
>>>>>>>>>>>> I just transitioned to PGAdmin 4 and I don't see the
>>>>>>>>>>>> expand/collapse nodes for items in parenthesis that PGAdmin 3 had in the
>>>>>>>>>>>> query window so you can minimize large scripts that had a lot of data in
>>>>>>>>>>>> the WHERE clause. I have version 7.8 but I spoke to our DBA who had the
>>>>>>>>>>>> latest 8.3 version and they weren't appearing for him either.
>>>>>>>>>>>>
>>>>>>>>>>>> --
>>>>>>>>>>>> Cody Boorman
>>>>>>>>>>>> Financial Analyst
>>>>>>>>>>>> North American Bancard
>>>>>>>>>>>> 250 Stephenson Hwy, Troy, MI 48083
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>> Thanks,
>>>>>>>>>>> Aditya Toshniwal
>>>>>>>>>>> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
>>>>>>>>>>> <https://www.enterprisedb.com/>
>>>>>>>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> Cody Boorman
>>>>>>>>>> Financial Analyst
>>>>>>>>>> North American Bancard
>>>>>>>>>> 250 Stephenson Hwy, Troy, MI 48083
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Thanks,
>>>>>>>>> Aditya Toshniwal
>>>>>>>>> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
>>>>>>>>> <https://www.enterprisedb.com/>
>>>>>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> Cody Boorman
>>>>>>>> Financial Analyst
>>>>>>>> North American Bancard
>>>>>>>> 250 Stephenson Hwy, Troy, MI 48083
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Cody Boorman
>>>>>>> Financial Analyst
>>>>>>> North American Bancard
>>>>>>> 250 Stephenson Hwy, Troy, MI 48083
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Cody Boorman
>>>>>> Financial Analyst
>>>>>> North American Bancard
>>>>>> 250 Stephenson Hwy, Troy, MI 48083
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Thanks,
>>>>> Aditya Toshniwal
>>>>> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
>>>>> <https://www.enterprisedb.com/>
>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>
>>>>
>>>>
>>>> --
>>>> Cody Boorman
>>>> Financial Analyst
>>>> North American Bancard
>>>> 250 Stephenson Hwy, Troy, MI 48083
>>>>
>>>
>>>
>>> --
>>> Thanks,
>>> Aditya Toshniwal
>>> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
>>> <https://www.enterprisedb.com/>
>>> "Don't Complain about Heat, Plant a TREE"
>>>
>>
>>
>> --
>> Cody Boorman
>> Financial Analyst
>> North American Bancard
>> 250 Stephenson Hwy, Troy, MI 48083
>>
>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
> <https://www.enterprisedb.com/>
> "Don't Complain about Heat, Plant a TREE"
>

--
Cody Boorman
Financial Analyst
North American Bancard
250 Stephenson Hwy, Troy, MI 48083