Setting filter range from record

Lefteyed
Lefteyed Member Posts: 43
in NAV/Navision Classic Client
Is it possible to set filter from a record with several entries?

Table A:
"No.", "Name", "Location"

Table B:
"No.", "Company", "Table A No."
Table A - Data:
1, One, Mibuso
2, Two, StackOverflow
3, Three, Mibuso

Table B - Data:
10, Comp A, 1
20, Comp B, 3
30, Comp C, 2
40, Comp D, 3

Then I would filter Table A, so that I have the ones I need.
TableA.SETFILTER("Location", "Mibuso");

Then something like this:?
TableB.SETFILTER("Table A No.", TableA."No.");

So that I end up with
10, Comp A, 1
20, Comp B, 3
40, Comp D, 3

Cheers
/left

Best Answer

Answers

  • Lefteyed
    Lefteyed Member Posts: 43
    edited 2016-06-01
    That will allow me to do something with the data in your section?:
    Here you will have all your 3 records

    I want the range to be set .. not one by one, but almost an smart way to set the whole filter at ones.

    Your way, I might set a local var as Text (FilterText)

    And then do this:
    REPEAT
  IF FilterText = '' THEN
    FilterText := TableA."No."
  ELSE
    FilterText += '|' + TableA."No.";
UNTIL TableA.Next=0;

    And then set it as filter: 
    TableB.SETFILTER("Table A No.", '%1', FilterText);
  • Lefteyed
    Lefteyed Member Posts: 43
    @RockWithNAV You helped me in the right direction, so many thanks :smile:

Categories