Hi,
I have the problem of :
Formula.Firewall: Query 'Gunduz' (step 'Source') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
Although similar worked in another query, this time it didn't work this time. Any ideas ?
I have the problem of :
Formula.Firewall: Query 'Gunduz' (step 'Source') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
Although similar worked in another query, this time it didn't work this time. Any ideas ?
Code:
let
param1 = IlkTarih,
ilktarih = param1 {0} [Ilk Tarih],
param2 = SonTarih,
sontarih = param2 {0} [Son Tarih],
dbQuery = " SELECT #(lf)#(tab) pg.pgrpName1#(tab)#(tab)#(tab) [Santiye],#(lf)#(tab) p.prsncode [Sicil No],#(lf) p.[prsnname1] [Adi],#(lf) p.[prsnname2] [Soyadi],#(lf) CLT.clntName1#(tab)#(tab) [Firmasi],#(lf) fg3.grp3Name1#(tab)#(tab) [Gorevi],#(lf) prf.pcntrName1#(tab)#(tab) [Ekibi],#(lf) lnk11.lgrp11Name1#(tab) [Kaldigi Yer],#(lf) lnk12.lgrp12Name1 +' - '+lnk12.lgrp12Name2 [Kamp/Adres],#(lf) lnk13.lgrp13Name1#(tab) [Oda No],#(lf) t.[iotransactiondate] [Giris/Cikis Tarihi/Saati],#(lf) prsnEText4 [Vardiya],#(lf) tz.tzoneName1 [GECE/GUNDUZ],#(lf) --ps.psStartDate,#(lf) --ps.psFinishDate,#(lf) [Giris/Cikis] = ( CASE#(lf) WHEN [iostatus] = 0 THEN 'Giris'#(lf) WHEN [iostatus] = 1 THEN 'Cikis'#(lf) ELSE 'Uzaya Gitti'#(lf) END )#(lf)FROM [Exen].[dbo].[IOTransaction] t#(lf) LEFT JOIN dbo.person p#(lf) ON t.ioPrsnRefId = p.prsnRefId#(lf) LEFT JOIN dbo.PersonShift ps#(lf)#(tab)#(tab)#(tab) ON ps.psPrsnRefId = p.prsnRefId#(lf)#(tab) LEFT JOIN dbo.TimeZoneMess tz#(lf)#(tab)#(tab)#(tab) ON tz.tzoneRefId = ps.psTzoneRefId#(lf)#(tab) LEFT JOIN dbo.[PersonGroup] pg#(lf)#(tab)#(tab)#(tab) ON pg.pgrpRefId = p.prsnPgrpRefId#(tab)#(lf)#(tab) LEFT JOIN FreeGroup3 fg3#(lf)#(tab)#(tab)#(tab) ON fg3.grp3RefId = p.prsnGrp3RefId#(lf)#(tab) left join Client CLT#(lf)#(tab)#(tab)#(tab) ON CLT.clntRefId = P.prsnClntRefId#(lf)#(tab) LEFT JOIN [ProfitCenter] prf#(lf)#(tab)#(tab)#(tab) ON prf.pcntrRefId = p.prsnPcntrRefId#(tab)#(lf)#(tab) LEFT JOIN LinkedGroup11 lnk11#(lf)#(tab)#(tab)#(tab) ON lnk11.lgrp11RefId = p.prsnLgrp11RefId#(tab)#(lf)#(tab) LEFT JOIN LinkedGroup12 lnk12#(lf)#(tab)#(tab)#(tab) ON lnk12.lgrp12RefId = p.prsnLgrp12RefId#(tab)#(lf)#(tab) LEFT JOIN LinkedGroup13 lnk13#(lf)#(tab)#(tab)#(tab) ON lnk13.lgrp13RefId = p.prsnLgrp13RefId#(tab)#(tab) #(lf)#(tab)#(tab)#(tab) #(lf)#(tab)#(tab)#(tab) #(tab) #(tab) #(tab)#(lf)WHERE ( t.[iotransactiondate] = (SELECT Min(m.[ioTransactionDate])#(lf) FROM IOTransaction m#(lf) WHERE m.ioPrsnRefId = t.ioPrsnRefId#(lf) AND Cast(m.[iotransactiondate] AS DATE)#(lf) = Cast#(lf) (#(lf) t.[iotransactiondate] AS DATE)#(lf) GROUP BY m.ioPrsnRefId)#(lf) OR t.[iotransactiondate] = (SELECT Max(m.[iotransactiondate])#(lf) FROM IOTransaction m#(lf) WHERE m.ioPrsnRefId = t.ioPrsnRefId#(lf) AND Cast(m.[iotransactiondate] AS#(lf) DATE) =#(lf) Cast(#(lf) t.[iotransactiondate] AS DATE)#(lf) GROUP BY m.ioPrsnRefId) )#(lf) AND p.[prsnname1] IS NOT NULL#(lf) AND iotransactiondate > '01.12.2016 00:00:00.000'#(lf) AND ps.psStartDate <= t.[iotransactiondate]#(lf) AND ps.psFinishDate > t.[iotransactiondate] #(lf) --and p.[prsnname1] ='NAIM'#(lf) AND tz.tzoneRefId =4#(lf) AND iotransactiondate >= '" & ilktarih & "'#(lf) AND iotransactiondate <= '" & sontarih & "'#(lf)GROUP BY pg.pgrpName1#(tab),#(lf)#(tab)#(tab) t.ioPrsnRefId,#(lf) prsncode,#(lf) prsnname1,#(lf) prsnname2,#(lf) t.[iotransactiondate],#(lf) iostatus,#(lf) tz.tzoneName1,#(lf) ps.psStartDate,#(lf) ps.psFinishDate,#(lf) prsnEText4,#(lf) fg3.grp3Name1,#(lf) CLT.clntName1,#(lf) prf.pcntrName1,#(lf) lgrp11Name1,#(lf) lgrp12Name1,#(lf) lgrp12Name2,#(lf) lgrp13Name1#(lf)ORDER BY P.prsncode, iotransactiondate desc#(lf) #(lf)",
Source = Sql.Database("192.168.30.2", "exen", [Query = dbQuery])
in
Source