Connector help

asked on March 20, 2019 • Show version history

I have a search that is being built with connector and they search by address in 2 fields – street name and street number. I have the search working perfectly for street name, but when I add in the street number, I get no results. (I’ve picked an address from BS&A that has documents in Laserfiche). I believe the problem is the way BS&A lists the street numbers. The number is always followed by “ .0 “ which I believe LF just reads as 0, but I’m not sure how to add that to my token value. I have tried adding the ".0" after the bracket, after the close ")" as well. No luck.

This is the syntax that I am using:

{[BUILDING]:[Street Name]="%(Street Name)"}

{[BUILDING]:[Street Number]="%(Street Number)"}

Please advise!

0 0

SELECTED ANSWER

replied on March 20, 2019

The issue is that the third party application stores the street number value like "11009.0" and the request is to have Laserfiche Connector retrieve the value, but leave off the ".0" and then just search in Laserfiche using "11009". This can be accomplished by just using a regular expression on the %(Street Number) token to extract the value before the decimal. Also note that the above search syntax isn't technically valid. You can use something like

{[BUILDING]:[Street Name]="%(Street Name)", [Street Number]="%(Street Number;#<\d*>#)"}

1 0

replied on March 20, 2019

Worked like a charm Alex. Thanks again for the help earlier!

0 0

Question

Question

Answer

Replies

Sign in to reply to this post.