Question

Real Time Lookup issue

Version 9 Quick Fields Search and Retrieval Capture Business Processes

Updated April 7, 2014

asked on April 4, 2014

Good Afternoon All,

Issues: RTL data is not populating fields in the Quick Fields Template.

I am also getting an error "Error converting data type nvarchar to float" when looking up data in RTL via either the Lookup object or the RTL under the Class.

Working:

I've set up my SQL session and tested functionality. I return 30 rows affected by a search on a client name.

I have set up Zones and Pattern Matching. They return values as desired.

What I've tried, What happens for me:

I've tried adding a Lookup module and assigning the variables from lookup to the fields in the template, no results fill in.

The Fields in the template have the RTL symbol over top of them like they should.

I've set the field "client" equal to the SQL table object "casenmbr"

Basically This QF session should be looking at the page, IDing it and then grabbing the SS#, Review number, and Case number. It should then use the case number to look up the Case # in RTL / SQL and populate the first middle and last names.

Result is failure with errors and such as shown above,

Any suggestions on what I may be over looking ?

Regards,

Brian

Answer

APPROVED ANSWER

replied on April 7, 2014

The issue in this situation was that Real Time Lookup was configured to take the value of a Laserfiche text field and compare it against values from a SQL column of type float. The data types need to be similar in order for them to be compared against each other.

Replies

replied on April 4, 2014

Please open a case with Laserfiche Support so the matter can be looked into further. Please provide your Quick Fields session, a briefcase of a test document with the template being used, as well as a copy of the external data source that you're doing the lookup with.

You are not allowed to follow up in this post.