Zmiany pomiędzy wersją 8 and wersją 9 dla DeployerGuide/Custumization/AdvancedReporting/SQLExamples

Pokaż
Ignoruj:
Data i czas:
01/08/14 01:19:38 (11 years temu)
Autor:
JP (IP: 89.70.109.53)
Komentarz:

--

Legend:

Bez zmian
Dodane
Usunięte
Zmienione
  • DeployerGuide/Custumization/AdvancedReporting/SQLExamples

    v8 v9  
    183183{{{ 
    184184-- Statusy dokumentów o dctpid = 2 (Faktury) 
    185 SELECT tpstid, dscrpt, * FROM types_of_processes_states  
     185SELECT tpstid, dscrpt FROM types_of_processes_states  
    186186WHERE clsnam = 'DOCUMENT|2' ORDER BY state_ 
    187187 
    188188-- Statusy spraw (ogólne - nieprzypisanego do żadnego RWA) 
    189 SELECT tpstid, dscrpt, * FROM types_of_processes_states  
     189SELECT tpstid, dscrpt FROM types_of_processes_states  
    190190WHERE clsnam = 'PROCESS' ORDER BY state_ 
    191191