[WebDesigner] Filter on candidate Objects using logged user in the request

Question

Hello, 
 I am trying to use a function inside the Filter on candidate Objects on a table property in a Component in the Web Designer , and I am getting a SyntaxError 
 This is my non working filter: 
 "UID_Department IN (SELECT UID_Department FROM Department WHERE (CustomProperty01 = '06' and 
(CCC_AE IN (SELECT UID_AERole FROM PersonInAERole WHERE UID_Person = GetUser() ))))" 
 Could you please advise on how to get the logged user UID_Person inside this request 
 PS: the filter below is working if I replace GetUser() by a uid 
 "UID_Department IN (SELECT UID_Department FROM Department WHERE (CustomProperty01 = '06' and 
(CCC_AE IN (SELECT UID_AERole FROM PersonInAERole WHERE UID_Person = 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxx' ))))" 
 Regards,

walid tfaili · Accepted Answer

I found the correct syntax: 
 
 format("UID_Department IN (SELECT UID_Department FROM Department WHERE (CustomProperty01 = '06' and 
(CCC_AE IN (SELECT UID_AERole FROM PersonInAERole WHERE UID_Person = '{0}'))
))", getuser())

[WebDesigner] Filter on candidate Objects using logged user in the request

Top Replies