Dismiss Notice
We would like to remind you that we’re updating our login process for all 3CX forums whereby you will be able to login with the same credentials you use for the Partner or Customer Portal. Click here to read more.

reports question

Discussion in '3CX Phone System - General' started by ygonzales, Nov 14, 2016.

Thread Status:
Not open for further replies.
  1. ygonzales

    Joined:
    Nov 3, 2016
    Messages:
    12
    Likes Received:
    0
    Dear Team,
    When trying to generate big reports there is an error:

    * Report not generated in full because query contains too many records.

    just interested what is this
     
  2. YiannisH_3CX

    YiannisH_3CX Support Team
    Staff Member 3CX Support

    Joined:
    May 10, 2016
    Messages:
    7,326
    Likes Received:
    532
    Hello there,

    Please note that the maximum lines of a report is 10000. Anything longer than that will present you with this error.
     
  3. ygonzales

    Joined:
    Nov 3, 2016
    Messages:
    12
    Likes Received:
    0
    So,if i need more than 10000. is there any thing i can set like as 20000 or even maybe * ?
     
  4. XanthiZ

    3CX Support

    Joined:
    Dec 18, 2015
    Messages:
    46
    Likes Received:
    7
    Hello ygonzales

    In order to change the Report row limit you need to do the following:
    1) Go to Settings > Parameters
    2) Search for the parameter REPORT_ROW_LIMIT
    3) Edit the parameter and change the limit from 10000 to 20000 and press OK
    4) Restart Services

    If you have any questions please let me know ;)
     
  5. ygonzales

    Joined:
    Nov 3, 2016
    Messages:
    12
    Likes Received:
    0
    Thanks,
    Can you please also clarify in total talking: 2.07:17:46

    what does this mean :) If i count normally in excel it comes up to 55 minutes
    but what does this number means
     
Thread Status:
Not open for further replies.