Sorting not working?

ATSrl 2024-06-11 06:44:54 UTC #1

Hi All,
I am probably wrong or have not correctly understood how to use the module related to projects. If I select a project, I select infolog as the application, the records do not seem to be correctly sorted according to the start date. Changing the direction of the sorting nothing changes !!! See image.

Am I doing something wrong ?
Any and all suggestions are welcome
Gabriele.

StefanU 2024-06-11 08:16:57 UTC #2

Hi Gabriele.

Works for me:

Please switch to English for screenshots an show more (filter, …).

Stefan

ATSrl 2024-06-11 10:18:10 UTC #3

Hi Stefan,
If you do not select any application l’ordinamento funziona. If you instead select an application the sorting does not work

Gabriele

StefanU 2024-06-11 10:40:17 UTC #4

Works for me with filter:

Stefan

ATSrl 2024-06-11 12:47:37 UTC #5

HI Stefan
Unfortunately it doesn’t work for me. Has anyone had the same problem ? do you have any idea what it could be ?
would be of help
Thanks

StefanU 2024-06-11 13:42:49 UTC #6

You can:
New project: add one by one and test
Same in trial: https://www.egroupware.org/it/trial

Show more details: Filter, preferences, …

Stefan

ATSrl 2024-06-11 14:34:57 UTC #7

Hi Stefan,
I have tried all dates and all types of sorting. The only one that does not work is sorting by starting date.
Any suggestions ?
Gabriele

StefanU 2024-06-11 18:13:39 UTC #8

Same as bevore:

ATSrl 2024-06-16 16:34:09 UTC #9

Hi Stefan,
we have created a new installation from scratch and I have done the tests with ad hoc created data. Even in the new installation the sorting does not seem to work. i enclose the video.
Is this a bug or I do not understand something ?

Thank you

RalfBecker 2024-06-17 06:03:16 UTC #10

Problem is start-date (pm_real_start) is not a mandatory field, so it can be left empty. In that case sorting looks wrong, because the planned start-date moves up, and you mistake it for a wrongly sorted (real) start-date.

You can spot the difference by looking if its in italics (planned) and also if it top-aligns with the value in the column to the left. If it does not, you see the planned start-date, after which you did NOT sort.

Ralf

ATSrl 2024-06-17 13:57:50 UTC #11

Hi Ralf,
I don’t understand your answer. I clearly show in the video at minute 0.50 that all the records have the start date and yet they are not sorted correctly !!!
Gabriele

RalfBecker 2024-06-17 14:15:03 UTC #12

Open the project and check they all have a (real) start-date and not just a planned start-date.

The sorting either uses the real start-date or the planned start-date, but it’s a little hard to distinguish in the list.

Ralf

ATSrl 2024-06-17 15:18:22 UTC #13

Hi Ralf,
let me insist to understand correctly. If I select a project I find archived everything that I have linked to the project. if I ask to see what is linked in the INFOlOG for that project I find the list of records. in the picture are represented the emails that I have linked to a project. In the emails, as you can read in the help, the start date is assigned automatically. How then is it that the sorting does not work ?

Any advice is welcome
Gabriele

RalfBecker 2024-06-17 19:18:23 UTC #14

Look at the top line, you have a (real) start-date in normal font, and a planned start-date in italics below.

Now look at the other (wrongly sorted) line, and check they are not in italics, looks to me as they are, which means they get NOT sorted under that criteria.

Ralf

ATSrl 2024-06-18 06:07:06 UTC #15

Hi Ralf,
I understand what you are saying but then let me say that the headers are a little bit confusing to say just that. if you take an entry in infolog generated by an email the screen shot is as shown. The famous 2156 looks like this:

I see the Start Date, the Due Date and the Completed Date but I do not see the Planned Date which EGW seems to use for sorting. Using the Planned Date sorting seems to work. You will concede that the functionality is slightly confusing.
Thanks Gabriele

RalfBecker 2024-06-18 06:52:29 UTC #16

You still not understand it fully

ProjectManager has multiple start-dates:

(real) start-date: when something really started
planned start-date: when something was planned to start

EGroupware apps might not support both dates and depending on the app only set one of them:

InfoLog sets only planned start-date
TimeSheet sets (real) start-date

The sorting currently happens by either:

(real) start-date: the ones with no real start-date are unsorted
planned start-date: the ones with no planned start-date are unsorted

There is currently no sorting taking both into account while preferring one or the other!

Maybe we should always sort by both, and which of the two column header you click only differs by what to prefer, if both data are set:

(real) start-date: sort by real start-date, if set, and if not by planned start-date
planned start-date: sort by planned start-date, if set and if not by real start-date

Ralf

RalfBecker 2024-06-18 07:25:05 UTC #17

I implemented that now, please apply it to your installation and give feedback, if it behaves more like you expected:

To install the commit into your installation run:

curl https://github.com/EGroupware/projectmanager/commit/0ae0e88980c5525a59b3004e5b893f8370d06513.patch | docker exec -i egroupware patch -d /usr/share/egroupware/projectmanager -p1
docker ecec egroupware kill -s usr2 1

If you’re happy, the following will make sure the patch survives a restart of the container or reboot of the host:

curl https://github.com/EGroupware/projectmanager/commit/0ae0e88980c5525a59b3004e5b893f8370d06513.patch | docker exec -i egroupware patch -d /usr/share/egroupware-sources/projectmanager -p1

Ralf

ATSrl 2024-06-18 07:30:50 UTC #18

Hi Ralf,
Really thank you
Your support is invaluable.
Gabriele