@unitybase/adminui-vue #

Added #

_1.13.20 _2020-11-19 #

new optional column property filterable for column configuration of UTableEntity. To disable filtration by column sets column.filterable = false
UFormContainer: provides isDisabled property to child controls. This property disables child "U-controls" when its true.
UBaseInput, UAutoField and USelectEntity inherit isDisabled from parent
UForm.processing: callback errorNotification is added. Allows override a default error notification behavior.

_1.13.19 _2020-11-15 #

processing.load: added .misc({ ID: ID }) which allows to make a request with ID bypassing caching, soft deletion and history. This solves the problem with the opening of forms of records that are no longer relevant.

_1.13.18 _2020-11-14 #

UTableEntity: new prop bordered (true by default) - display a border around table and toolbar. See for example cdn_person form - with border around Contacts its looks better.

Changed #

_1.13.22 _2020-11-23 #

user menu Settings now contains a sub-menu Scanner settings what shows a scanner settings form. Ext based ubm_desktop-userSettings form (was shown on setting menu click before these changes) is removed.

_1.13.20 _2020-11-19 #

UTableEntity - prevent hangs on huge text attributes content:
- in case columns is not specified will exclude attributes of type Text, JSON and Document from autogenerated columns list (before this fix attributes of type Text are included)
- UTableEntity: in case attributes or Repository not specified will exclude from autogenerated Repository attributes of types Text, JSON and Document even in case defaultView for such attributes is true in metadata

_1.13.18 _2020-11-14 #

UCodeMirror - use esversion: 8 (async functions) as default for linter

_1.13.17 _2020-11-10 #

USidebar sidebar width to 0px in collapsed state and screen less than 768px (mobile)

_1.13.14 _2020-11-01 #

USelectEntity: prop readonly does not disable action edit in dropdown anymore, but disabled still does

Fixed #

_1.13.23 _2020-11-25 #

UBaseInput: fix disabled prop in case need to disable only this field and not the entire form container
UTableEntity <entity-name>:changed events (does not try to refresh) in case payload not contains a valid resultData with ID
UTableEntity: fixed disabling of sorting by clicking on a column header if the column configured as not sortable
UTableEntity filter - use correct translation for multiple condition - Multiple instead of Contains

_1.13.22 _2020-11-23 #

UBaseInput,UAutoField,USelectEntity: fixed missing injection in case when the control is outside the UFormContainer
UTableEntity: sorting now replaces the orderList rather than adding a new condition to the existing one

_1.13.21 _2020-11-20 #

UTableEntity: fixed attributes filtration for tables initialized with columns (introduced in 1.13.20)

_1.13.20 _2020-11-19 #

UFile: prevent download document in case preview-mode not sets
UTableEntity error on click column which has no filters

_1.13.16 _2020-11-08 #

UDialog - if Cancel button not available - sets focus to the first available button.

_1.13.14 _2020-11-01 #

store.canRefresh getter returns true for any non-new record (before this fix - for non-new and dirty). This allows calling "Refresh" action on the non-dirty forms.

@unitybase/adminui-pub #

Changed #

_5.13.51 _2020-11-14 #

UBCodeMirror - use esversion: 8 (async functions) as default for linter

@unitybase/base #

Added #

_5.4.6 _2020-11-15 #

DBConnection.selectParsedAsObject for Postgres warning added: Postgres return all field name in lower case if AS "normalName" is not specified, so better to write a query as such select ID as "ID", modelName AS "modelName" from .. instead of select ID, modelName from ..

_5.4.5 _2020-11-14 #

ServerRepository.selectAsArrayOfValues() - for Repository with ONE attribute returns a flat array of attribute values

 const usersIDs = UB.Repository('uba_user').attrs('ID').limit(100).selectAsArrayOfValues()
 // usersIDs is array of IDs [1, 2, 3, 4]

_5.4.3 _2020-11-10 #

argv.establishConnectionFromCmdLineAttributes: default value for -host parameter is changed to auto. if -host auto or UB_HOST=auto env variable is defined then host will be taken from application config

_5.4.2 _2020-11-08 #

DBCOnnection.selectParsedAsObject for Oracle warning added: Oracle return all field name in UPPER case if AS "normalName" is not specified, so better to write a query as such select ID, modelName AS "modelName" from .. instead of select ID, modelName from ..

_5.4.0 _2020-11-05 #

createDBConnectionPool adds connection with name DEFAULT for easy access to default DB connection
in case DBConnection.genID called with undefined it return ID for connection. If with entity code - for specified entity.
argv.establishConnectionFromCmdLineAttributes will always uses 'ROOT' auth schema if user is 'root'. Before this fix 'ROOT' schema is used if user is root AND server is started by this session.

Changed #

_5.4.6 _2020-11-15 #

ServerRepository.selectScalar() optimized to use less JS memory

_5.4.1 _2020-11-08 #

options.parseVerbose ( a command line parameters parser) will throw in case of invalid / missed parameters. This returns a 1 exit code to caller and, for example, can prevent batch script from further execution.

_5.4.0 _2020-11-05 #

createDBConnectionPool will re-use previously created pool

Fixed #

_5.4.0 _2020-11-05 #

added missing {ubRequest} type definition

@unitybase/blob-stores #

Added #

_5.5.0 _2020-11-15 #

BLOB stores: new storeSize Hourly - as Daily but with sub-folder for each hour inside a day folder
BLOB sores: new property LUCount - a count of Logical Units BLOB stores divided into. If > 0 then files are stored inside Logical Unit sub-folders /LU01, /LU02,.

Write operations works with last LU folder. Each LU folder can be mounted to his own partition. In this case tempPath should point to the same partition as last LU.

_5.4.17 _2020-11-14 #

@unitybase/blob-stores/storesPerfTest.js - BLOB store performance testing endpoints implementation. See doc inside a storesPerfTest.js for usage sample.

_5.4.11 _2020-11-01 #

App.blobStores.getContentPath method - retrieve full path to a file with BLOB content (in case store is file-based)

Changed #

_5.5.2 _2020-11-20 #

mdb BLOB store: if reverseProxy is nginx then getDocument request for permanently stored items will redirect to sendFileLocationRoot/models internal location to unify retrieving of models and cmodels.

On the production cmodels is located in then /var/opt/unitybase/.. while models - in the /opt/unitybase/... Since linkStatic links both to the inetpub/clientRequire/models, so better to get all mdb items from there.

ubcli generateNginxCfg should be executed after upgrade to this version (ub-app-upgrade lifecycle script is doing this)

_5.4.16 _2020-11-12 #

mdb store now stores MD5

Fixed #

_5.4.12 _2020-11-05 #

MdbBlobStore do not throw an error on deletion

@unitybase/cdn #

Changed #

_5.4.43 _2020-11-10 #

cdn_profession.meta: added defaultView: false for attribute description

Removed #

_5.4.43 _2020-11-10 #

-cdn_profession-fm.def: better to use autoform

Fixed #

_5.4.49 _2020-11-23 #

cdn_organization - deny ANY update for organizations with government organization type (orgBusinessTypeID.isGovAuthority=true) by roles not in cdn.organization.accessAddGovByRoles list.

Before this fix updating was possible if orgBusinessTypeID is not changed. Also, was possible to change an org type from government to non-government.

_5.4.39 _2020-11-01 #

cdn_contact-fm.vue: fixed form opening without parentContext [UBDF-12453]

@unitybase/cs-shared #

Added #

_5.5.11 _2020-11-20 #

UBEntityAttribute.privateSettings & UBEntity.privateSettings properties. Can be defined in meta file and available in server-side domain. not available on client-side. Require UB server 5.18.20 and up.

_5.5.9 _2020-11-14 #

CustomRepository.selectAsArrayOfValues() - for Repository with ONE attribute returns a flat array of attribute values

_5.5.8 _2020-11-05 #

new properties UBDomain.customerModels & UBDomain.vendorModels - array of customer/vendor models names. Require UB server to be >= 5.18.17. For earlier versions returns empty arrays.

Changed #

_5.5.7 _2020-11-01 #

ClientRepository Object result will force converting Enums attributes values to String. This fix a problem when enum value is number like (1 for example) and client got a numeric response. General recommendations is to set enum values to alphanumeric string.

Fixed #

_5.5.8 _2020-11-05 #

DBConnectionConfig type definition: added missing isDefault property

@unitybase/mailer #

Added #

_5.4.0 _2020-11-23 #

notes in the README about SSL setup for Linux
UBMail.UBMailImap class - receive mail using IMAP protocol
UBMail.TubMailReceiverImap - a direct replacement for UBMail.TubMailReceiver but uses IMAP instead of POP3
fullSSL property added for TubMailReceiver, TubMailSender and TubMailImap. If true - setup TLS before any command to mail server. See README for OpenSSL requirements.

@unitybase/org #

Changed #

_5.4.20 _2020-11-25 #

allow log-in for user who not assigned to employee for members of Admin group (in addition to admin and root user). This fix regression introduced in @unitybase/org@5.4.0.

The source of regression is so called "local administrators" - a regional administrator`s in a huge organizations.

_5.4.13 _2020-11-10 #

org_unit-fm, org_staffunit-fm, org_profession-fm, org_department-fm: rewritten to vue

Fixed #

_5.4.20 _2020-11-25 #

org_staffunit-fm: fixed typo in parent context of org_employeeonstaff grid

_5.4.17 _2020-11-19 #

org_staffunit-fm, org_profession-fm, org_department-fm: fixed form saving without a required caption field by adding masterFieldList [UBDF-12721]

@unitybase/ub-pub #

Added #

_5.5.30 _2020-11-14 #

ClientRepository.selectAsArrayOfValues() - for Repository with ONE attribute returns a flat array of attribute values

 const usersIDs = await UB.Repository('uba_user').attrs('ID').limit(100).selectAsArrayOfValues()
 // usersIDs is array of IDs [1, 2, 3, 4]

@unitybase/ub #

Added #

_5.7.8 _2020-11-20 #

new privateSettings property for entity and attribute added to the JSON schema for entity metadata

_5.7.0 _2020-11-05 #

ub_migration & ub_version entities added

_5.6.8 _2020-11-01 #

App.blobStores.getContentPath - retrieve full path to a file with BLOB content
EE & DE edition: added dstu.iit.strictMode parameter. If true (default) - force server-side signature format to CADES_X_LONG (enable TSP if disabled)

Fixed #

_5.7.7 _2020-11-19 #

UB.UBAbort server side abort error now logged as ERR log level instead of EXC (as should be) for UBServer@5.18.20. For UBServer < 5.18.20 nothing changed and UB.UBAbort will be logged as EXC.

@unitybase/uba #

Added #

_5.4.37 _2020-11-05 #

Nav Shortcuts: Migrations folder with Models versions and Applied files shortcuts

@unitybase/ubcli #

Added #

_5.10.0 _2020-11-23 #

ubcli execSql: -withResult option added - if passed then expect last statement in the batch to be a statement what returns a result, exec it using runSQL and returns a result as JSON

 ubcli execSql -sql 'select * from uba_user' -withResult
 # run a statement and output colored beautified result
 ubcli execSql -sql 'select * from uba_user' -withResult -noLogo | sed -n "/--BEGIN/,/--END/p" | tail -n +2 | head -n -2 | jq -r .

_5.9.8 _2020-11-20 #

ubcli generateNginxCfg - added internal location location /{{sendFileLocationRoot}}/models mdb BLOB store redirect to it a getDocument requests. This fix problem on production deployment when cmodels is located in the /var/opt/...

_5.9.5 _2020-11-14 #

ubcli generateNginxCfg: new parameter -nginxPort - a port for nginx listen directive. If not specified then equal to httpServer.externalURL port (if specified, like http://server.com:8083, of 80/443 for short notation of externalUrl). Use this parameter in 2-proxy configurations.

_5.9.3 _2020-11-10 #

all ubcli command what accept -host parameter now automatically discovers a server URL from ubConfig if -host auto (or UB_HOST=auto env var) is not explicitly defined. This helps to use ubcli in CI script.

_5.9.0 _2020-11-05 #

ubcli execSql: new option -sql script added for execute SQL script from string. Usage sample:

ubcli execSql -sql 
###### ~5.8.0~ ~2020-11-01~
 - new `generateDDL` parameter `-c connectionName`. If passed DDL generator works only for entities for specified connection.
 - new command `ubcli execSql -c connectionName -f path/to/script.sql`.
   Exec a multi-statement SQL script in specified connection without starting a server, so can be used to apply some patches.
   Can be used as a module:
   ```javascript
   const execSql = require('@unitybase/ubcli/lib/execSql')
   execSql({
     connection: 'main',
     file: './myScript.sql',
     optimistic: true
   })

In case UB > 5.18.15 DDL generator will execute result script using @unitybase/ubcli/lib/execSql - split a result file into parts and directly execute SQL statements instead of using runSQL endpoint.

Changed #

_5.9.4 _2020-11-12 #

ubcli generateNgingCfg: a final message for CentOS propose to link config to /etc/nginx/conf.d instead of /etc/nginx/sites-available for Ubuntu

_5.9.3 _2020-11-10 #

ubcli execSql will log first 30 chars of statement for -sql mode instead of -sql word

_5.9.2 _2020-11-08 #

removed many unnecessary logging messages form ubcli tools output.

_5.9.1 _2020-11-08 #

ubcli createStore: minimize console output by notify only for newly created directory path
ubcli execSql mute per-statement exception in case it contains --@optimistic comment somewhere in text. In example below in case table1 already exists exception wil be muted. For table2 - will be raised (--@optimistic not in statement text).

--@optimistic
create table1 ....
create table2...

_5.9.0 _2020-11-05 #

linkStatic command uses realpath for a config to search for node_modules. This allows using linkStatic in product based apps, where config is sym-linked from /opt/unitybase/products.
generateDDL: prevent unnecessary warning for SQLite3 default constraint changing
generateDDL: removed unnecessary logout after generateDDL function is ends. Consider generateDDL always executed as local root (-u root)

_5.8.0 _2020-11-01 #

DDL generator result will join all object annotation (comment on) into one SQL statement - this speed up database generation a lot
DDL generator for Oracle moves sequence incrementation calls into annotation block, so all of them are executed as a single call

Fixed #

_5.9.6 _2020-11-15 #

ubcli migrate - prevent duplicate model insertion into ub_version for Postgres. For Postgres direct query execution using DBConnection.selectParsedAsObject without filed aliases in SQL returns field names in lower case, so select ID, modelName... returns [{id: 1, modelname: "}, ..]). The solution is to specify alias select ID ad "ID", modelName as "modelName" .... - in this case result will be as expected [{ID: 1, modelName: "}, ..]. Notes - for Oracle fields without aliases is UPPERCASE'S, so alias is mandatory for cross-db solutions.

_5.9.1 _2020-11-08 #

ubcli migrate: command line doc added
ubcli linkStatic: skip creation of .entryPoint.js for modules with folder entry-point For example: "main": "./src" in package.json. Such links create a file system loop. In any case they can't be required from client side by systemJS.
if invalid arguments is passed to the ubcli command it exits with exit code 1. This prevents a batch script from further execution in case of invalid command.

_5.9.0 _2020-11-05 #

DDL generator will skip attributes mapped to another existed attribute BEGIN\n import_users.do_import;\n END;--\n delete from aa where 1=0;'

 - `ubcli migrate` - see [Version migrations tutorial](https://unitybase.info/api/server-v5/tutorial-migrations.html)
 - `ubcli initialize` will fill `ub_version` table by versions of the models on the moment of initialization
###### ~5.8.0~ ~2020-11-01~
 - `genSuffixesIndexInitScript` fixed to generate an SQL with valid argument for `dbo.strTails`
 - DDL generator: remove warning from a console in case entity metadata is congruence with the database for connection
# [@unitybase&#x2F;ubm](https:&#x2F;&#x2F;git-pub.intecracy.com&#x2F;unitybase&#x2F;ubjs&#x2F;tree&#x2F;master&#x2F;packages&#x2F;ubm)
#### Fixed
###### ~5.4.26~ ~2020-11-12~
- fix last used scanner and supplement type for UBScan on scanner settings form
###### ~5.4.25~ ~2020-11-10~
- `ubm_desktop-scanerSettings-fm`: fixed correct settings saving and localization [UBDF-12670], [LDOC-1010],
    [LDOC-1041], [LDOC-1011], [LDOC-1015]
# [@unitybase&#x2F;ubq](https:&#x2F;&#x2F;git-pub.intecracy.com&#x2F;unitybase&#x2F;ubjs&#x2F;tree&#x2F;master&#x2F;packages&#x2F;ubq)
#### Added
###### ~5.4.18~ ~2020-11-23~
 - `mailerConfig.fullSSL` parameter added to UBQ partial config - use a TLS tunnel for SMTP. 
   Environment variable - `UB_SMTP_FULL_SSL` (false by default)
    
# [@unitybase&#x2F;ubs](https:&#x2F;&#x2F;git-pub.intecracy.com&#x2F;unitybase&#x2F;ubjs&#x2F;tree&#x2F;master&#x2F;packages&#x2F;ubs)
#### Fixed
###### ~5.4.36~ ~2020-11-19~
 - a client-side report builder `UBReport` uses a `/clientRequire` endpoint instead of `/getDocument` to obtain a report template.
   This fix 404 report template response on production deployment where models can be either inside
   app folder (`/opt/unitybase/apps/appName`) or inside appData folder (`var/opt/unitybase/apps/appName`)

Added #

1.13.20 2020-11-19 #

1.13.19 2020-11-15 #

1.13.18 2020-11-14 #

Changed #

1.13.22 2020-11-23 #

1.13.20 2020-11-19 #

1.13.18 2020-11-14 #

1.13.17 2020-11-10 #

1.13.14 2020-11-01 #

Fixed #

1.13.23 2020-11-25 #

1.13.22 2020-11-23 #

1.13.21 2020-11-20 #

1.13.20 2020-11-19 #

1.13.16 2020-11-08 #

1.13.14 2020-11-01 #

Changed #

5.13.51 2020-11-14 #

Added #

5.4.6 2020-11-15 #

5.4.5 2020-11-14 #

5.4.3 2020-11-10 #

5.4.2 2020-11-08 #

5.4.0 2020-11-05 #

Changed #

5.4.6 2020-11-15 #

5.4.1 2020-11-08 #

5.4.0 2020-11-05 #

Fixed #

5.4.0 2020-11-05 #

Added #

5.5.0 2020-11-15 #

5.4.17 2020-11-14 #

5.4.11 2020-11-01 #

Changed #

5.5.2 2020-11-20 #

5.4.16 2020-11-12 #

Fixed #

5.4.12 2020-11-05 #

Changed #

5.4.43 2020-11-10 #

Removed #

5.4.43 2020-11-10 #

Fixed #

5.4.49 2020-11-23 #

5.4.39 2020-11-01 #

Added #

5.5.11 2020-11-20 #

5.5.9 2020-11-14 #

5.5.8 2020-11-05 #

Changed #

5.5.7 2020-11-01 #

Fixed #

5.5.8 2020-11-05 #

Added #

5.4.0 2020-11-23 #

Changed #

5.4.20 2020-11-25 #

5.4.13 2020-11-10 #

Fixed #

5.4.20 2020-11-25 #

5.4.17 2020-11-19 #

Added #

5.5.30 2020-11-14 #

Added #

5.7.8 2020-11-20 #

5.7.0 2020-11-05 #

5.6.8 2020-11-01 #

Fixed #

5.7.7 2020-11-19 #

Added #

5.4.37 2020-11-05 #

Added #

5.10.0 2020-11-23 #

5.9.8 2020-11-20 #

5.9.5 2020-11-14 #

5.9.3 2020-11-10 #

5.9.0 2020-11-05 #

Changed #

_1.13.20 _2020-11-19 #

_1.13.19 _2020-11-15 #

_1.13.18 _2020-11-14 #

_1.13.22 _2020-11-23 #

_1.13.20 _2020-11-19 #

_1.13.18 _2020-11-14 #

_1.13.17 _2020-11-10 #

_1.13.14 _2020-11-01 #

_1.13.23 _2020-11-25 #

_1.13.22 _2020-11-23 #

_1.13.21 _2020-11-20 #

_1.13.20 _2020-11-19 #

_1.13.16 _2020-11-08 #

_1.13.14 _2020-11-01 #

_5.13.51 _2020-11-14 #

_5.4.6 _2020-11-15 #

_5.4.5 _2020-11-14 #

_5.4.3 _2020-11-10 #

_5.4.2 _2020-11-08 #

_5.4.0 _2020-11-05 #

_5.4.6 _2020-11-15 #

_5.4.1 _2020-11-08 #

_5.4.0 _2020-11-05 #

_5.4.0 _2020-11-05 #

_5.5.0 _2020-11-15 #

_5.4.17 _2020-11-14 #

_5.4.11 _2020-11-01 #

_5.5.2 _2020-11-20 #

_5.4.16 _2020-11-12 #

_5.4.12 _2020-11-05 #

_5.4.43 _2020-11-10 #

_5.4.43 _2020-11-10 #

_5.4.49 _2020-11-23 #

_5.4.39 _2020-11-01 #

_5.5.11 _2020-11-20 #

_5.5.9 _2020-11-14 #

_5.5.8 _2020-11-05 #

_5.5.7 _2020-11-01 #

_5.5.8 _2020-11-05 #

_5.4.0 _2020-11-23 #

_5.4.20 _2020-11-25 #

_5.4.13 _2020-11-10 #

_5.4.20 _2020-11-25 #

_5.4.17 _2020-11-19 #

_5.5.30 _2020-11-14 #

_5.7.8 _2020-11-20 #

_5.7.0 _2020-11-05 #

_5.6.8 _2020-11-01 #

_5.7.7 _2020-11-19 #

_5.4.37 _2020-11-05 #

_5.10.0 _2020-11-23 #

_5.9.8 _2020-11-20 #

_5.9.5 _2020-11-14 #

_5.9.3 _2020-11-10 #

_5.9.0 _2020-11-05 #

_5.9.4 _2020-11-12 #

_5.9.3 _2020-11-10 #

_5.9.2 _2020-11-08 #

_5.9.1 _2020-11-08 #

_5.9.0 _2020-11-05 #

_5.8.0 _2020-11-01 #

_5.9.6 _2020-11-15 #

_5.9.1 _2020-11-08 #

_5.9.0 _2020-11-05 #