You are viewing limited content. For full access, please sign in.

Question

Question

Connector error searching field with dash in value

Laserfiche Connector Search and Retrieval
Updated April 6, 2017
asked on April 5, 2017

Hi,

 

Using LF Connector 10.2 to search for invoice number in LF

Source data is from Navision using the following query in profile XML.

<Attribute name="LFQuery" value="{[]:[Vendor Name]=*%(CustNum)}" />

LF Connector behaves as shown in images;

 

 

When numbers contain a dash the search error occurs.

 

Can you please advise if this is a bug or can be corrected with alternate LFQuery syntax?

 

many thanks

Warren Cook

 

 

 

 

 

 

0 0

Answer

SELECTED ANSWER
replied on April 6, 2017

Hi,

Have compared to other connector profile syntax and found the " is not supported within the query string.

Instead " needs to be substituted by &quot;

The working query looks as follows

<Attribute name="LFQuery" value="{[]:[Vendor Name]=&quot;*%(CustNum)&quot;}" />

 

Many thanks for your guidance.

1 0

Replies

replied on April 5, 2017

Hi Warren, try to use quotes to surround *%(CustNum), that is, {[]:[Vendor Name]="*%(CustNum)"}

0 0
replied on April 6, 2017

Hi,

Many thanks for your reply.

Is the query line below in the format you suggest?

<Attribute name="LFQuery" value="{[]:[Vendor Name]="*%(CustNum)"}" />

 

After saving the change the Configuration panel displays Invalid XML as shown in the image below.

I must have made a mistake with the quotes position.

Could you please provide the correct query syntax.

 

many thanks

Warren Cook

 

 

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...