Hey,

I will create an overview session with the last revision per engineering item with status approve for production. I made an overview session with main table tiedm100 (revision table) and built an query extension for the status. That's very simple but now I have yet diferent entries for 1 eitem. Is it possible to select only the effective revision per item with the query extension statements??

Veerle

It is possible. You can create a subquery inside "query.extension". With this subquery you can filter records not desired. But if you have a large number of records in table, perhaps this is not a good solution :( .



Paco

I think in this case u need to combine skip.io in the main.table.io/after.read section .

Query extension is best suited for static conditions well known before program starts. Query extension is definitely faster then skip.io for large tables . Skip.io can be used in cases where skip conditions are based on dynamic values (e.g. Previous rec values) and can not be defined in before.program section.

hey,

thanks for the hints!

But I've already decided to work with a extra new table because the questions of the endusers becomes yet more complex, there are also reports required over a multicompany environment ..

Bye, Veerle