how to bring record base on the max date

[idor_001]

hello,

I have 2 queries

in query 1 I have distinct item and other columns

in query 2 I have

item, planner , user login, transaction date ,type

the item  repeating because of the transaction date 

my goal is:

 bring the planner,uselogin from query 2 to base on  the max(transactiondate) foreach(item) where(type=1) to query 1

I already merge both query on item

tried: if max(transactiondate) foreach(item) where(type=1)= transactiondate foreach(item)

then planner +' '+user login else ''

and even bring the max transaction date to query 1

but i cant bring the planner and the userlogin to query 1 its show me empty or context error 

any help 🙏 

thank you