Question

How to unlock the maximum number of filters for a lookup ?

Hi community,

 

As an OOTB feature of Creatio, when using the "simple" filter on a lookup, a maximum number of 15 entries are displayed.

How is it possible, via some coding (or at least I doubt it will be with code), to unlock this maximum number of entries when filtering ?

 

Is there a way to dynamically display all the entries of a lookup or is it only possible to display it with a constant value ?

 

Many thanks for the help provided.

 

Best regards,

Jonathan

 

Like 0

Like

2 comments

Hello Jonathan,

 

There is a restriction in the system on the number of fields displayed in the quick filter for this field (15 records). 



If you want to choose all possible variants of the lookup you can use an advanced filter that doesn't have restrictions on the number of records (you will see a pop-up window with all options to choose from). The number of records displayed by the quick filter can be changed only via development and there is no possibility to change this amount with the help of out-of-the-box tools of the instance (there is no appropriate system setting or lookup value to change).



We already have a query registered for our responsible R&D team to consider implementing this functionality in future versions of the Creatio application. I will assign your case to this project in order to increase its priority.

 

Best regards,

Anastasiia

Hi Jonathan

 

I haven't testing this but this should work:

 

This setting should be added to the section page schema in the init method. Here is an example for the ContactSectionV2 replacing schema:

 

define("ContactSectionV2", [], function() {

    return {

        entitySchemaName: "Contact",

        methods: {

            init: function () {

Terrasoft.SysSettings.lookupRowCount = 60;

this.callParent(arguments);

            }

        }

    };

});

 

Refreshing / reloading the page will set this setting back to the default value, so that's why we need to put this in the init method. When the page will load again, lookupRowCount will be set to the desired value again.

 

Jeremy

Show all comments