1. Version overview

    Article: AN0002034Updated: 23.10.2021

    Version 2.0.0.0 (October 2021)

    Classes and queries

    Import

    • Setting Delete import table - if not checked the auxiliary table will persist in the database and therefore you can control better course of the import or perform your custom subsequent steps using data from the import.
    • For columns with defined sequence, the sequence is filled in automatically. If an import is performed to such a column, then the value is taken from the import.

    Piklo

    • The function OG_AD-User returns now all user properties (the output file now contains over 100 columns). At the same time, it is possible to limit the reading of users only to certain Organizational units.

    Page

    • Webpart Report displays now also its legend.
    • Webpart Display links in boxes was removed.

    Administration

    • Page with the list of emails contains now filter by recipient, subject, created from/to.
    • Function Scripts and functions in the model shows also content of the Pages (ContentPage).
    • Page List of roles shows the field External group.
    • Log tables changed column type for column ID from int to bigint.
    • Names of some objects  were extended from 50 to 255 characters.
    • Particular pages can be enabled for ObjectGears in IFRAME, setting in configuration.
    • Access of user that are not loged in when using Windows authentication was enabled, to public pages and reports, if these objects set permissions for All users.
    • You can set in master-detail relations, what should be displayed: changes in data, emails, attached files.
    • Page UserAccessLog contains link to the user displaing the used user account (see alternative user accounts).
    • Three new possibilities how to terminate a Job during its course.

    Scripts

    • New functions in NotificationList: GetByCodeAndPersonLanguage, this[code], GetDefaultByCode.

    Modules

    • Module Menu was extended with configuration for svg and image size.

    Other

    • New graphic look.
    • In the left menu there is a tab with the last user activity.
    • It is possible to define large and small photos for users. Links to the user then display a small photo or user initials.
    • It is possible to define a background image in the system header. The user can choose their own theme for the ObjectGears system (on the user's detail page).
    • The main user pages (pages encountered by the average user, not the IT model owner or the ObjectGears Administrator) have been translated into Slovak.
    • By clicking on the buttons on the toolbar, the buttons are disabled, thus preventing repeated clicks by the user.
    • A number of new predefined columns have been added to create a new column in the class.
    • New graphic design of the documentation.

    Version 1.9.0.0 (May 2020)

    Classes and queries

    • Column type File can store data ouside of database (on Filestream or on disk).
    • There can be whatever columns selected for display in master-detail relations.
    • There is button Class/Query in the list of records and in the record detail in the toolbar with links to class/query subobjects - in this way it is possible to navigate to other objects in a faster way.
    • Automatic query regeneration after change of underlying classes or queries.

    Pages

    • There are links to page subobjects in the page display, in its detail and in the design - in this way it is possible to navigate to other objects in a faster way.

    Imports

    • New setting Number of ignored rows, that determines how many rows at the begging of the file will be skipped.
    • When Import unique records is set there are records ignored in which the mapping column has a NULL value.
    • It is possible to perform import into parent classes. Only update is enabled, no record creation or deletion.

    Entities

    • Class - property Abstract class was removed.

    Administration

    • Error Log was renamed to Event log.
    • There is an icon with context menu in the list of jobs for a fast access to ots subobjects.
    • It is possible to define an unlimited number of IT owners for a model.

    Other

    • Archiving of administration objects was improved.
    • Support for Firefox was improved - localization window.
    • New icon (Scheme) was added to the toolbar for scheme with links to objects of the scheme.

    Extensions

    • There are two new installation packages for reading emails from Exchange and SMTP server.

     

    Version 1.8.0.0 (April 2019)

    Classes and queries

    • If there is no ordering defined in master-detail relations then descending order according to record ID is used.
    • There can be variable DataRow.Url used in email notification for automated time operations.
    • When using variable column... in the description format, no error is raised if the record is not available.
    • Schemes are supporting localized names.
    • Improved localization for XClasslink, data selection form, tags.
    • Short description is supporting class inheritance and localization.
    • New fields in the class detail Format of the class name in the record list and Format of the class name in the record detail for class title definition in the list of records and in the record detail.
    • Order of columns displayed in the quick filter can be changed.
    • Column UID was removed from tables DataRow.
    • Rules can be defined for the column of type File.
    • Class can be copied (using a button in class detail) including its subordinary objects.
    • Text in HTML format can be wrapped in the notification using function nl2br.
    • Order of columns in the master-detail relation can be easily changed by drag and drop of the column.
    • Filter can be aplied in schemes for selection of referred records.

    Exports

    • Notifications for export can use sending export as an attachment.

    Pages and webparts

    • Names of tabs on pages can be localized.
    • Webpart Percentage value display can contain URL for displaying more detailed data when clicking on the chart.
    • New property of the webpart Percentage value display - Maximum value. If there is not a column value defined, then the value from the webpart definition is use (if filled in).

    Reports

    • Report Pie chart can contain URL. Chart legend can contains a link that will navigate user to the given URL.

    Scripts

    • New function ToInt for conversion of double to int/int?
    • New property OGPageSetting.PageTitle for defining page name in Datas, DataDetail and WebContentPage.
    • Three new parameters of object OGEditOptions
    • Function OG.DataRow.CreateNew( parentId) creates a new object DataRow and newly initializes it also with default values and sequences.
    • New function OG.WorkdlowSeq.FinishTask for terminating all tasks for the record.
    • New function OG.TextUtils.Format.
    • New function OG.Sequence.GetNextValueWithFormat.
    • New function OG.Log.WriteSecurity.

    Administration

    • Appearance of the elements in the detailed form was modified.
    • Při emailu, který je vytvářen automaticky se plní odesílatel (property From). Tento údaj je pak zobrazen v detailu emailu (EmailDetail.aspx).
    • Administration pages contain now also button Save and stay. Repeated modification of the record is then faster.
    • Appearance of the pages for logon and password change was modified.
    • When searching in Scripts and function in the model also application events are searched through.
    • Page with log administration contains newly a column with number of rows in DB. This gives an idea about size of the table.
    • Page User access log allows to filter by user IP.
    • Following objects are not deleted logically anymore, but are deleted physically, directly from the database: job, export, import, automated time operations, workflow.
    • The filter in the List of registered errors (ErrorLog.aspx) contains Type for a better search.
    • Two new application events.

    Database

    Configuration

    Modules, models and micromodels

    Other

    Version 1.7.1.0 (April 2018)

    Classes and queries

    Columns

    • Text column HTML - displays toolbar with less buttons in the readonly mode

    Entities

    • DataRow - new function FindColumn
    • DataRowFilter - records filtering can be defined by means of command CODE:
    • Model - Nové metody pro řazení modelů

    Scripts

    • OG.ClassDef - new function HaveUserRightByOperationCode
    • OG.Export - Script after export end - new property OGActualExportContent
    • OGForm - new function ExistControl
    • OG.Workflow - new functions (RunById, GetAll, GetById, GetByCode)
    • OG.Debug - new functions for entries into Debug log

    Database

    Other

    • Menu - application menu is loaded asynchronously which decreased the page size and accelerated responses
    • Modules - modules contain information in Module.SubDirectory about, in which disk folder the module is stored
    • Error entry in Errorlogu takes care of large amount of same errors
    • Improved debugging of user activities in the system 

    Version 1.7.0.0 (December 2017)

    Data

    • Data on the page List of records (Datas) can be exported both in CSV and Excel
    • Also sent emails are displayed in the detailed record archive

    Classes and Queries

    • Access rights can be inherited from referenced data records
    • Query can refer also to object ID in its definition
    • Page with List of rules contains also Filter for a better search - by rule type and action type
    • Rule Start a script
      • can  use OGActualMessage for message to the user after rule finishes
      • has a setting Check the mandatory columns first
    • Order of buttons in the form can be determined with a new setting Order
    • Rule for templates - enables adjusting DataRow before inserting into the template

    Columns

    • Type Date und time - new field for Selection format and Time alignment
    • Type Text - new field for regular expression
    • Type File
      • new setting Delete the oldest file
      • if the user attempts to download a file he is not authorized to, an error message can be displayed
    • Type Picture - can include a link
    • Summary functions SUM, AVG, MIN and MAX can be defined in any combination for columns.

    Page

    Scripts

    Other

    • Global search - also changed records can be searched according to the time of the change
    • Control for script editing and display of help for scripts enables to change its width dynamically
    • Page Overview of scripts and formulas in the model  enables to pack the script texts - this improves search in a page with long scripts
    • New parameter type added for decimal
    • Object Mailbox does not require a class. Everything can be managed by a script

    Modules

    • MultiEdit - new configuration possibilities (width, css styles), possibility to display data from query, horizontal shift
    • Utilities - new webpart for Selection of week or month
    • New colour scheme Titanium

    Administration tool

    Version 1.6.1.0 (May 2017)

    Data

    • export into Excel on page Datas considers column hiding performed also by the script for the list of records
    • optimalization of the database data reading
    • deleted files (at column type File) are marked by a grey colour and italics font. The is also (deleted) stated after the name of the file

    Columns

    • new property List of enabled colours at column type Colour
    • new property Column in DB is displayed in the list of columns (ColumnClassDefs.aspx)

    Rules

    Webparts

    • new property Display webpart style at webparts

    Scripts

    • new properties available at clicking on a button: OGControlOperation, OGContentPage and OGDataParent
    • new functions and properties
      • OG.Email (EmailFrom, BlindEmail)
      • OG.Person (two new functions GetPersonInRolesByCode)
      • OG (cca 20 new configuration properties available in a script)

    Administration

    • Time calculation for processing the request on server. The value is displayed on page UserAccessLog.aspx in the field Response duration.
    • Change of the paghe name was not reflected in menu. Corrected now.
    • Mass deletion is disabled for class extending user properties.

    Administration tool

    • possibility to change the language by selection in combobox

    Licence Creator

    • possibility to change the language by selection in combobox

     

    Version 1.6.0.0 (March 2017)

    Data

    • column order set up for display in the list of records and detailed list of records
    • authorizations ReadDetail and ReadList were combined into a single authorization Read

    Columns

    • property Max. number of files for column type File counts now only undeleted files. Number of deleted files is not limited.
    • New column type "Value from a referenced class (various classes)"
    • new property Localize - enables to define a localized text in the column
    • new record initialization was improved on datadetail. It runs now in this order: 1. default values, 2. template, 3. sequences, 4. rule for value set up and script, 5. initialization via URL
    • Fields for formulas were cancelled. We recommend to ue rules instead of formulas.
    • particular summary information (min, max, sum, avg) can be defined independently
    • script for check of authorizations to the file content can be defined for column type File

    Queries

    • expressions {{:model.kod.id:}}   {{:class.kod.id:}}   {{:query.kod.id:}} can be used in the query definition, which enables to include class ID in the given instance into SQL query

    Master detail relations

    Rules

    • rule Start s script has a new property OGDataParent
    • rules do not have to have unique order
    • rule for Value set up - code of the required records can be used instead of ID for columns of type reference to a class
    • rule Before record saving has a new object OGSaveOption, that can suspend record saving without cancelling the saving

    Jobs

    • Job can be executed immediately for test purposes by means of a button or by means of function OG.Job.RunJob(string code)

    Pages

    • tabs can be configured in the page design
    • move to another page after certain time elapses can be set in the page configuration

    Emails

    • if email sending is not configured, then email is set to status "Email senidng is not configured" at its sending. Such email is not sent again after later configuration.

    Scripts

    • property QueryString was moved from OGForm to OG
    • property DataRowFilter.WriteSqlToLog writes into the log both sql and parameters, with which the filter was executed
    • New properties:
    • New functions:
      • OG (Throw)
      • OG.ContentPage
      • OG.DataRow (SaveData, 2x GetDataRowByCode)
      • OG.DateTime (Difference)
      • OG.Email (GetAllEmailTemplates, CreateMessage, Send)
      • OG.Job (RunJob)
      • OG.Log (WriteException)
      • OG.Module (IsExistActive, GetModuleCode, SendSMS, IsAllowSendSMS)
      • OG.Person (2x IsUserInGroupById, 2x IsUserInGroupByCode)
      • OG.QueryString (Query)
      • OG.Report
      • OG.Role (GetByCode)
      • OG.Script (CreateParameterList, Run)
      • OG.TextUtils (ConvertToList, ConvertPersonsToSeparatedString, ConvertEntitiesToSeparatedString, ConvertStringsToSeparatedString, ConvertIntToSeparatedString, Compare, UrlEncode, UrlDecode, HtmlEncode, HtmlDecode)
      • OG.Utils (CreateImage(), ReadFileToBytes, ReadFileToString, ReadFileToLines, MapServerPath)
    • Removed properties:
    • Removed functions:

    Database

    Administration

    • page for Setup of length of text fields was removed. All text fields are now as varchar(max) in the database
    • there is request category displayed in the user access log - it enables to find out which request type represents the biggest load for the system
    • the indication Enabled is coloured in grey in several pages, if the value is et to FALSE - this highlights that the given object is "off"
    • new configuration parameter GroupCodeColumnClassDefId
    • administrator can perform search in scripts and functions accoss all the models at one time
    • modules can contain webparts, that can be inserted in the page

    Admin tool

    Modules

    Model

    • Knowledge base - support for video from youtube or from a local storage

     

    Verze 1.5.0.0 (April 2016)

    • new types of reports - Sunburst, Monthly calendar, Time map and Tree map
    • admin tool
    • pages
      • public page
      • webpart name can be localized
    • text field
      • replacement of three text column types by a single one with possibility to set its length
      • dynamic text field height- height will be adapted to the input text
    • script window
    • object archive
    • record teplates
    • diskSizer
    • restrictions for import start
    • report history
    • rules for report List of records
    • column type Picture does not use database type image, but varbinary. Image will not be used in SQL Server in future any more.
    • responsive design
      • responsive design improved on pages Datas, DataDetail
      • MobileBrowsersDefinition and MobileAppsDefinition settings removed from the configuration
      • settings for mobile layout removed from the Page
    • display of Job execution improved - each type is recorded in a separate line (jobs, workflow, time operations...)
    • scripting - function OGForm.QueryString.GetString(name) added
    • jobs - Integration job indication added
    • role - role name can be localized

     

    Version 1.4.x.0 (September 2015)

     

    Version 1.3.0.x (February 2015)

    • New page design
      • Flat design
      • Responsive design (adaptation to the screens of smartphone/tablet/monitor).
      • Favourite items in menu
      • Search in menu
    • Filters.
    • A query can be used in master-detail relations.
    • Multiple references in query.
    • Displaying class data in form of calendar and time line.
    • Function for counting time based on calendars.
    • Extension of xml import possibilities (reading from element or attribute, namespace...)
    • Display of buttons based on role.
    • Loalization of names of multiple columns.

     

    Version 1.2.0.x (September 2014)

     

    Version 1.1.8.0

    • Model Knowledge base
    • Time operations
    • Own page layout
    • Webparts Display the rating, Display of links in boxes, Percentage value display, Search text, Language selection
    • Localization of user messages used in scripts
    • Number of records in master-detail relations
    • Redirection from a column to a page
    • Text parsing

     

    Version 1.1.7.0

    • Multiple selection in search forms
    • Display of references to logically deleted records
    • New workflow activities
    • Detail archive
    • Scripts of administration pages
    • Script objects for selected and filtered records
    • Context menu with objects available in scripts in various system components

     

    Version 1.1.6.0

    • Organization structures and access rights on particular records
    • Jobs
    • Workflow
    • Delegation of user tasks
    • Scripting
    • Master-detail relations of user
    • Webparts - webpart grid, file editing, script
    • Help and documentation in the application
    • Registering database exceptions
    • Column of type picture and pictures of records in the schemes

     

    Version 1.1.5.0

    • Schemes improvement
    • Extension of web services and display
    • Implementation of access rigths for IT administrator of the model
    • Metadata localization

     

    Version 1.1.3.0

    • Update reference classes with new unique records
    • Rules for classes and queries
    • Schemes of object dependence (SVG, HTML5)
    • Web services

     

    Version 1.1.0.0

    • Class inheritance
    • Short descriptions of objects
    • Polymorphism
    • Complex data imports
    • Lookup in reference classes
    • References to parent classes
    • User access dependent menu
    In this article
    ×