Re: Expand/Collapse Nodes in Query Window

Sure I will do that.

On Tue, Jun 18, 2024 at 6:41 PM Cody Boorman <cboorman(at)nabancard(dot)com> wrote:

> 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
>

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
<https://www.enterprisedb.com/>
"Don't Complain about Heat, Plant a TREE"