Is there an easy way to see if a service order has been signed by the customer? AFAIK the SA must tick off a box to indicated that signature could not be obtained. And if the order is signed, the signature is stored as a document on the order. But is there a field on the order itself that indicates whether it’s been signed or not? Our service managers would like to know without too much poking around
Solved
Order signed by Customer? V15
+12Best answer by Phil Seifert
Hi Bjørn,
Unfortunately there is not a column in the database which would indicate a signature has been obtained. I am sure you are aware that signatures are uploaded as an attachment against the order so just clicking on the attachment icon should indicate whether a signature was obtained.
But a specific field/column indicating the status of a signature does not exist. Sorry.
+24Hi Bjørn,
Unfortunately there is not a column in the database which would indicate a signature has been obtained. I am sure you are aware that signatures are uploaded as an attachment against the order so just clicking on the attachment icon should indicate whether a signature was obtained.
But a specific field/column indicating the status of a signature does not exist. Sorry.
+12Thanks Phil, that was I reconed. Thanks for confirming.
+12Quick followup - we record the reason why a signature was not available. Is that stored anywhere?
+24In response to your follow up question, yes there is a field that is updated when the customer was not able to sign the work order. This information is stored in the order_changes_log (a part of the v15 & higher transaction logs) and can be retrieved with a query like the following:
SELECT unique_id,
order_id,
bpart_id,
comment_text,
creation_datetime,
created_by
FROM order_changes_log with(nolock)
WHERE order_id = 'SV2202060001@@1'
AND bpart_id = 'signature_unavailable';
The comment_text would contain what the field engineer inserted as the reason.
I should also clarify a little more for the original question, as you know the signature is upload as an attachment. There is NOT a dedicated field for indicating the presence of the signature but if you were looking to capture a query to see if there was an attachment, this is possible.
SELECT ap_attachment_id,
ap_table_key,
ap_user_login,
ap_creation_time,
ap_description,
ap_file_name
FROM ap_attachments WITH(NOLOCK)
WHERE ap_table_key = 'SV2202060002@@1'
AND ap_description LIKE 'Signed by:%';
However, there is nothing in the UI itself to indicate the presence of the signature other than the attachment.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.