Skip to main content

Hi Team,

We have a requirement to fetch ItemSerialNumber linked to an Affected User. Using below query in form but getting error. Please help.

select Item.serialNumber from item as Item where (Item.product.productClass.shortCode='CELL' and Item.user.id = @*@$new.affectedUser.id@*@) 

Thanks,

Manish Verma

Can you explain where you want this value to be placed ? for example are you trying to use this value as a default value in some custom field ? or you want this value to be assigned into a task ?  

Reply


Terms & ConditionsCookie settings