MarkView All Components - Determine WorkItem Instance ID for a given Document ID

Applies To

• ERP System: All
• MarkView Version: All

How to Determine WorkItem Instance ID

Query the sf_workitem_property_values_v view as follows, replacing &DocID with the actual Document ID:

select wpv.workitem_instance_id
from sf_workitem_property_values_v wpv
where wpv.property_name = 'MVDocumentID'
and wpv.property_value = '&DocID';