0

Multiple Link= requirements on NL function have used all 10 Filter items, now what?

Gary Winey

September 29, 2017 19:56

None

Follow

Hello all,

We need to create a report of assembly items sorted by customer with the ability to filter by item number and customer number. Using the following NL function, we can link from the Assembly Line table to the Customer table via intermediate links to the Assemble-to-Order Link and Sales Header tables.

The filters work as expected for both the Item Number and Customer. The problem that we have encountered is that we are out of room on the NL function filters. This is causing 2 issues.
    1. There is no room to include the Customer Name for sorting purpose
    2. The current attempt to sort by Customer Number is too far down to affect the sort, but again we are out of room and cannot move it higher

I know there is an Options= operator to bring in multiple options to get around the 10 item Filter limitation, but what options are available in this case where the Link= requirements chew up all available filters?

Thanks in advance for any ideas and/or suggestions.

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Matthew Wilson October 03, 2017 15:56

  Hello Gary,

  Take a look at the following knowledgebase article: Using more than 10 Filters in an NL() Function

  You can set up two columns exactly as you would see your filters appear in the JFX and then reference that column range in the "Filters=" filter.

  Best regards,

  Matthew Wilson

• 0
  
  Gary Winey October 04, 2017 21:42

  Hello Matthew,

  Thanks for the response. I am familiar with the Filters= option. However, my issue is not that I have too many filters, but that there are too many required links. To get from the Assembly Line table to the Customer table requires linking to and traversing 4 tables, 

  Assemly Line
  Assemble-to Order Link
  Sales Header
  Customer

  The Assemble-to Order Link table requires both Document No. & Document Type to link to either the Sales Header or the Assembly Line tables, depending upon which direction you are going. That is 6 out of the available 10 filter lines. If I start at the top with the Customer table, then I run out of room at the bottom and can't filter for Item number which is one of the requirements. Out of the 10 filter fields that Jet provides, 8 are used just for linking. There is no Linking= equivalent to Filters= is there?

  In the screenshot below, I started with the Customer table so I could sort by Customer name and filter by Customer No. As you can see, there is no room left to reference the Assembly Line item number for filtering. I believe I am stuck. Do you have any other ideas and/or suggestions?

  

   

• 0
  
  Harry Lewis October 06, 2017 14:18

  Hello Gary -

  Have you looked into using the NL("Link") function?

  By doing that and moving information out into other cells, you could free up some space in your filters.

• 0
  
  Gary Winey October 09, 2017 19:57

  Hello Harry,

  Thanks for pointing that link out to me. I will investigate that.