09-06-2013 07:48 AM
Is there a way in external autofills to have the query evaluate more than one "primary" value?
Example: Establish Account # based on Company # as Primary1 and Vendor # as Primary2?
09-06-2013 08:08 AM
Hi Bob,
My company uses a VB script with a CASE statement to allow for multiple types of lookups. We can pull information from either the member number or a social security number.
' CLng must be utilized to enable use in the Web Client
Select Case CLng(keysetDef.keysetID) ' Autofill Keyword Set #
Case 127 ' Accounts by Account #
txt = "exec summit.dbo.OnBase_Acct_Lookup '_primaryValue_', , S;"
strQuery = Replace(txt, "_primaryValue_", primaryValue)
Case 142 ' Accounts by SSN
txt = "exec summit.dbo.OnBase_SSN_Lookup '_primaryValue_', , S;" s
strQuery = Replace(txt, "_primaryValue_", primaryValue)
Case Else
Exit Sub
I hope this helps.
Dennis
09-06-2013 08:12 AM
I'm pretty sure there's an SCR out there for this functionality. I brought this up at Techquest many years ago and it has come up multiple times on the community as well.
09-09-2013 05:45 AM
Hi.
From the sounds of it you are looking for External Cascading Data Sets. At this time the functionality is not available, but has been requested in SCR: #88793. You can work with your first line of support to add your request to the enhancement.
Take care.
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.