Question

Fetch ItemSerialNumber in a Field of Form

  • 8 December 2023
  • 1 reply
  • 48 views
M
Rank
Userlevel 2
Badge +7

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

1 reply

R
Rank
Badge +1

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