    


1.     ""      .

  -       ( "Journals group"),
       

.Type=Journals group

         ,  
         :

[Journals group]
.Parent=NULL
.Caption=Journals group
.BasedOn=Journals group
.Type=Journals group
.ReplicAble=1
.IsGroup=1


2.          

 -         ,
      

.Journal=

         ,  
         :

[Materiale]
.Parent=Journals group
.Caption=Materiale
.Journal=
Caption=02.
.type.Caption=String
DocTypesFilter=
.type.DocTypesFilter=Memo
SQLFilter=
.type.SQLFilter=Memo


3.      

     : "DocTypesFilter"  "SQLFilter"

 "DocTypesFilter"       (SYSFID),
       .
        .
, "id=48115 or id=48116 or id=48132"  "(id>=1201 and id<=1220 or id=604)"


 "SQLFilter"       (SYSFID),
       .
      SQL  .
, "sysfid in (48115,48116,48132)"  "(sysfid between 1201 and 1220 or sysfid=604)"


3.      

 "Caption"    ,   .
(           )

 "DLL ID"        .
(   "DLL ID"    )

 "DLL JournalName"      .
(       "DLL ID")

 "DocTypesDefault"  SYSFID   ,
      .
(  DocTypesFilter   SYSFID,     )

 "SQLBody"   SQL-,     .
     ,      
SELECT * FROM VMDB_DOCS

:

[ZZZ]
SQLBody=.MEMO.ZZZ.SQLBody
.type.SQLBody=Memo
[.MEMO.ZZZ.SQLBody]
select * from (SELECT D.*,
(select prfact_seria from VMDB01M_VINZ  WHERE cod=d.cod) seria,
(select prfact_nr from VMDB01M_VINZ  WHERE cod=d.cod) numarul,
(SELECT DENUMIREA FROM VMS_UNIVERS U, VMDB_ST201M M
 WHERE U.cod=NVL(M.CTDEP,m.Dtdep) AND M.NRDOC=D.COD) CLIENT,
(select prfact_data from VMDB01M_VINZ  WHERE cod=d.cod) datafact
FROM VMDB_DOCS D)


4.    

       
" "      .

       
       "Grid"   
"Save grid properties".

