Here is my simplyfied query: Select T.id as WOId, T.custbody_atlas_assy_desc as assy,
From Transaction as T Where BUILTIN.DF(T.Type) = 'Work Order' and BUILTIN.DF(T.TranID) = 'WO7-2217'
And here is the query result:
[
{
"woid": 233891,
"assy": "ASSY., SERV, N, 62, 1, 50, 62, 1, 50, 132, 7 (PH4/FORD/DTM/7K/WL)"
}
]
And here is the screen shot of the WO showing a different value for the Assembly: