How can I set a Filter

Rom

Hello,

I' am new here and I work with Nav since Nov 3rd 08. So don't be so hard to me, if i ask stupid question :oops:

My first question.

I can i set in table/form this standard search function, normally activate with the key F7. I tried to search it in the forum, but i really don't know, which keywords i should have to use. I tried with search filter table form and so on.

Could sb. help me.

Thanks in advance

Best regards
ROM

DaveT

Hi Rom,

Welcome to Mibuso

If you are looking to rhe C/AL command it is the SETFILTER command.

As you are starting out, I would recommend that you read the application developer guide in the Doc directory of the Nav CD/DVD (w1w1adg.pdf).
Also the help in the C/Side reference guide is good.
Finally have a look at the standard code for examples.

DaveT

Hi Rom,

Sorry should have said - use the search function on Mibuso - (Sorry Luc, should be the first advice )

Rom

hi,

thanks for the warm welcome.

Maybe it is not clear, what i mean with search funktion. Normally u can set the courser in a form on a field and if u press the [KEY F7] it open a search window, where u can look for records. In one of my forms it doesn't work. The form is tabullary type form.


Please help me. Its nearly christmas

DaveT

Hi,

Strange - could you check :

Does the button work on the top menu for the filter?

Check the Help -> Overview on function keys and see what F7 is mapped to

Rom

Sorry,

at moment, i don't know, what u mean! :oops:

Rom

i've notice, that in the first field of this form, the F7 key works.

Field No. , it should be the prim. key.

but at Employeename, it doesn't work.

Tomas

Rom wrote:

hi,

thanks for the warm welcome.

Maybe it is not clear, what i mean with search funktion. Normally u can set the courser in a form on a field and if u press the [KEY F7] it open a search window, where u can look for records. In one of my forms it doesn't work. The form is tabullary type form.


Please help me. Its nearly christmas

It is not search that you are talking about - it is filtering.
In Navision click Help -> Microsoft Dynamics Help. On Index tab, enter filter. First article will be Entering Criteria in Filter where you will find more or less all information you need about filtering.

DaveT

Hi Rom,

Now I see what the problem is. The first column is based on a field on the table so you can search, the second column is based on a variable filled at run time (by doing a lookup the master table). You cannot filter on field that are not on the table.

Rom

@ Tomas, thanks.


it seems to be, that is it no problem. I guess, that this is a combination of 2 other fields and if i learned it right, i can't filter it with F7.

Thanks for help

Rom

@ DaveT: It should be, that we have the same idea. But u explained it better.

Thanks a lot.

DaveT

Glad to Help