[Solved] How to enable 'set as default filter column' (screenshot)

RSA_Tech
RSA_Tech Member Posts: 65
edited 2016-11-29 in NAV Three Tier
Hey all,

NAV 2013 R2
I've got a user stating that this 'Ship-to Code' drop down used to allow her to filter the drop down and use the 'set as default filter column' option.

Can that option be enabled on any drop down? If so can you throw me in the right direction?

There's normally a little blue filter symbol on one of the available columns but it's not there for this drop down.

Gracias,

e.png 179.1K

Best Answers

  • pavithrap0992
    pavithrap0992 Member Posts: 21
    Answer ✓
    I don' think Ship-to Code drop down has allowed her to change the default filter using the 'Set as default filter column' because the records come from a different table (222) that is already filtered with the customer no. It is possible to change the default filter in the Sell-to customer no. or Bill-to customer no. field.
  • Kishorm
    Kishorm Member Posts: 921
    Answer ✓
    Create a key on the field you want to filter on - then you will be able to click on that column to sort by it and then the 'set as default filter column' option will become enabled

Answers

  • pavithrap0992
    pavithrap0992 Member Posts: 21
    Answer ✓
    I don' think Ship-to Code drop down has allowed her to change the default filter using the 'Set as default filter column' because the records come from a different table (222) that is already filtered with the customer no. It is possible to change the default filter in the Sell-to customer no. or Bill-to customer no. field.
  • Kishorm
    Kishorm Member Posts: 921
    Answer ✓
    Create a key on the field you want to filter on - then you will be able to click on that column to sort by it and then the 'set as default filter column' option will become enabled
  • RSA_Tech
    RSA_Tech Member Posts: 65
    Kishorm wrote: »
    Create a key on the field you want to filter on - then you will be able to click on that column to sort by it and then the 'set as default filter column' option will become enabled

    I'm having difficulty now tracking down the right table\field to add that filter to.

    There are 31 different tables that have the 'Ship-To' field.
  • RSA_Tech
    RSA_Tech Member Posts: 65
    pavithrap0992 wrote: »
    I don' think Ship-to Code drop down has allowed her to change the default filter using the 'Set as default filter column' because the records come from a different table (222) that is already filtered with the customer no. It is possible to change the default filter in the Sell-to customer no. or Bill-to customer no. field.

    May I ask how you found out that table 222 feeds that drop down?
  • RSA_Tech
    RSA_Tech Member Posts: 65
    edited 2016-11-21
    Here's a screen of my current field list for table 222

    I looked at the table in SQL and saw that it has a primary key on Customer No_ and Code.

    e.png 31.5K
  • RSA_Tech
    RSA_Tech Member Posts: 65
    Solved

    Went to table 222 and added key's on the fields the user wanted to filter by.

    I added three keys. One for Name, one for Code and one for Zip code.

    Thank you all!

    e.png 31.5K

Categories