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.revifrom tiedm100where tiedm100.eitm = tcibd001.item and tidem100.indt <= CURRENT_TIMESTAMPand (tiedm100.exdt >= CURRENT_TIMESTAMP or tiedm100.exdt = 0)
Do you have any idea hoiw to solve this issue?