Hi @SinghK , I go to DataLab > Lookups > New Lookups, Step 1: Set Reference Search with time range : results as expected Step 2: Set Lookup SQL: results as expected Step 3: Field Mapping: - Search Fields Match Table Columns (case sensitive) - Lookup Fields: Table columns chosen Preview Results: (...) | dbxlookup connection="Pro_DB" query="SELECT TOP(1000) [SID] ,
[LogTime] ,
[DocID]
FROM [Storage].[dbo].[DocStates]
ORDER BY [LogTime] DESC" "SID" AS "SID" OUTPUT "LogTime" AS "Log_Time", "DocID" AS "Doc_ID" Then I clicked on "Open In Search", only the SPL query returns result, but the dbxlookup fields are all blank. Tks Louis
... View more