Extension : filter using today date

Hi,

 

I would like to add a new extension on session tcibd0501m000 which can retrieve the last active revision code from table tiedm100 at the current date.

If I add a new calculated field defined as a function, it works well but the field cannot be filtered from LN UI.

If  I add a new calculated field which is defined as a "nested selection", I connot retrieve the revision code.

 

 

The text of the query is :

select tiedm100.revi
from tiedm100
where tiedm100.eitm = tcibd001.item
and tidem100.indt <= CURRENT_TIMESTAMP
and (tiedm100.exdt >= CURRENT_TIMESTAMP or tiedm100.exdt = 0)

Do you have any idea hoiw to solve this issue?

Best regards.