SuiteCRM Query LIMIT

English Language - Forum
1

Hi. I wondering how limit in querys are building and where can it be disabled?

2

As a start, your question is really difficult to understand, and we’d be better able to help you if you read through:

https://www.chiark.greenend.org.uk/~sgtatham/bugs.html

Please try and give a better idea of what you’re trying to do, and where you are in the suiteCRM interface. (Pictures/screenshots are useful) That way people will be able to see and understand better what you are trying to achieve, and you’re more likely to find someone that can help. Make it as easy as you can for the helper, and that way there’s a greater chance that someone will be able to provide you with useful pointers.

In an attempt to provide pointers… If you’re in direct control of your queries, you can do something akin to:

SELECT * from users;

and change it to:

SELECT * FROM users LIMIT 5;

in order to get only the first 5.

This is at a database prompt (phpmyadmin) etc

Alternatively, if I assume that you are working in reports, WHICH doesn’t have the LIMIT directive in the same way, you can add/modify conditions (a separate tab once you’ve selected the fields that you want) for before a certain date AND after a certain date in order to match your requirements

3

There is a config value for that:

array (
    'special_query_limit' => 50000,
    'special_query_modules' => 
    array (
      0 => 'AOR_Reports',
      1 => 'Export',
      2 => 'Import',
      3 => 'Administration',
    ),
    'default_limit' => 1000,
  ),

-> The default limit refers to all modules that are not listed in the special_query_modules.

4

Thank you for your responses. I’m sorry that I didn’t immediately clarify what I needed. I’m interested in exactly how to remove LIMIT for query in custom Dashlet. Query like this - (WHERE colum BETWEEN date AND date) - custome query and standart Suite query - (Without any LIMIT)