What is the syntax to search for duplicates within, lets say the invoice number, field?
One way of doing this would be to use wildcard (*) to search for that field invoice number.
for example if invoice number is 12345 and in the field if i understood correctly it is 1234512345
you could search
for [general]:[invoice]="12345*"
That would just be for a certain invoice number though. I would like to see all duplicates in that field.
Oh i see. Basically what you are saying is that you would like to see all the invoices with same invoice number?
or you are saying that one invoice number could be in a field for one file multiple times. in that case. how long is the invoice number?
In either case, We could use workflow to weed out those with duplicates using regular expressions.
Yes! To seeing all invoices with the same number.
something like this might be a good place to start
In the end you would have a folder with shortcuts of all invoice with duplicate invoice number
I'm sorry I'm still a bit lost on how to apply these filters. I'm using client 8
Hi Jason,
There isn't a direct way to do this search directly through the Laserfiche Client. Junaid's suggestion above is to write a small script in Laserfiche Workflow to do this instead. It's a bit more complicated than just a single search string, but should be able to get you what you need. Note that I checked your listing and you do have Workflow.
Oh okay. I've searched all the files and folders and cant find Workflow. Tried to download it from the site too and couldn't find the proper download.
Hi Jason,
Workflow is a separate program that connects to your repository to make modifications. You won't find it in the repository.
Your VAR should be able to help you with installation and setting it up for your use.
It's part of the Laserfiche Avante download package.