List collector variable issue

[Vengadeshgiri]

Hello All,

Im facing some issues with list collector variable and getting some error :

"Error MessageInformation could not be downloaded from the server because the transaction was canceled
Transaction time: 15,565ms
Reason: maximum execution time exceeded"

Actually this is on hardware table it may have lakhs of records, and I used reference qualifier that is based on other variable. So Hidden this field on load but still this exeuction error is coming

Does anyone have any idea

Regards

Vengadesh

[Vengadeshgiri]

Hi @onkarshivgan 

Actually I have two static filter query like 

state and substate and one more query based on stockroom

So I hidden that field if stockroom is empty , once value is added lists are populated

 So probably this will work on change of the stockroom

But the issue is only with onload itself

[onkarshivgan]

Try this:

use: Reference Qualifier:

if (current.variables.stockroom.nil()) {

    'sys_idISEMPTY';

} else {

    'state=1^substate=available^stockroom=' + current.variables.stockroom;

}

Reload the variable when stockroom changes:

Add Catalog Client Script (onChange):

g_form.clearOptions('your_list_collector_name');

g_form.refreshReference('your_list_collector_name');

Also, I would say for best performance try to use Lookup select box

[Vengadeshgiri]

Seems fine for onload but else part is not working even if stockroom has value