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

Question

Question

Build Weblink URL inside SQL query

WebLink
Updated January 8, 2016
asked on January 7, 2016

Hi all,

This might not be the best forum to ask this question on, but essentially I want to write a SQL query which will return things like supplier name and invoice number (as well as other things) and then generate a URL based specifically off of the supplier name and invoice number. The variables would be used to generate the URL of a customer Laserfiche search... Has anyone done anything like this before and if so, could you help? I'm pretty strong in SQL but doing something like this would be new to me.

 

Thanks!

0 0

Replies

replied on January 8, 2016

Sure, that's possible, you'd just have to append the static parts of the URL to your column values in the SQL query. See the WebLink help file for the URL syntax and encoding. The search queries are document in the Laserfiche Client help file.

The easiest way to generate the search syntax is through the Laserfiche Client. Open the search pane, add the criteria you want and then open the Advanced Search Syntax pane. When you run the search, the search query will be displayed for you in the Advanced Search Syntax pane.

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

Sign in to reply to this post.

Details
Related Posts
Loading ...