Do offline forms tables work when the Form is using multiple stored procedures to load fields with data?
Hi Chase,
My apologies for the delayed response. Unfortunately, lookups running stored procedures are not supported for offline forms.
Regards,
Zair Naim
Any update on this feature? I would like to be able to use stored procedures offline. If not, can it possibly be in a future release?
LF DS is version: 10.2.0.210 and shown in the video, mobile is licensed as version 10.2.1.751
I am using Lookups running Stored Procedures within SQL on my Form.
Is it possible to run Offline Forms if there are Stored Procedures being called for a Drop Down?
I have made sure to add all tables used and referenced within all Lookups to the Offline Tables within Forms. But there is no location to reference SQL Stored Procedures used.
When opening Laserfiche Mobile, I go to the specific form and Update Related Offline Tables. It runs successfully.
Where trying to fill out form, it does not run the Stored Procedure to fill out the Drop Down. Please see Attached file: "Mobile Form Test"
Also attached is the SQL Lookup for the Drop Down being populated with data from SQL.
Here is the SQL Stored Procedure Query:
ALTER PROCEDURE [dbo].[Get_JobInfo_By_ClientID]
--Get_JobInfo_By_ClientID '5001'
@ClientID bigint
AS
BEGIN
Select recnum,jobnme from [Site Services].dbo.actrec
Where clnnum=@ClientID and status IN (1,3,4) order by jobnme asc
END
I also want to note this is successful when using the Online Form.