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

RSA_Tech

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,

pavithrap0992

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

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

pavithrap0992

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

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

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

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

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.

RSA_Tech

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!