Some left lists have many columns and there may be an instance where it makes sense to filter the list with multiple criteria. For example, you might want to filter the left list in Sales, Orders, Orders (GESSOH). In the standard product, when you attempt to utilize a 6th column filter, you will receive an error "CRITERE(0): Too many criteria"

The issue is that the CRITERE variable used in a left list is not an array. CRITERE is only a char(250). This error basically means that we are exceeding the 250 character limit.

You can attempt to mitigate the issue using an advanced selection list that is already filtered.

There is not a method to change this within the standard product, but you can work with your development business partner to create a small modification. This modification would need to be done for every function where you may determine it is necessary to filter columns with many criteria.

For example a code modification may include something similar to:

#############################################

$ACTION

  Case ACTION

    When 'OUVRE' : Gosub OUVRE

  Endcase

Return

$OUVRE

  Kill CRITERE

  Global Char CRITERE(250)(1..2)

Return

#############################################

Please work with your business partner to develop, test, and implement the solution.

This is also found on the knowledgebase in KB ID 88901.

Casey Knapp

Principal Analyst, North America Services

Sage