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

Question

Question

how can I run a stored procedure in dynamic Fields?

Laserfiche
Updated July 15, 2015
asked on July 10, 2015 • Show version history

Hi,

Laserfiche permits make a relation between a table in SQL and  dynamic fields but, how can I  make a relation in sql  Stored procedure and dynamic fields??

 

Thanks!!!

 

 

 

 

0 0

Answer

SELECTED ANSWER
replied on July 13, 2015

Hi David,

 

I think I understand your question...

Create your stored procedure and then insert the SP name in the SPName column in the Laserfiche table database - DBO. Propdef which matches the field you want to populate.

(Note - You will need to re-start your Laserfiche Server Service for this to apply the changes)

 

Cheers! yes

2 0
View 1 previous reply
replied on July 13, 2015

Son of gun, Chris. That works! The SP values are also available in the search screen.

Laserfiche, what's the level of official support for this solution?

0 0
replied on July 13, 2015 • Show version history

Hey Ben!

 

Official Response from LF is that it isn't supported from my past encounters. This was the only way to integrate before LF 8.3 and dynamic fields. Nowadays you are supposed to use dynamic fields/external tables pointing at a SQL view that you have manipulated from a table to whatever you want it to be beforehand. yes

0 0
replied on July 13, 2015

This is a supported setup for dynamic fields (though Laserfiche will not debug the stored procedure itself if support cases are raised).

0 0
replied on July 15, 2015

Ah! Interesting. Good to know. Thanks Miruna!

 

0 0

Replies

You are not allowed to reply in this post.
replied on July 11, 2015

Hi David,

I don't believe this is supported. I tried a basic stored procedure; Forms can access it OK but not External Tables in Admin Console. It's possible a complex View could deliver what you need. Can you describe the dataset and expected results?

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE LaserLookUp 
AS
BEGIN
	SET NOCOUNT ON;
	SELECT 'Value1' as Col1,'Value2' as Col2,'Value3' as Col3
END
GO

 

You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...