Question

creating field with numeric data minimum and maximum

Laserfiche

Updated March 3, 2015

asked on March 3, 2015

Hello,

I'm hoping for some help with creating a field to use with a template. I'm trying to find out how I can search for a numeric number within a certain group of numbers. Let me try to explain

We have a field titled "permit numbers" . this is a required field. I put in the beginning number of the permit A and the ending number of permit Z ( e.x. 978202 to 979305). The range varies depending on how many permits are purchased. I want to be able to search for a permit number between 978202 and 979305 to see who that permit was assigned to instead of just the beginning and ending numbers. If anyone can assist me by telling me if this is even possible and also on where I can find directions, I would greatly appreciate it!

Thanks so much

1 0

Replies

replied on March 3, 2015

If it is a number field, you can use advanced search syntax to search on a range, like this:

{[]:[PermitNumber]>="987202", <="979305"}

This page has more information on advanced search syntax for fields: http://www.laserfiche.com/support/webhelp/Laserfiche/9.2/en-US/UserGuide/Laserfiche_Client.htm#Search/Advanced/Template_Field.htm

1 0

replied on March 3, 2015

Tracie is it a number field or text field?

To use the UI, if you want to search for permits between 978202 and 979305, search on 97[8-9][2-3][0][0-9], this says the number should start with 97, and specifies the digits that can be used for the thousands, hundreds, tens, and ones.

If it is a text field I think you would need to use the advanced search via syntax.

John

0 0

replied on March 3, 2015

John,

This is strictly a number field. Thanks for the information. The format that you showed me, could I put that in the "field" set up option? I may be looking for one specific permit. what I would like to do is enter that one permit number in the search field and have the file come up to whom that permit was issued to. The customer may have a whole stack of permits from 1-500. If I want to see who purchased permit 395, it should fall into that category.

Thank you for the information. I'm already trying it!

0 0

replied on March 3, 2015 • Show version history

It sounds like you are asking for help in designing a field knowing that you will have to perform specific searches on it, rather than trying to search on an existing field.

Is this correct? I think both the current answers are providing information on how to search an existing field.

0 0

You are not allowed to follow up in this post.

Question

Question

creating field with numeric data minimum and maximum

Replies

Sign in to reply to this post.