Re: Expand/Collapse Nodes in Query Window

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