Please rebuild this data combination

umut

New member
Joined
Feb 13, 2017
Messages
1
Reaction score
0
Points
0
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 ?

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
 
Back
Top