jojovalenton
9th August 2016, 08:08
hi,

i am trying to filter session before.program per specific user but system don't recognized the filter and loaded the session empty. both grid fields with same domain tcemm.grid. thanks for help in advance.

before.program:
user.name=logname$
query.extend.where(" tfnpc170.grid in " &
"(select tfnpc173.grid from tfnpc173 where :tfnpc173.user= '" & user.name & "') ")

regards,
jojo

JaapJD
9th August 2016, 09:45
Remove the colon before tfnpc173.user.

jojovalenton
9th August 2016, 15:23
hi jaap,

thanks for reply, i removed the colon and it was ok.

regards,
jojo