Versions Compared

Version Old Version 6 New Version 7
Changes made by

serdar ak

Arda Ülgü (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Key

Description

WorkspaceName

WorkSpace(s) to which the settings will apply.

TableFilter

Tables to which the settings will apply.

ColumnFilter

Tables that contain the given columns (if - is given, tables that do not contain the relevant columns are considered). If more than one is given, the relationship is AND.

Columns

Columns to be Indexed or Excluded

Code Block
languagejson
{
   "Defines":[
      {
         "__type":"Geodi.Database.Meta.DBView, Geodi.Database",
         "WorkspaceName":"0000-Promotional and Educational Videos",
         "TableFilter":"*",
         "ColumnFilter":"*",         
         "Columns":"-FILEPATH,-ID,DATE,GEODIFILELINK"
      },
   ]
}

...

  • File1 column shows file names File2 column shows blob files. In the created database, the BLOB file column is selected as "bytea" data type.

  • You can use it in Access,Postgres,Mssql,Oracle,Sqlıte,MySql databases.

  • (warning) FileMemoColumn in VT must have a file extension in the given column.

    • If there is no extension in the column value and all files are of the same type, an extension can be added to the macro value.

FileMemoColumn

Key

Description

BLOB/MEMO field containing the file content. GEODI will automatically determine the file content

IDColumnMacro

Macro for the unique number of the file. The rules for macros are at the end of the document.

FileNameColumnMacro

Macro for the name of the file to appear in searches and viewers. Rules for macros are at the end of the document.

FileMemoColumn

BLOB/MEMO field containing the file content. GEODI will automatically determine the file content

Code Block
languagejson
{
   "Defines":[
      {
         "__type":"Geodi.Database.Meta.DBSubContent, Geodi.Database",
         "TableFilter":"TEST",
         "IDColumnMacro":"[OBJECTID]",
         "FileNameColumnMacro":"[FILE1]",
         "FileMemoColumn":"file2"
      }
   ]
}

...

Code Block
languagejson
{
   "Defines":[
      {
         "__type":"Geodi.Database.Meta.DBSubContent, Geodi.Database",
         "TableFilter":"TQA",
         "IDColumnMacro":"[OBJECTID]_1",
         "FileNameColumnMacro":"[file1]",
         "FileMemoColumn":"file2"
      },
      {
         "__type":"Geodi.Database.Meta.DBSubContent, Geodi.Database",
         "TableFilter":"TQA",
         "IDColumnMacro":"[OBJECTID]_2",
         "FileNameColumnMacro":"[dosya1file1]",
         "FileMemoColumn":"dosya2file2"
      }
   ]
}

Indexing an Embedded File Without a Filename in a Table

...

Code Block
languagejson
{
   "Defines":[
      {
         "__type":"Geodi.Database.Meta.DBPKey, Geodi.Database",
         "WorkspaceName":"BLOBDataset Deneme",
         "KeyColumns":"BelgeBelgeIDDocDocID"
      }
   ]
}
Code Block
languagejson
      {
         "__type":"Geodi.Database.Meta.DBPKey, Geodi.Database",
         "TableFilter":"tablo1table1",
         "KeyColumns":"id"
      },

Indexing the result of an SQL statement

...

Code Block
languagejson
{
   "Defines":[
      {
         "__type":"Geodi.Database.Meta.DBSQL, Geodi.Database",
         "TableFilter":"ADABLOCK,IRTIFAKEASEMENT_HAKKIRIGHT",
         "ColumnFilter":"ADABLOCK.ADABLOCK_NO,ADABLOCK.OBJECTID,IRTIFAKEASEMENT_HAKKIRIGHT.OBJECTID,IRTIFAKEASEMENT_HAKKIRIGHT.TABAKALAYER",
         "NewName":"ADALAR2BLOCKS2",
         "SQL":"SELECT * FROM ADABLOCK,IRTIFAKEASEMENT_HAKKIRIGHT WHERE IRTIFAKEASEMENT_HAKKIRIGHT.OBJECTID=ADABLOCK.OBJECTID",
         "KeyColumns":"ADABLOCK.OBJECTID"
      }
   ]
}
Code Block
languagejson
{
   "Defines":[
      {
         "__type":"Geodi.Database.Meta.DBSQL, Geodi.Database",
         "TableFilter":"TEST,TEST1",
         "ColumnFilter":"TEST.TARIHDATE,TEST.OBJECTID,TEST1.OBJECTID,TEST.TAMS1INT1",
         "NewName":"DENEME12TEST12",
         "SQL":"SELECT TEST.* FROM TEST,TEST1 WHERE TEST.OBJECTID=TEST1.TAMS2INT2",
         "KeyColumns":"OBJECTID"
      }
   ]
}

...

Code Block
languagejson
{
   "Defines":[
      {
         "__type":"Geodi.Database.Meta.DBRowDisplayName, Geodi.Database",
         "TableFilter":"",
         "DisplayNameMacro":"[TEXT4]/[TEXT2]-[TAMS1]"
      },
      {
         "__type":"Geodi.Database.Meta.DBSQL, Geodi.Database",
         "TableFilter":"TEST,TEST2",
         "ColumnFilter":"TEST.TARIHDATE,TEST.OBJECTID,TEST2.OBJECTID,TEST.TAMS1INT1",
         "NewName":"DENEME12TEST12",
         "SQL":"SELECT TEST.* FROM TEST,TEST2 WHERE TEST.OBJECTID=TEST2.TAMS2INT2",
         "KeyColumns":"OBJECTID"
      },
      {
         "__type":"Geodi.Database.Meta.DBRowPermission, Geodi.Database",
         "TableFilter":"DENEME12TEST12",
         "PermitMacro":"DECE\\kullanıcıadıusername",
         "DenyMacro":"[geodi:kullanıcıadıusername]"
      }
   ]
}

Example 2 : Created Group Based Authorization

Code Block
languagejson
{
   "Defines":[
      {
         "__type":"Geodi.Database.Meta.DBRowPermission,Geodi.Database",
         "TableFilter":"test",
         "ColumnFilter":"birimlerunits",
         "PermitMacro":"[birimlerunits]",
         "DenyMacro":""
      }
   ]
}

Example 3 : Advanced Macro Examples

Code Block
languagejson
{
   "Defines":[
      {
         "__type":"Geodi.Database.Meta.DBRowPermission,Geodi.Database",
         "TableFilter":"test",
         "ColumnFilter":"birimlerunits",
         "PermitMacro":'=d.Get<string>("birimler").Split(\',\')',
         "DenyMacro":""
      }
   ]
}

...

Code Block
languagejson
{
   "Defines":[
      {
         "__type":"Geodi.Database.Meta.DBRowPermission,Geodi.Database",
         "TableFilter":"test",
         "ColumnFilter":"birimlerunits",
         "PermitMacro":'=new string[] {d.Get<string>("YETKILI_GRUPAUTHORIZED GROUP"),"S-1-5-21-128668610-1027347169-903626496-1222","geodi:guest"}',
         "DenyMacro":""
      }
   ]
}

...

Code Block
languagejson
{
   "Defines":[
      {
         "__type":"Geodi.Database.Meta.DBRowPermission,Geodi.Database",
         "TableFilter":"test",
         "ColumnFilter":"birimlerunits",
	 "PermitMacro":'=new string[] {string.Concat("GrubumMyGroup_",d["KOLON1COLUMN1"]),string.Concat("GrubumMyGroup_",d["KOLON2COLUMN2"])}'
         "DenyMacro":""
      }
   ]
}

...

Code Block
languagejson
{
   "Defines":[
      {
         "__type":"Geodi.Database.Meta.DBRowPermission,Geodi.Database",
         "TableFilter":"test",
         "ColumnFilter":"BIRIMLERUNITS,BIRIMLERUNITS_TEST",
         "PermitMacro":'=new string[] {d.Get("BIRIMLERUNITS"),d.Get("BIRIMLERUNITS_TEST")}',
         "DenyMacro":""
      },
   ]
}
________________________________________________________________________________________
{
   "Defines":[
      {
         "__type":"Geodi.Database.Meta.DBRowPermission,Geodi.Database",
         "TableFilter":"test",
         "ColumnFilter":"BIRIMLERUNITS,BIRIMLERUNITS_TEST",
         "PermitMacro":'=new string[] {d["BIRIMLERUNITS"],d["BIRIMLERUNITS_TEST"]}',
         "DenyMacro":""
      }
   ]
}

...

Code Block
languagejson
{
   "Defines":[
      {
         "__type":"Geodi.Database.Meta.DBContent, Geodi.Database",
         "WorkspaceName":"otf_meta_testV1",
         "TableFilter":"TEST",
         "ColumnFilter":"TARIHDATE",
         "Ignore":"False",
         "Content":"[TAMS2INT2] ZAMANTIME [TEXT3]"
      }
   ]
}

...

Adjusting the Way Records Look

...

Code Block
languagejson
{
   "Defines":[
      {
         "__type":"Geodi.Database.Meta.DB_DLV_View, Geodi.Database",
         "TemplateName":"PortalAnkaraGeziveMesirePortalLondonTourandPicnic.html"
      }
   ]
}

FieldIndex Settings (Limiting Searches by Column Name)

...

Code Block
  <data name="att_{fieldname}" xml:space="preserve">
    <value>{alias1}|{alias2}|{alias3}</value>
  </data>
  
  <data name="att_EnvanterNoInventoryNo" xml:space="preserve">
    <value>Envanter<value>Inventory Numarası|EnvanterInventory N.|EnvanterInventory Sırası<Order</value>
  </data>
  <data name="att_ADINAME" xml:space="preserve">
    <value>Ad<value>Name|AdıName SoyadıSurname|AdSoyad<NameSurname</value>
  </data>

myfields.en-us.resx

Code Block
  <data name="att_{fieldname}" xml:space="preserve">
    <value>{alias1}|{alias2}|{alias3}</value>
  </data>
  
  
  <data name="att_EnvanterNoInventoryNo" xml:space="preserve">
    <value>Inventory Number|Inventory N|Inventory Position</value>
  </data> 
  <data name="att_PersonName" xml:space="preserve">
    <value>Name|Pname|Person Name</value>
  </data>

...

"FileFullPathColumnMacro":"C:\TEST\KUR-1166 VT\files\[FILE1]"

"DisplayNameMacro":“[ADANOBLOCKNO] Ada [PARSELNOPLOTNO] Parsel”Plot”

"DisplayNameMacro":“[TITLE]-[POSITION]”

...

"DisplayNameMacro":'=string.Concat(d["ADANOBLOCKNO"]," Ada Block ",d["PARSELNOPLOTNO"]," ParselPlot")'

"DisplayNameMacro":'=string.Concat(d["TITLE"],"-",d["POSITION"])'

...