Hi Zhu. Thank you for taking the time answer - I appreciate it. I think I can perform a workaround: the Record Link "Description" field can be filtered on "Sales Order - " - I can then pull out the sales orders from that. The RecordID field precedes note-specific entries with '24000000' (if I convert the RecordID to Varchar first). I can convert & decompress the Note field ~mostly~ cleanly using this:
CONVERT(
varchar(max)
, DECOMPRESS(
CONVERT(varbinary(max), 0x1F8B0800000000000400)
+
CONVERT(varbinary(max), SUBSTRING([Note],5,8000))
)
)
That gives me what I need for this user; if I need to pull more information from the Sales Order, I can use the Sales Order # pulled from the Description field.
