cannot sort by date

HI, looking at task list and the dates - though I sort by them - are intermixed…

can I sort by only “due date” ?

THx a million

Dan

it seems it keeps being sorted by “creation date”

Hi Dan70,

Reading through your issue, I have tried to see if I encounter the same problem but I don’t seem to.

From the version I am running it seems to act as expected.

I can independently sort by Date Created and Due Date.

When you say ‘can I sort by only “due date” ?’, do you mean that you may be able to sort by more than one column, or no matter which column you sort by, it always seems to order by created date?

Thanks again,
Ellis.

HI Ellis, thank you!!!

yes, I can click on “sort by due date”, but still it sticks to the creation date.
pls see attached image

Thx a million

Dan

Ahh i see, that makes sense now, thank you.

Im not sure if this is the issue that you are having, but I noticed that if you refresh the dashlet, it causes sorting issues.

However, if you click the pencil/edit icon, and save it, this seemed to fix the issue? Would it be possible to try this and see how you get on please? I know it seems like it may not do much, but seemed to fix an issue that I spotted.

Thanks again,
Ellis.

1 Like

Hi Ellis,
thank you so much!

What I found is that thisseems to work with dashboard applet, but not when I open taks page…thats where I use it

it seems I have js errors

need to solve them and then see if it works again
Will keep you posted :slight_smile:
Really appreciate your help!
Dan

Hi Dan,

Ahh I see, sorry, I should have double checked where the issue was, but glad to see there was somewhat of a work around there :slight_smile:

Was this after some recent upgrade or has it seemed to never work?

If it seems that the js is acting up, you could try Repairing the JS files inside the Repair section of the admin panel, in the same location as Repair and rebuild.

Sometimes to be safe I just rebuild all of the JS file options, there are 4. These dont take long at all.

But yeah, feel free to keep us up to date and hopefully we get to the bottom of this :slight_smile:

Thanks again,
Ellis.

You may also:

  1. check SuiteCRM error log and report anything “FATAL” at the same moment in which the error occurred
  2. check Apache/PHP error log and report any errors at the same moment in which the error occurred
  3. check the browser javascript console and report any error message at the time in which you try sorting and it fails
  4. Refresh the browser and clear the browser cachhe (Ctr+F5 should be sufficient on most browsers)
  5. Try with a different browser
  6. Try on a different computer
  7. Check that permissions are set correctly (please specify how you have set them)
2 Likes

Hi amarius,
thank you so much

Already posted my latest errors in another thread (“can’t use the X delete icon”)…
since you asked, here are my latest errors (again)

Wed Jun 20 14:20:28 2018 [29682][1][FATAL] error loading relationship project_resource
Wed Jun 20 14:20:28 2018 [29682][1][FATAL] error loading relationship am_projecttemplates_resources
Wed Jun 20 14:20:33 2018 [29692][1][FATAL] Exception handling in /home/consetus/crm/include/MVC/Controller/SugarController.php:402
Wed Jun 20 14:20:33 2018 [29692][1][FATAL] Exception in Controller: Fehler beim Anzeigen des Datensatzes. Dieser Datensatz wurde entweder gelöscht oder Sie sind nicht berechtigt ihn zu sehen.
Wed Jun 20 14:20:33 2018 [29692][1][FATAL] backtrace:
#0 /home/consetus/crm/include/MVC/View/views/view.detail.php(101): sugar_die(‘Fehler beim Anz…’)
#1 /home/consetus/crm/modules/Contacts/views/view.detail.php(68): ViewDetail->display()
#2 /home/conXXX/crm/include/MVC/View/SugarView.php(207): ContactsViewDetail->display()
#3 /home/conXXX/crm/include/MVC/Controller/SugarController.php(432): SugarView->process()
#4 /home/conXXX/crm/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#5 /home/conXXX/crm/include/MVC/SugarApplication.php(109): SugarController->execute()
#6 /home/conXXX/crm/index.php(52): SugarApplication->execute()
#7 {main}
Wed Jun 20 15:32:24 2018 [8002][1][FATAL] error loading relationship project_resource
Wed Jun 20 15:32:24 2018 [8002][1][FATAL] error loading relationship am_projecttemplates_resources
Wed Jun 20 15:41:40 2018 [9253][1][FATAL] error loading relationship project_resource
Wed Jun 20 15:41:40 2018 [9253][1][FATAL] error loading relationship am_projecttemplates_resources
Thu Jun 21 08:33:51 2018 [973][1][FATAL] log call at: modules/Administration/index.tpl:54 - MY_FRAME is not set
Thu Jun 21 08:34:30 2018 [1046][1][FATAL] log call at: modules/Administration/index.tpl:54 - MY_FRAME is not set

  1. Where would the Apache error log be? in the CRM folder? or elsewhere?

  2. not sure I do this correctly, get this error in Console after clicking “sort by date”

 [Show/hide message details.] Error: Syntax error, unrecognized expression: Keine aktuellen Benachrichtigungen. sugar_grp1_jquery.js:2:12467
t</gb.error
https://www.crm.conXXX.de/cache/include/javascript/sugar_grp1_jquery.js:2:12467
t</gb.tokenize
https://www.crm.conXXX.de/cache/include/javascript/sugar_grp1_jquery.js:2:18391
t</gb.select
https://www.crm.conXXX.de/cache/include/javascript/sugar_grp1_jquery.js:2:21122
gb
https://www.crm.conXXX.de/cache/include/javascript/sugar_grp1_jquery.js:2:7100
find
https://www.crm.conXXX.de/cache/include/javascript/sugar_grp1_jquery.js:2:23394
n.fn.init
https://www.crm.conXXX.de/cache/include/javascript/sugar_grp1_jquery.js:2:23934
n
https://www.crm.conXXX.de/cache/include/javascript/sugar_grp1_jquery.js:2:405
Alerts.prototype.updateManager/<
https://www.crm.conXXX.de/cache/include/javascript/sugar_grp1.js:21:100
j
https://www.crm.conXXX.de/cache/include/javascript/sugar_grp1_jquery.js:2:26906
fireWith
https://www.crm.conXXX.de/cache/include/javascript/sugar_grp1_jquery.js:2:27724
x
https://www.crm.conXXX.de/cache/include/javascript/sugar_grp1_jquery.js:4:11063
b/<
https://www.crm.conXXX.de/cache/include/javascript/sugar_grp1_jquery.js:4:14577
  1. still cannot sort by date

  2. will ttry later

  3. most file permissions in the folder are 644, subfolders have mostly 755

The support here is really fanatastic, thank you!!!

Dan

update & solved

pls check https://suitecrm.com/suitecrm/forum/feedback/19518-the-x-for-close-delete-in-the-overview-is-not-working?start=15#69998