We had a requirement from our client, they were processing client forms and at a certain moment they had to process a VIP client. The form was already scanned and archived, the verificator didn't have any idea of its batch, we couldn't find it on time.
So I came up with an ugly semi-solution, in the batch item table there is a column called item data which stores certain information of the batch item in hexadecimal. Within this column, I found the field values, so my solution was to look into this field and search for the value I was looking for and found it.
Sadly this approach just gives me the batch name which contains the document which has that value.
The attached image shows that I was looking for a document which had the value 145225 in a certain field. This gives me the batch name, so our user now can search the batch and process it.
Is there a better way to search for documents within flexicapture ?
Thanks for your help