You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Girvin Herr <gh...@fastmail.com> on 2022/10/15 19:12:57 UTC
Form Name sorting inconsistency
Greetings,
I am using AOO 4.1.12 under Slackware Linux 4.4.301, xfce4, mariadb
1.0.38, mysql-connector-java 5.1.42. Note that I am not using the AOO
Base internal server, but mariadb as an external server and the mysql
connector in the middle.
I am getting some strange, inconsistent with sorting norms and
expectations, form name sorting under the Forms option in AOO Base. I
just tried renaming my database forms with a dash (-) prefix in order to
force those names to the top of the list, i.e.:
inventories.CS_Computer_Software_Data_entry
after renaming becomes:
inventories.-CS_Computer_Software_Data_entry
I cannot place the dash before "inventories" because that is the
database name and as such cannot be changed or other failures will
occur. However, as a result the AOO Forms list sorting becomes as this
snippet shows:
...
inventories.au_song_Title_Data_entry
inventories.-CS_Computer_Software_Data_entry
inventories.CS8_Computer_Software_Data_entry
...
Since when is a dash character subordinate to a lower-case character
("a" in the above case), let alone _any_ alpha-numeric character!? I was
hoping the dash would force the listing to go to the head of the list,
before any lower case entries.
Is there any way to correct this and get it to sort properly, or is this
a bug?
Thanks.
Girvin
Re: Form Name sorting inconsistency
Posted by Girvin Herr <gh...@fastmail.com>.
Greetings,
I discovered the key to sorting these lists is to close the database and
reopen it. The lists are only sorted when something is added to the list
or the database is opened. Just switching to another list and back does
not re-sort it.
It is a work-around. My immediate problem is solved.
Girvin
On 10/15/22 4:08 PM, Girvin Herr wrote:
> Here is an addendum:
>
> Since I posted this thread, I copied a form from another database and
> the new form was put at the bottom of the list, even though it should
> have gone in somewhere in the middle if sorted (unless I switched
> universes and in this universe, P comes after V). That implies these
> names are in some sort of chronological order of creation, rather than
> sorted. If not sorted, is there a way to manually edit where these
> names are stored in order to manually sort them?
>
> Thanks.
>
> Girvin
>
>
> On 10/15/22 12:12 PM, Girvin Herr wrote:
>> Greetings,
>>
>> I am using AOO 4.1.12 under Slackware Linux 4.4.301, xfce4, mariadb
>> 1.0.38, mysql-connector-java 5.1.42. Note that I am not using the AOO
>> Base internal server, but mariadb as an external server and the mysql
>> connector in the middle.
>>
>> I am getting some strange, inconsistent with sorting norms and
>> expectations, form name sorting under the Forms option in AOO Base. I
>> just tried renaming my database forms with a dash (-) prefix in order
>> to force those names to the top of the list, i.e.:
>>
>> inventories.CS_Computer_Software_Data_entry
>>
>> after renaming becomes:
>>
>> inventories.-CS_Computer_Software_Data_entry
>>
>> I cannot place the dash before "inventories" because that is the
>> database name and as such cannot be changed or other failures will
>> occur. However, as a result the AOO Forms list sorting becomes as
>> this snippet shows:
>>
>> ...
>> inventories.au_song_Title_Data_entry
>> inventories.-CS_Computer_Software_Data_entry
>> inventories.CS8_Computer_Software_Data_entry
>> ...
>>
>> Since when is a dash character subordinate to a lower-case character
>> ("a" in the above case), let alone _any_ alpha-numeric character!? I
>> was hoping the dash would force the listing to go to the head of the
>> list, before any lower case entries.
>>
>> Is there any way to correct this and get it to sort properly, or is
>> this a bug?
>>
>> Thanks.
>>
>> Girvin
>>
>>
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Form Name sorting inconsistency
Posted by Girvin Herr <gh...@fastmail.com>.
Here is an addendum:
Since I posted this thread, I copied a form from another database and
the new form was put at the bottom of the list, even though it should
have gone in somewhere in the middle if sorted (unless I switched
universes and in this universe, P comes after V). That implies these
names are in some sort of chronological order of creation, rather than
sorted. If not sorted, is there a way to manually edit where these names
are stored in order to manually sort them?
Thanks.
Girvin
On 10/15/22 12:12 PM, Girvin Herr wrote:
> Greetings,
>
> I am using AOO 4.1.12 under Slackware Linux 4.4.301, xfce4, mariadb
> 1.0.38, mysql-connector-java 5.1.42. Note that I am not using the AOO
> Base internal server, but mariadb as an external server and the mysql
> connector in the middle.
>
> I am getting some strange, inconsistent with sorting norms and
> expectations, form name sorting under the Forms option in AOO Base. I
> just tried renaming my database forms with a dash (-) prefix in order
> to force those names to the top of the list, i.e.:
>
> inventories.CS_Computer_Software_Data_entry
>
> after renaming becomes:
>
> inventories.-CS_Computer_Software_Data_entry
>
> I cannot place the dash before "inventories" because that is the
> database name and as such cannot be changed or other failures will
> occur. However, as a result the AOO Forms list sorting becomes as this
> snippet shows:
>
> ...
> inventories.au_song_Title_Data_entry
> inventories.-CS_Computer_Software_Data_entry
> inventories.CS8_Computer_Software_Data_entry
> ...
>
> Since when is a dash character subordinate to a lower-case character
> ("a" in the above case), let alone _any_ alpha-numeric character!? I
> was hoping the dash would force the listing to go to the head of the
> list, before any lower case entries.
>
> Is there any way to correct this and get it to sort properly, or is
> this a bug?
>
> Thanks.
>
> Girvin
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org