dferreirazoppis
Curioso
I have two Query Subjects: TICKETS (with columns id_ticket and insertDate) and HOLIDAYS(with only one column: hDate).
I must create another column in query subject TICKETS: Holidays_count that counts the number of days of HOLIDAYS with HOLIDAYS.hDate > TICKETS.insertDate
Using SQL it could be:
select T.id_ticket,
T.insertDate,
(Select count(1) from HOLIDAYS H where H.hDate > T.insertDate) Holidays_count
from TICKETS T
I think I must use 'count' expression, but I don´t know how to apply the filter: H.hDate > T.insertDate in the FM Expression Editor.
Thanks in advance.
I must create another column in query subject TICKETS: Holidays_count that counts the number of days of HOLIDAYS with HOLIDAYS.hDate > TICKETS.insertDate
Using SQL it could be:
select T.id_ticket,
T.insertDate,
(Select count(1) from HOLIDAYS H where H.hDate > T.insertDate) Holidays_count
from TICKETS T
I think I must use 'count' expression, but I don´t know how to apply the filter: H.hDate > T.insertDate in the FM Expression Editor.
Thanks in advance.