Cannot order Tasks within the Activities Sub panel correctly

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

I’m using SuiteCRM version 7.11.15 an an hosted Apache Server
Chrome or Firefox Browser

Cannot order Tasks within the Activities Sub panel correctly. Additionally the date format is messed up. See attachment.

I have tried a lot but did not find a solution. I have seen this issue and tried to change the requested lines but without success.

History panel won’t sort by Due Date for Cases #6040

I have lot of tasks for each account and if I cannot order data by DueDates correctly SuiteCRM is useless.

Please can you tell me if there is a solution?

Thanks

SuiteCRM Account-Subpanel-Activites-DueDate-Order and Format Problem
SuiteCRM Account-Subpanel-Activites-DueDate-Order and Format Problem3254×1675 393 KB

2

No one with the same problem?
That fault drives me crazy.

3

Just tested on my instance and yes same issue - Version 7.11.5

I am surprised this hasn’t been raised sooner

Can order ‘Activities’ by subject, status, assigned user but ‘due date’ does nothing and it is in no order

4

Is an option, you can make a separate subpanel for tasks.

5

Would you need to create a new relationship?

This would work but would limit the users to creating from that subpanel

You would need to hide the ‘create task’ button from the activities sub panel as it uses the default relationshiip

6

there is no need to create new relationships.
It is enough just to create a subpanel, and copy the name of the link field to get_subpanel_data

7

Hi palach,
I cannot follow your explanation exactly.
If I would implement your suggestion, is it possible to see the activities for selected accounts as shown in the picture of the first message of this topic? And would it be possible to create new tasks from this sub panel for this account?

8

Here is an example of creating a new subpanel:

In this case it changes the query, but there are other ways to do it

9

Hi pgr,

Thanks for the sample.

I understand that I can create a new Account Task SubPanel. But this SubPanel only contains one type as far as i believe. A Task, Call or a Meeting. The Activities SubPanel is a very useful and a special one which contains all together and that’s very helpful if you have to process different type of tasks in sequence.

I assume that there is most probably a query behind this SubPanel and the order mechanism could be there as well.

It seems to be a general fault and it should be corrected. Do you probably know where we could search for a workaround until its solved?

Do you know where this DueDate “order” fault could be corrected?

10

The problem is that the field in the date_due database exists only in the task module, if you add such a field to calls and appointments, and configure automatic subtraction through hooks, the problem should be solved.

11

Hi palach,
Thanks for your suggestion. That could solve the problem if more than “Tasks” are seen in the Activities panel.
But, (before I try to implement hooks), please look at the screenshot of my first post. In that case, the Activities panel only contains “Task” entries and even though the order is wrong. I’m not a specialist but I think that it most probably would not help…

It seems that I have to wait until a developer resolves that bug. I like SuiteCRM but that’s the drawback of an open source solution )-:

12

I saw your screenshot, and faced this problem, I don’t remember how they solved it, but I remember exactly that there is a field in the SugarBean of these modules, but it is non-db, that is, it is not contained in the database but is calculated. because of this, such problems arise.

13

You are right. The database records contain correct date stamps.
It would be very helpful if I could debug that but I have no glue how to do this on a hosted server…

14

If the problem happens on the live demo also, it’s a common bug for everyone. So that would mean you can debug a local server and when you find the solution, move it to the hosted server.