@Maximus: put on your glasses 1 filter is with "No.", the other with "Name".
@sabzam:
You can't do it in one run.
You need to put the first filter and loop the the records, putting them in a temptable. Then you put the second filter and you loop the records and add them to the temptable.
After that, you loop the temptable with filtering and you have all records.
It is also possible to use MARKS, but for performance-reasons (specially on SQL) it is better to avoid MARKS.
Regards,Alain Krikilion No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Sorry Maximus its not that simply. You have two options here that I can think of. One is to have two record variables and filter down both. Then insert into a third temp record variable.
The second suggestion is to add a field which combines No. and name and filter on the new field as Maximus suggests
Let's put it in another way. Is it possible to compare a table with a temporary table. Practically if I have got records no. 2, 3 and 7 in a temporary table, I want to have filtered these records in the actual (real) table.
IN SQL this would be something like
Select [No_] from [Customer] where [No_] in (Select [No_] from Vendor)
You would to code this with MARK and select MARKEDONLY which can be slow. If your temp table is on the customer table then you can select directly from the temp. table.
Comments
@sabzam:
You can't do it in one run.
You need to put the first filter and loop the the records, putting them in a temptable. Then you put the second filter and you loop the records and add them to the temptable.
After that, you loop the temptable with filtering and you have all records.
It is also possible to use MARKS, but for performance-reasons (specially on SQL) it is better to avoid MARKS.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Sorry Maximus its not that simply. You have two options here that I can think of. One is to have two record variables and filter down both. Then insert into a third temp record variable.
The second suggestion is to add a field which combines No. and name and filter on the new field as Maximus suggests
Dynamics Nav Add-ons
http://www.simplydynamics.ie/Addons.html
IN SQL this would be something like
Select [No_] from [Customer] where [No_] in (Select [No_] from Vendor)
You would to code this with MARK and select MARKEDONLY which can be slow. If your temp table is on the customer table then you can select directly from the temp. table.
Dynamics Nav Add-ons
http://www.simplydynamics.ie/Addons.html