LF Cloud Queries Using SQL Unique Identifiers
The ID field for the vendors table is a SQL Unique Identifier field, which I need to use as an Input Parameter from workflow. However when I test the query in the Cloud Query Builder using an ID like this:
Does Forms, in Cloud , allow for lookup rules to come from Data Sources or Queries which are based on On Prem SQL server data using LF Agents? I have setup my Data Sources and Queries but they do not show up in Lookup Rules in Forms Designer.
SQL Data Type Uniqueidentifier
I use 10.2.0.216 and when doing a query to a SQL database, any field that is data type uniqueidentifier is not available to me after the query is run. What I am trying to do is run a query on a table that finds all records. Use those results and use 1 field (the uniqueidentifier fields) to find matching records in a different table.
Can someone point me in the right direction to use SQL with my table? I can also create a new database and connect to that data source if the lookup table doesn't accept SQL , but then how do I activate that query whenever the form gets filled with the Employee ID? Any videos or suggestion would be appreciated, as I am a beginner with LF .
SQL query on LF Server tables for specific metadata
I would like to query the LF Server's SQL database tables to get a list of all EmpNum and their TerminationDate. I would like to avoid using Workflow for this, since there are tens of thousands of documents and looping them all through a For Each Entry to look at the TerminationDate would take multiple hours of time.
Questions about Okta SSO Hi All, We are currently trying to implement SSO using Okta for our Laserfiche cloud ac...
Overview of Lf Cloud Queries Using Sql Unique Identifiers Laserfiche Answers
This page summarizes the current Ready for review SQL -example queue from the private Laserfiche Answers research output. It intentionally stores source links, schema-match notes, and public-safe review decisions instead of copying raw forum SQL .
Custom Queries In the Input step of processes that connect to outside data sources, you can create custom SQL queries . Custom queries should be used when you want to do something that is not supported by the main user interface. You can use it to sort your results, choose randomly from them, or even append them together into one string so they all get combined (later to be turned into a multi ...
Key Details About Lf Cloud Queries Using Sql Unique Identifiers Laserfiche Answers
LookupTables Command Line Utility CLI to interact with Laserfiche Lookup Tables. User Documentation
Under Query Options in the Properties Pane, select the Specify a custom timeout check box and specify the desired timeout value in seconds. Add a Custom Query, Insert Data, Query Data, or Update Data activity to your workflow definition by dragging it from the Toolbox Pane and dropping it in the Designer Pane.