espoCrm 5.9.4 and Advanced Pack 2.6.1

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • item
    Active Community Member
    • Mar 2017
    • 1476

    espoCrm 5.9.4 and Advanced Pack 2.6.1

    Hello Yuri,
    a group report for meeting entity with grafic . when i click grafic . .modal view come.. but duration is empty
    if i click "view" then i close the view... duration is visible.

    Regards
    If you could give the project a star on GitHub. EspoCrm believe our work truly deserves more recognition. Thanks.​
  • Maximus
    Senior Member
    • Nov 2018
    • 2731

    #2
    Hello,
    I've tried to reproduce and it went w/o the issue occurring. Try to clear the browser cache and try again.

    Comment

    • item
      Active Community Member
      • Mar 2017
      • 1476

      #3
      Hello Maximus,
      can't test in demo (no advanced pack).. but duration field is out-of-box field.
      idem error for call ..

      maybe : Espo.ERROR: (42S22) SQLSTATE[42S22]: Column not found: 1054 Unknown column 'meeting.duration' in 'where clause'; GET /api/v1/Report/action/runList?id=5c799d0dd5757a962&groupValue=900&select =name%2Ctype%2Cstatus%2CdateStart%2CdateStartDate% 2Cduration&maxSize=20&offset=0&orderBy=dateStart&o rder=desc; line: 132, file: /application/Espo/ORM/DB/Mapper.php [] []
      Last edited by item; 11-09-2020, 08:29 PM.
      If you could give the project a star on GitHub. EspoCrm believe our work truly deserves more recognition. Thanks.​

      Comment

      • Maximus
        Senior Member
        • Nov 2018
        • 2731

        #4
        > but duration field is out-of-box field.

        Yep, but 'duration' is not storable field. It doesn't exist in the DB. Obiviously that such request will throw this error. Try to clear browsers cache with the advanced browser settings.
        Or you have some customization that makes this field storable?

        For example here is my request:
        Code:
        GET /api/v1/Report/action/runList?id=5fa9578756add64af&maxSize=20&offset=0&o rderBy=dateStart&order=desc
        Last edited by Maximus; 11-10-2020, 08:58 AM.

        Comment

        Working...