186 KiB

Raw Permalink Blame History

6.8.2 (2024-05-03)

Bug Fixes

dc_request_logs option feature (93758ef)
release process (c0dc919)

6.8.1 (2024-05-02)

Bug Fixes

hide approve button when table revertable (ec0f539)

6.8.0 (2024-05-02)

Bug Fixes

ci sheet lib, submit message auto focus (c5e4650)
clarity: new version style issues (8c7de5a)
cypress tests (3dd85cc)
ensuring that only restorable versions are restorable (a402856)
ensuring version history only includes loaded versions (51ebd25)
final testing on restore feature (297a84d)
issue with multiple adds/deletes, #84 (904ca30)
load_ref var (aaad9f7)
removing alerts dummy data, closes #93 (eba21e9)
restore table version improvement (549f357)
sas: viewer versions fix (c6595c1)
stage and approve buttons renaming (ef81e33)
supporting SCD2 data reversions (fa8396f)
table info modal, versions - column names (801c8c6)
updates: angular, clarity, resolved legacy-peer-deps (c60dd65)

Features

backend to show in getchangeinfo whether a user is allowed to restore (8769841)
list versions of target tables (backend) (f8a14d4)
restore (604c2e7)
SAS services & tests for RESTORE, #84 (9ad7ae4)
staging page, restore buttons (02a8a1c)
table metadata modal, versions tab (and link) (b27fea5)
versions: getting list of versions (plus test) (8003da9)

6.7.0 (2024-04-01)

Features

numeric values in hot dropdown aligned right (9635626)

6.6.4 (2024-04-01)

Bug Fixes

ordering SOFTSELECT numerically in dropdown (f522038), closes #85
reverting col (fbbcf90)
typo (31d4e5c)

6.6.3 (2024-02-26)

Bug Fixes

allow empty clause value when NE or CONTAINS (432450a)

6.6.2 (2024-02-22)

Bug Fixes

excel with commas getting wrapped in quotes (3860134)

6.6.1 (2024-02-19)

Bug Fixes

client: bumped @sasjs/adapter with fixed redirected login (eb1c09d)

6.6.0 (2024-02-12)

Bug Fixes

adjust the col numbers in extracted data (cff5989)

Features

extra table metadata for #75 (837821f)
show dsnote on hover title (6565834)

6.5.2 (2024-02-06)

Bug Fixes

ordering mpe_selectbox data by the data values after selectbox_order (2b54034)

6.5.1 (2024-02-02)

Bug Fixes

ensuring submitter email can be pulled from mpe_emails (eac0104)

6.5.0 (2024-01-26)

Features

filtering by reference to Variables as well as Values (6eb1aa8)

6.4.0 (2024-01-24)

Bug Fixes

add dcLib to globals (5d93346)
add service to get xlmap rules and fixed interface name (9ffa30a)
increasing length of mpe_excel_map cols to (2d4d068)
providing info on mapids to FE (fd94945)
removing tables from EDIT menu that are in xlmaps (9550ae4)
removing XLMAP_TARGETLIBDS from mpe_xlmaps_rules table (93702c6)
renaming TABLE macvar to LOAD_REF in postdata.sas (01915a2)
reverting xlmap in getdata change (2d6e747)
update edit tab to load (516e5a2)

Features

adding ability to define the target table for excel maps (c86fba9)
adding ismap attribute to getdata response (and fixing test) (2702bb3)
Complex Excel Uploads (cf19381), closes #69
Create Tables / Files dropdown under load tab (b473b19)
display list of maps in sidebar (5aec024)
implemented the logic for xlmap component (50696bb)
model changes for #69 (271543a)
new getxlmaps service to return rules for a particular xlmap_id (56264ec)
validating the excel map after stage (adding load-ref) (a485c3b)

6.3.1 (2024-01-01)

Bug Fixes

enabling excel uploads to tables with retained keys, also adding more validation to MPE_TABLES updates (3efccc4)

6.3.0 (2023-12-04)

Features

viewer row handle (dadac4f)

6.2.8 (2023-12-04)

Bug Fixes

bumping sasjs/core to fix mp_loadformat issue (a1d308e)
new logic for -fc suffix. Closes #63 (5579db0)

6.2.7 (2023-11-09)

Bug Fixes

audit: updated crypto-js (hashing rows in dynamic cell validation) (a7aa42a)
missing dependency and avoiding label length limit issue (91f128c)

6.2.6 (2023-10-18)

Bug Fixes

bumping core to address mm_assigndirectlib issue (c27cdab)

6.2.5 (2023-10-17)

Bug Fixes

enabling AUTHDOMAIN in MM_ASSIGNDIRECTLIB (008b45a)

6.2.4 (2023-10-16)

Bug Fixes

Enable display of metadata-only tables. Closes #56 (f3e82b4)

6.2.3 (2023-10-12)

Bug Fixes

bumping core library to avoid non-ascii char in mp_validatecols.sas. #50 (11b06f6)
removing copyright symbol from mpe_alerts macro. #50 (adb7eb7)

6.2.2 (2023-10-09)

Bug Fixes

updated SheetJS (crypto) to the latest (8bd0dd2)

6.2.1 (2023-10-09)

Bug Fixes

approve, history and submit pages grouped in review module (e056ece)
closes #39 upcase issue in MPE_SECURITY (a00d31c)
handsontable v13 (6f482ec)
latest adapter (5e30dc0)
sasjs/cli and sasjs/core updated to the latest (8571e01)
updating editors/stagedata to address issues in particular viya configurations as described in issue #33 (94ab949)
updating logic for REPLACE loadtype (1f2ce55)

6.2.0 (2023-08-24)

Bug Fixes

re-enabling full REPLACE uploads (08e39c4)

Features

support for European numeric formats (e48e47b)

6.1.0 (2023-07-25)

Bug Fixes

missing mf_existds dependency in bitemporal_dataloader (5ce1701)
reducing audit data volumes. Closes #4 (54fe701)
release script, excel upload duplicate primary keys, cypress fix (2f79487)

Features

full format deletion, closes #2 (8dc40bd)

Changelog

All notable changes to this project will be documented in this file. See commit-and-tag-version for commit guidelines.

6.0.0 (2023-06-27)

⚠ BREAKING CHANGES

The updated model and behaviour of FORMATS is the breaking change in this release! (but not this commit)
removed gitpod.yml and moved CONTRIBUTING.md to root directory (eb3e1be)

Features

adding isadmin to startupservice. Relates to #460 (70a755c)
admin page (642b7d0)
angular 16 (9805c09)
autocomplete load more (f3df479)
autocomplete load more (3160be4)
custom dropdown load more (0a576fd)
handsontable 12.4.0 (17d1c23)
history paging (load more) (d4381da)
licence in a file (2cc59ff)
licensing refactor - free tier version (a418cd6)
new licence service with encoded features (fa8722f)
showing PK in VIEW menu for format catalogs (fc64832)
support for INFORMATS - also multilabel and notsorted formats (34af333)
viya api explorer (4c69487)

Bug Fixes

adapter bump (72843c2)
adapter bump (30da29f)
added component to add link to support email (234a43d)
added copy without headers (32d5a4f)
adding lock check on mpe_audit before dataload (6ad5d61)
adding nobs to gethistory (2c15abb)
angular bump 15.2.9 (c7e21b9)
angular-eslint bump 15.2.1 (305de83)
approve: bumping core to prevent unlocks when tables are not locked (issue #339 in core library) (afc0517)
approve: When uploading ONLY deletes, ensure that records are added to the mpe_audit table (2d404c0)
backend for getcolvals extra rows (4f50654)
bitemporal load support in audit table (a63f7de)
bump typescript 4.9.5 (b0e0dfa)
d3 graphviz updated to fix vulnerabilities (28b27ce)
default hot licence, editor rows limit notice on the bottom, showed only when more then limit submitted (0db976a)
display special missings in VIEW mode (8d1bfb5)
enabling configurable history at backend in approvers/gethistory. Addresses #257 and (055a7ff), closes #477
enabling refresh of single library when invalid libraries are present (9545ac7)
filter on download in history removed, rows and cols number on viewer and editor (bab3dfa)
firefox dropdown not sticking, load more is note present if nothing to load (9c78d67)
index html inline style, sas9 metadata type (8226413)
inserting row above/below was scrolling to the bottom (c30e361)
licence expiration blocks the app (it is now reverted to free tier version) (389a05b)
licence expired blocking app (in progress) (4601683)
licence expired error, added expiry date (2c20c8d)
load more in history to appear only when paging available (8851ba7)
making HIST configurable with MPE_CONFIG (215fa87)
missing licence should not show error (5a653ae)
new cypress config, added cypress reporter in results after test run (8ea3ab8)
removed ngx-markdown (cda97fc)
removed ngx-markdown, added marked package, used raw (43cd643)
submit table request error handling (b8395be)
submitted page linking (c18519e)
submitted_dttm type fix and distinct for non admin gethistory (ef3fa67)
supporting additional date formats. Closes #484 (38d8e10)
typo in DDL for MPE_SUBMIT (f6ca05d)
unlocking audit table (2a6884d)
upcase issue (ccd9c4e)
update to angular v15 (90a143f)
updated @angular-eslint (080b281)
users allowed with demo key (6a0fce8)
viewer rows limit notice position (5ac227b)
viya profile picture url was broken when client at different domain (a42cfc0)

5.3.0 (2023-02-23)

Features

added file drop and file select directives (3d29908)
column ordering stored to URL (63f7354)
config in sasjs html tag (4c0f6ed)
editor - viewboxes added (860a7e9)
viewboxes: edit table in new tab (8321263)
viewboxes: full table search table (e86b53a)
viewboxes: integration with viewer, modularization (507f4ae)
viewboxes: snap to grid (940634a)
viewboxes: table filtering (in progress) (2029a85)

Bug Fixes

abort issue on SAS with ms_webout etc (05d79cb)
adapter config in index.html can be ommited now (0058eb8)
adapter execute script breaking change (fd98a2e)
adapter updated (414bf8d)
approve details too many changes JS error (2efb49e)
bump prettier (0ab0e84)
bumping core & cli (c7ce70d)
col lineage errors (not respecting max_depth) (2fdc462)
col lineage hanging issue (da6536e)
dynamic mocks for licencing tests (f967058)
filtering and licence testing, dynamic mocks (e309029)
improved changed rows notice position (8c521c8)
remove ng2-file-uploader (4170546)
rename label (dot depth) (57fa379)
update handsontable to 12.2.0 (a438671)
viewbox libraries paging (4039973)
viewboxes: independent filter caching (7f78ef0)
viewboxes: main table filtering title, z index (0801b5c)
viewboxes: url and keyboard selecting in tree double select (80942cb)

5.2.0 (2022-11-15)

Features

limit lineage depth button (cc901f1)

Bug Fixes

deps update (8c9a14f)
dummy js file to force admin folder in demo.datacontroller.io (07f3194)
editor and viewer responsiveness, logo smaller (e44ff33)
enable ampersands in library & table lineage (078acf3)
libinfo alignment (c508f83)
licensing error details (99bb81a)
licensing error params (9c4e1e6)
lineage missmatch info not breaking error (029fa9f)
lineage sidebar matching and error handling (e26fb0c)
lineage table 'nolib' fix (b74f0e0)
max_depth not working on large lineage graphs (1e066f1)
missing PK fields in dictionary table (d40835b)
viewer lib info styling on smaller screens (c2c4424)

5.1.0 (2022-09-02)

Features

adding dsmeta info from mp_dsmeta macro (2ac6659)
adding sasdoc generation for all SAS Platforms (56662ce)
dsmeta added to view and edit (24e35dd)
edit record - forward backwards changing records (b28b8f8)
initial contents for https://code.datacontroller.io (fdf8808)
library linking (fa4aba8)
new libinfo backend service (0618e63)
refreshlib feature (and tests) backend (3980774)
viewer library info page (01b1148)

Bug Fixes

adding libinfo in response from refreshlibinfo (8810b2e)
angular configuration fix (a67e12e)
avoid warning for empty library in viewtables (abed1a9)
bump core to fix formats with incorrect length (211f5dc)
bumping core (6cb3216)
cleanup, editor modularized, angualr 14 update (558ea94)
css issues (e0f6f33)
current row start from 1 (05267e3)
custom autocomplete input component, fixed qutes around date and time in filtering (985c45b)
date time filtering with quotes (78babd3)
demo limits (97ee3f7)
dynamic cell validation suppress ABORT modals (951a0d5)
dynamically obtaining serverContext when running makedata on SAS 9 (22dec2d)
edit record separate component, modulization routihng (0e2a57b)
editor multiple filterings (20bb5cd)
empty library no tables, approve details screen break dots (54ca1ef)
enabling consistent formats in the generated DIFF screen (80ec246)
filtering IN did not append quotes (62256a6)
filtering Input typing, editor filtering quotes, update licence key placing (1f2a516)
filtering logic operator undefined (5c8e951)
filtering OR not working (98c43a5)
going to libinfo from table view (13c4add)
half way fixed inline styles (2f85090)
hardselect_hook on numeric was not strict (abdea54)
images in dist/images folder (d187c5d)
incorrect validation on format catalog load type (b095926)
libraries not refreshing on SAS 9 (77e33df)
licence note (39d04bd)
mp_lockanytable error in rejecction (195a350)
number of changed rows limit (55ab7cf)
pasting NaN issue (0b1ad3a)
performance improvements with latest mp_jsonout (5251f24)
requests modal ux, filtering reset kept old values (dc866aa)
softselect dropdown sticking (b51afbb)
typing in filtering variable call only on select from dropdown (cfe9bf6)
validations failing in MPE_TABLES for column values due to initialisation of CLS_XX variables (d65b609)
validations: ensure LOADTYPE on MPE_TABLES has correct values (536b176)
viya 4 compatibility (9bb4b88)
when library info refreshed it was not stored (ea50b31)
when paste and edit record confirmation type conversion and special missing handling (a352608)
when pasting into grid types gets lost (5e75a39)

5.0.0 (2022-07-11)

⚠ BREAKING CHANGES

mpe_approvals is now dropped and replaced by MPE_SUBMIT, which is unique on table_id.

Features

added demo config (ea9cef0)
additional tables added to export process. Fixed a bug when staged data contains only deletions. Also added CLS rules to COLS table in getdata response. (66749f1)
backend users (to be continued) (ba487ba)
Column Level Security (7651fb8)
Column level securty EDITOR (fdfe333)
configurable audit (plus test fixes) (8673d37)
demo max rows (1b97255)
dynamic validation features in edit record modal (6740a5b)
enabling backend primary key columns on VIEW tables (1db832c)
enabling download as markdown feature (9032cd1)
getgroups (6247d6e)
hardselect in record modal - numeric (b88e622)
new deploy process for SAS 9 (15e4936)
no key demo mode (f76a0e7)
record modal dynamic cell validation started (e537958)
refactored DB for submit & approve (a58151f)
restrict EDIT RECORD (0e30649)
restrict editrecord (5c8f013)
sas9 configurator init (40b70ab)
sasjs configurator (f823276)
sasjs configurator - on deploy page (6511c19)
sasjs server - redirect to configurator if exits (eb054cd)
sasjs/server appstream compatibility - see server target (cf17c90)
show abort modal separate then show info modal (033be9a)
unlocking password protected excel (ea93601)

Bug Fixes

abort modal download log butto (ca4631e)
adapter bump and viya usernav rename (e98ae0e)
added open requests modal on sasjs abort (ea78672)
adding makedataserver.json file (0fa8680)
adding missing statement for CSV uploads (a8dc48f)
adding mp_init back (dba9d7c)
adding submit reason to approve pages (cd903e3)
ading dc-admin as default admin group (fe5866c)
alias (797e137)
approve details - formatted default on (16e675c)
assets fix, logo (667246f)
avoiding error in mpe_filtermaster (read/write same dest) (2f6a33e)
badly placed comma (182a6b0)
bum core (aa29837)
bump core and avoid mpe_groups warning (bec7149)
bump core, test setup (d0efc3c)
bumping core (5c0b7a9)
bumping core (3c28c41)
bumping core and improving makedata response on SAS 9 (79ab3b8)
bumping core, missing comma in deploy ddl (2114708)
bumping core, removing licence key (0a3e381)
case when statement (14304a0)
char limit (d9af43a)
checking makedata (5f64079)
clarity csp issues (2ee3ee7)
cls issues revisit (35b5fce)
config (1797964)
configurator added group description and progress bar (b72d27a)
configurator fixing (10b3b60)
configurator groups dropdown, making json request viya specific (8b1c2c9)
configurator html styling (9d17ea7)
configurator redirect - using new api endpoint (list folder content) (e32edbf)
core bump (3a29271)
csp issues cwb, /deploy page force, bump up deps (f8b8ceb)
CSV upload issue (69f65de)
cypress testing (3f29f9b)
dc_dttmfmt macro usage (thanks to compatibility issue on M3 proc sql (65aa595)
default appLoc (5507841)
demo limitations and file upload drop area (bc4fb1b)
demo limits refactored - improved (b80817c)
demoConfig rows allowed handling (5254a6e)
deploy component refactor (2d28d5d)
deploy page autodeploy button to upload custom json file (bee9274)
deploy sas9 auto redirect to configurator (f6598d2)
deprecated images as base64 - since csp can block them (6c54100)
doc updates (aa36de3)
drag n drop file fullscreen (90f98c2)
EDIT record (9987e72)
empty tables on SAS 9 (4259866)
enabling deletes (e5bbaa8)
excel upload NAN (7c0dfda)
explicit cols (6e28174)
filter values changed 200 limt to 2k (ae64bb3)
filtering added clear button (981456b)
filtering dropdowns showing formatted values and inputting unformatted (beec1a2)
filtering selecting special missing from dropdown (d8fde39)
finishing up mpe_review + mpe_submit table refactor (276669c)
fixing specs (829a42c)
frontend (3694f16)
frontend fix for startup service, and backend libref (6dc06b8)
generic macro for hooks (0fe00fd)
group rename (514146e)
hide in edit mode (fc55fa9)
history tab with submit reason (592078f)
hook scripts and desktop groups (271987a)
hotTable height when add record button missing (1df4bac)
images to base64 (1e1114b)
issue with isSpecialMissing function, sufficient spec files removed (39412df)
legacy peer deps in .npmrc (14d5f2f)
length in meta lineage (f1a262c)
lengths (606611e)
lineage bug (be64516)
link and mpeinit (e4b06c2)
lint (af15f94)
lint and more approve group removal (4079f57)
lint and naming of sasjs adapter (740d720)
logout in configurator, filtering IN special missing (43dc4d4)
makedata on viya (b4c7970)
making tests work (5bcb955)
making time format configurable (202d45e)
merge development (5d0057d)
merge development (434943c)
merging changes (fbe5e14)
merging spec and cols (7d6bb90)
model updates (31cf930)
more fixes | (ddf94d5)
mp_include (d518367)
mpe_tables hook script (2ba8a37)
newline (285f017)
no data rows excel upload (a624f4e)
nonote2err switch (904bcdb)
optional userid as input (33a6925)
performance boost (4abec25)
prettier (f3868f0)
preventing CLS being applied to admin users (a414492)
primary key always only readonly when cls active (33ab65b)
quoting (7ca2f97)
redirect streaming app (9e795d0)
reduce row limit in VIEW for performance (to 250 from 1000) (9a28d6f)
refactoring deploy component (4f7a495)
reload issue - first time loading screen was stuck (80c5af8)
removed inline script, sasjsConfig as html attributes (fc6fb22)
removed sasjs sufficient elements from usernav (1176655)
requests modal fixes (6c720a8)
requests modal undefined handling (aca8bfb)
sajs server mode - login (5f589e5)
sas9 and user fixes: (b42b47f)
sas9 configurator fixes (4c83a34)
sasjs configurator finish - get groups request (51df692)
sasjs server fixes (dd1fe5f)
sasjs server fixes and sasjsconfig update (b43e5e5)
sasjs server url for downloads (083bca1)
sasjs serverType - usernav (aeca2a6)
save password prompt (49f05b2)
sending favicon as base64 (b6a34ed)
server favicon (5afd806)
test for OS at backend (c062b00)
testing updates (8b16282)
tests and bumping core (336f54a)
timestamping issues (082f0cd)
tree navigation search UX (a17f253)
update to improve user experience with sorted data (8cb1b5b)
updating licence key and filter clause (c87c3d8)
usergroups updates (83cd292)
username / group updates (229886d)
usernav linking and group name (02c8f60)
users & groups on sasjs (8886905)
using conditional logic on mpe_refreshtables (f71f18f)
using mf_fmtdttm() (34ad201)
using usernav instead of viya_users (3d50bbd)
UX improvements, cols, spec cleanup, dropdown empty record issue (9a7c3e9)
viewdata for just meta only definition (65ae495)
viewer error handling (3c54689)
viewer PK coloring, search missing when no data (f10b8c7)
viewer reset filter (0ac5972)
when file upload error (csv) file is discarded (7653fff)
wps compatibilities (79c5223)
wps fix for mpeterm() (2473364)
wps updates (4c85101)

4.2.2 (2022-03-21)

Bug Fixes

friendly labels on sas 9 invalid view libs (and other ci/cid updates) (9014f28)
sajs server (0353ba1)

4.2.1 (2022-03-21)

Bug Fixes

friendly labels on sas 9 invalid view libs (and other ci/cid updates) (9014f28)
sajs server (0353ba1)

4.2.0 (2022-03-17)

Features

requests modal dowanlod logs (bd9e759)

Bug Fixes

bump core (a664573)
config (fecdaee)
filtering pickers checkbox (8327421)
getting sas 9 tests to work (d83b22d)
missmatch fix (b33b520)
scss (443c3d7)
validator length, abort modal MAC (c6b3d1f)

4.1.0 (2022-03-15)

Features

server configurator (df6cc6c)

Bug Fixes

audit service issues (c6e1452)
bump core and sasjs/server makedata update (590710b)
refactor sas 9 deploy (4458385)
sas and app services timing (7828d04)
sasjs server (c999716)
sasjs/server updates (2cd0135)
update db for constraint support (cc1e171)
updates to deploy process (f22556c)

4.0.1 (2022-03-10)

Bug Fixes

approve details UI (4e058e9)
bumping core (70b5359)
missings validation (0745486)
sas tests (30b4b48)
special missing period prepend validation, replacing period in numeric with null (9de4197)
testing issues and ability to upload excel for formats (0e84e75)
tests etc (435452b)
validation for numeric length (0f9614b)

4.0.0 (2022-03-03)

⚠ BREAKING CHANGES

The filter_text variable is now dropped from mpe_filteranytable

Features

adding mp_init to ensure strict compatibilities. Also removing the word 'error' for better log scanning. (f539474)
approve details - formatted values (2d53b46)
col info in header menu dropdown, added sheetjs pro tarball backup (6ed88f8)
dc-validator module | shared components refactor (271cc25)
excel upload delete column apply (d908126)
format mods! (6c6f3c5)
formats catalogs (5e233cf)
formatted values for GET_DIFFS (backend). Relates to #398 (585ddb7)
mpe_audit table now updated with every load (b48a762)
primary key headers different color (f7aa07c)
sasjs/server support (63c9dd4)
uploading excel with delete column (4b273e5)
viewer - column context details (0bf4c48)

Bug Fixes

abort modal refactor (82a29a3)
adding .SSS to datetime and time formats (af453e8)
adding catalog support for validatefilter and corresponding test (8104fd9)
addressing comments (111473f)
addressing yurys comments (8a84fe7)
angular build (f6c850c)
angular new config structure, fixing ts lint errors (997e8b8)
approve details abort modal refactor (8aec836)
approve details screen more compact (05bfa52)
changelog (14b369a)
conflicts: (5622d01)
dropdown filtering UX optimization (bf75a4a)
dwp issues - bolt icon on viewer, routing user back to viewer issue (53e8b64)
enabling formats on getdata (d1ae3df)
excel file delete column parsing (1d1635d)
executeValidator generic function, fixed tests (1bd76a1)
filtering datetime decimals cut, getcolvals types (bf8d059)
finally getting decimals to work both for time and timestamp to 5dp (6062444)
format support for getddl service (5f5a224)
format support in getrawdata service (993e208)
format-cat entry (2c0ebf5)
formats: adding formats to viewdata service (and fixing test issues) (d3ea3f0)
hot assert error appearing (blocking the app) (c03b5fc)
hot dynamic validation adding source requires adding cell editor of autocomplete (263fe95)
hot freeze issue (assertion error) (c91aa0c)
hot height (6c81769)
hot, deploy abort modal refactor (536e489)
include decimal part for datetime and time variables (9ff05ce)
initialised variables fixes (ad35a49)
leading char support (and test) (306bc42)
licensing abort modal refactor (cd127d7)
licensing with multiple syssite ids (cb31af0)
macvar in buildinit and getting delete-folder script to work from local (3280d8b)
make Lato font bundled (4f20403)
moving the checklock macros to the core library (f332bd5)
NodeJS issue (5e282e8)
numeric validation length in bytes (cd833e9)
paths (eb06998)
postdata (8d9d141)
record modal: dc validator refactor implementation (5e25805)
refactoring retained key generation, migrating core component to sasjs/core library (8a74311)
remove processed_dttm from result (2117727)
removing processed_dttm from validatefilter (e848c3b)
removing unnecessary colvals col, fixing unfiltered rawdata download, showing batch code on parallel approve abort (b736861)
renaming hot into editor component (43178e6)
replacing Macro People with 4GL Apps (c43225b)
sas9 deploy work (b822a14)
sasjs bumps (0194cca)
sasjsAbort refactor: viewer component (290a5d0)
servertype SASJS (60f733c)
special missing support (4e739ee)
strict mode enablement (f226fc2)
supporting fmt catalog in getcolvals (92d6e8a)
surrounded data with all empty cells (e2b3a76)
terms abort modal refactor (b7ae9f8)
test fixed, dc validator utils (f163d75)
test setup for viewtables with format catalog (4080459)
types fixing (3cfcb2e)
uninitialised variable (65c1f51)
updates following strict mode (94fa05d)
updating analytium email addresses to data controller (a2f2783)
updating tests, bumping core, new postedit process to check MPE_VALIDATIONS (a7d49b8)
upgrading the filter process to work with mp_filtestore.sas (354ecfa)
validation hook append to cell source if any (d2a22b6)
validations, undefined,null (6fe5f73)
validator - editor implementation (782e6d0)
validator check (3fe5b32)
validator: yury's suggestions (eae158d)
versioning structure, moved to root (e9da745)
viewer errors (dd8b115)
viewer hot error in console (e5775cf)
wording (caa372f)

3.14.0 (2021-12-08)

Features

sasjs/server support (63c9dd4)

Bug Fixes

changelog (14b369a)
licensing with multiple syssite ids (cb31af0)
moving the checklock macros to the core library (f332bd5)
paths (eb06998)
sas9 deploy work (b822a14)
servertype SASJS (60f733c)
versioning structure, moved to root (e9da745)

3.13.3 (2021-11-10)

Bug Fixes

adapter login error in console (06b8842)
adding comments in index.html, ensuring hard stop on table lock (bebd9d5)
cell validation - arrows not appearing on render (7e879b9)
cell validation - empty cell triggers forced values (540297d)
cell validation - force values are set on all rows (1b0c31c)
closes #373 (209130d)
display modal with sheet name where the data is found when doing excel upload (351d511)
duplicate ALL values removal (fdc5b6f)
excel fail with missing first row (e508a54)
rejection reason not appearing in the email (0476090)
upload excel faster validation (316551b)
upload validation speed up (4277fef)

3.13.2 (2021-09-27)

Features

licencing - multiple site_id values support (8e98dd5)

Bug Fixes

better UX when doing quick reject (0e35427)
deprecating mpe-getroot() (a6bc6e7)
excel empty numerics parsed incorectly (0d0e3eb)
invalid casting (e086fb3)
switching to sasjs/core version of mp_getcols (616fc80)
viewer - handsontable onDestroy of undefined error (7832e0e)

3.13.1 (2021-09-06)

Features

dynamic cell validation force value flag (016377f)
enabling force flag at backend (1d9ab78)
hot.batch() improvement, loading spinner on error stop and presenting exclamation mark (66d6c6b)

Bug Fixes

adding test trigger (9391796)
enabling mp_include for error handling, and adding force flag on mpe_tables validation (f1163e1)
enabling native PG for key_seq incrementer (f81505f)
excel with additional columns issue (b7d017d)
filter message should be removed when excel is uploaded (3350da9)
filter RK bug (b61c93d)
handsontable instance warnings, improved singleton when calling hot (faccc11)
more PG tests (48836a0)
pg direct - working branch (0d46dd9)
PG updates (f41eefd)
timestamps for PG compatibility (aa321c2)
using db compatible date system (95a564c)
when no changes on approval screen state as such (55a24db)

3.13.0 (2021-08-25)

Features

backend for dynamic extended values, docs updated and tests written. Available on MPE_TABLES.DSN column (10fe4ba)
date picker dropdown with values (2be1ad7)
dynamic cell validation loading spinner (e415476)
excel upload stater (6aa35e1)
logger service, displaying console log when debug is on (35992e0)
upload excel states and remaining time calculation (7529d40)
in progress: extended values cell validation (e44dc9a)
row headers added (55d5b24)
k8s: dockerized frontend app (5c9176c)
k8s: set up k8s node with dcfront image (b234b28)
server: enabled typeScript (2ac724e)
server: initial commit (8f2a0a5)
added test case to test the validity of uploaded values in xls extension (7f7909b)
adding datalist dropdown to time and date picker (caaf5f9)

Bug Fixes

adding demo key and fixing build process (9298ef0)
agree checkbox flow, open table from tree stability, library to open in cypress json (1a3dcf2)
backend updates (1b3a61a)
batch script updates, adding mpe_users to mpe_tables (b5659d4)
bumping core (6034d12)
buttons focus outline remove (c0348e3)
created and implemented sheetInfo interface (7408ad7)
date picker datalist arrow overlap with calendar. On loading screen abort modal not visible (f426536)
decoding licence key on http faling with invalid base64 (5220cdb)
der touristik issue with error on table due to DQ check (641a15c)
displaying the error message that comes in response from adapter (43e5e31)
dynamic cell validation on numeric cells, numeric dropdown with sofselect issues (4c8a68a)
empty sheets triggering error (update range function) (2caa513)
enable support for backend rls checks (0422c39)
enabling hook when submitting RLS and adding query object to VIEWdata response (6023e8b)
enabling post edit hook for mpe_validations to check each table query seperately (3906316)
excel finding data in file issue (7d17685)
excel tests fixing (a27066e)
excel upload with missing, duplicate and blank columns (038b32f)
excel with missingg first row upload fail (839f34a)
handle the string which contains apostrophe (fdde83f)
hardselect_hook prevent invalid submit (127ff70)
history download context passed (7fc3637)
immediately remove approve list item after clicking on reject button (5004988)
incorrect group logic (0be9e18)
issue with filters in different tables being combined (51d3c98)
lineage double request (5a78a30)
made some attributes optional (9879633)
merge conflict (957f4f6)
message typo (b231651)
metadata aligment and loading spinner alignment (385da0e)
metadata object not sending request (a616a42)
metanav search issue (e6a727a)
new clarity styling issues (50c9a23)
nobs value incorrect in filtered view on VIEW table (23fa2ce)
non picker input dropdown not visible (4de8726)
not null validations not applied (eccc28e)
numeric column freeze when put char value (d2cebc5)
pass debug parameter in upload file request when deug mode is enabled (ab8ab28)
postgres compatibility (700fa74)
Primary key value lost when uploading excel file fixed (0672a55)
reproduce filter for viewer component (6edb0aa)
RLS lib assign (6b274eb)
sas fixes (0f4a1bb)
updates for PG compatibility and to improve logging in case of hard exit (6f43756)
updating test and config to use correct context, also updating tests so that they actually run with the designated context (96aadb1)
validatefilter not handling sasjsAbort (ee444bb)
restructured repository (b0accc5)
restructured repository (64530a6)
ci: fixed merge request CI step (687785c)
CI: fixed gitlab-ci (84bc6ba)
k8s: fixed ingress service (6a71df7)
timeout set globally (79c0250)
validation for numeric cells (6b9dba5)
when user open filter url show him filter clauses in filter dialog box (b800672)

3.12.0 (2021-05-11)

Features

adding dynamic filter query to public/getcolvals service along with corresponding tests (and updates to test config) (df86c39)
backend logic for formula validation (7d17aca)
check for invalid clauses when adding new group clause (085ede6)
checkbox values moved in modal. fix: selecting IN operator before getValues is finished did not populate values. (831f6b7)
creating dynamic where clause string and passing (2724383)
getdynamiccolvals service (and test) (c5a8df8)
getdynamiccolvals v0 (44be1de)
lineage depth level pick (46e4601)
max depth lineage limit (569a560)
mpe_filtermaster macro to handle all filter generation (and corresponding tests) (ddf88f0)
new validatefilter service (replaces whereclausevalidator) (909ba02)
reset filter button, improved datalist elements (bd42094)
Row Level Security (and test) (5e0fe2f)
where clause check on adding new (82410d2)
while uploding EXCEL parse formulas and formatted values (5008010)

Bug Fixes

0 rows on filter, no changes modal improved (0318d86)
add record edits newly added row (91328ea)
adding default hook for mpe_security (d282fd2)
adding header to getdynamiccolvals (c8f054a)
adding outds so can send back to frontend (6151391)
adding stub for service (0a32bfe)
adding tests and new macro for fetching test response (0fd4e35)
app break on lineage error when debug off (f4f1fae)
appLoc check support for old adapter (4d6fc29)
appLoc check, with adapter function (2fa0de9)
approver list for ALL listings (54a4fdf)
auto deploy close modal button (3657ae1)
bumping adapter and closing #305 (2f3d49c)
bumping sasjs/core (3b0896d)
changes required by axios-adapter (eac1bb5)
check to ensure table exists. Closes #223 (ee5b21a)
conflicts: (92d6b4d)
datalist improving UX (show all values on click) (99f298d)
dependencies (42f23d4)
deploy page (0c1c312)
double click opens empty dropdown (c751295)
download audit file error (8a92657)
dynamic filtering is true by default (47d6c37)
dynamic where clause was sending null values (aad3d94)
editor breaks if submit service fails (eef29ba)
editor reset filter not working (9b2e5a9)
enabling excel export for non PC files sites, also updating tests (35a36e7)
enabling filtering for getdata service, plus a test, plus fixes to make the test work (69c6dde)
enabling uploads in excel for non admins with ALL security settings (46a083a)
ensuring selectbox order is honoured. closes #283 (124c1d3)
error on compilation (574d1ca)
extending viz memory, added rendering spinner, added download png and svg buttons in the modal (d6f674f)
filter text removeal (08bcc4a)
filter_pk numeric (e5a7728)
filter_pk numeric (f0a1d7b)
filtering datetime wrong time on some months (00c2d4e)
filterquery for numeric and string (29d4967)
filterTable params fixed for getColVal request (f6b43e2)
fixing dates on fronted. REquires an adapter update. (544124b)
getcolvals breaking filtering (086cd64)
getting tests to (finally) work (caeea9a)
getting viewdata to work (d78cfa5)
http key support (a166665)
I ran npm run format:fix (7c5814f)
improved progress bar, passing dynamic clause object to server (c0a37a4)
large lineage handling improved UX (316af47)
last minute fixes (4399118)
last minute updates (d58dc0a)
line length (15e596a)
lineage not rendering issue (ba932f4)
lint fixes (fa6fbcc)
max_depth (b90efe0)
merge (3f4db37)
merged cells excel upload fails (df5e6d7)
migration DDL (63b7dd9)
minval validation broken (ce1db82)
missing changes and improvements (d463d32)
more debugging, closes #282 (eb26f89)
moving meta_mapper into designated folder, so it can now be overridden by the end user (595f08d)
moving tests into same folders as services (19ada72)
mpe_config issues (315ed39)
mpeinit (b541f58)
mpeinit failure on sas 9 configurator (9ace8e1)
one clause in group subgroup logic is undefined (7cca83b)
ran npm run format:fix (eda5785)
reducing rowcount to 100 for performance, also updating sasjs doc (a612d33)
removed services from appLoc (4d390df)
removing FILTER_JSON (4e7b549)
removing nested macro (2641e41)
removing nested macros (70f25d2)
replaced NOT EQUAL with NE (696348a)
RLS hook, max-depth, mor eRLS values (d2e9fa3)
sanitising inputs (04855b9)
sasjs/core bump (2b57031)
shortening token (49f17e7)
small performance tweak in filtering (672d51c)
soft select in edit modal is working now (98fa2d9)
sql update for history (e1a3511)
styling issues (720adb2)
table max depth (352e2c0)
table on click scroll into view (87f72be)
test (and fix) for etlsource, upcasing returned cols & tables (77ddff5)
tests (8c0eb1b)
tests and extra validations routines (3dbfad8)
tidy up sasjsconfig.json (4ed469b)
tree on generating graph scrolls to top (ccaac6f)
typo and fixes (b258426)
uknown error to SAS Service Error (564e893)
updated upload excel with formula test to check parsed values (db58aa0)
updates for viya testing (637c1e1)
updates to make sasjs lint work (fc5fe54)
updating dc tests for SAS 9 with macro (f42012f)
url issues in deployment (f6f933d)
viya users limit (d6961f4)
warning on large dot files, hot dropdown style fix (eb17798)

3.11.0 (2021-02-14)

Features

Adding DC_LOCALE option - will override locale when set to anything other than SYSTEM. Closes #237 (419f022)
dragging file over table opens drop dialog (9d8ecc8)
enabling column level lineage to 'pass through' proc transpose (66c911e)
enabling native REDSHIFT access with incremental loads (1532305)
extra validations for MPE_TABLES cols (upcase for VAR_TXFROM, VAR_TXTO, VAR_BUSFROM, VAR_BUSTO and VAR_PROCESSED) (5cd3434)
rows number thousand separator (space) (3644f35)
licensing: 2 more tests added for no of users reached/exceeded (d615eea)
licensing: activation logic added, refactor of terms agreement, license events interconnected (89f20ae)
licensing: added site_id check, added more error handling for decrypt function (c54074c)
licensing: fixes (acbc326)
licensing: fixes (eea2c96)
licensing: licensing/update path to update the license key, when app is activated (7145150)
licensing: register key function (ccf8e50)
added colored logs in console for matching errors with tests (2e55a59)
admin/registerkey service. Expects an input table called keyupload, with 2 variables - activation_key and licence_key (3bad92f)
auto deploy improvements (d290a96)
backend service registration code@ (e1c7ac8)
creating context for auto deploy (6811828)
cypress UI testing, started (8ef54c4)
deploying services as part of CI (e981ec0)
excel file discard button and UX fixes (91f4dc3)
handling the service not found error (402e4ec)
licensing and user registration (0f9e114)
licensing proof of concept (80a7ebe)
push on dfevelopment deploy SAS services (6815ab8)
regular excel upload test (a07c739)
requests modal on autodeploy (62bc1bd)
updating context with makedata response (cf9109a)
user registartion. Fixed demo expiry on production issue. Added evaluation agreement. (a42fcc1)

Bug Fixes

trim error when chaning values in filter while variable not set (a8019ce)
abortModal not working, hashing disabled (it was bloating the server), testing fixes (9f7aa8f)
activation key in startup service (4fe5d53)
add dependency@ (5127159)
added contextname to viewer download (f1d9c35)
adding editors to history, closes (c464ee8), closes #233
adding engine (0309dfa)
adding licencekey to startupservice (83b21c9)
adding reason message to emails (48dfb43)
alignemnt button not applying changes (af7cbda)
app crashes if activationkey is invalid string (e1dacd8)
appLoc check before running startupservice (802b178)
approver name (8b79eee)
bitemporal loader error (causing lock to be left behind) (8a53226)
bump sasjs/core (4d76965)
cannot change column width while filtering (7672561)
catchphrase fixed (c5af7a5)
checks for approval, closes #234 (4f995ff)
CI script updated to work with newest CLI (f336ee6)
cli v2 ci script, refresh viewer table, autofocus tree search for libraries, apply keys redirection wrong (049e872)
col names, debugging, and ddl file (5876d22)
config (08d6be5)
config update (b2e5e01)
converting uploaded data to correct types (ce7b6d7)
copying primary key field with dragging (7105a7a)
cypress new clarity and angular elements getter fix (15540db)
ddtype field for #231 (90ae7f5)
ddtype, #231 (c4d32b8)
delete this record ordering (cacbf46)
deploy db recreate checkbox and UI fixes (fd6a13a)
deploy error handling improved (e681d9a)
deploy makedata use original web approach (dff12bd)
deploy testing and key generator (9a0ce35)
disable accept/reject buttons if user is not approver (8971999)
disable deploy button if json file not present (a93736a)
duplicate keys, removing duplicated indexes (3c2dccf)
duplicate primary keys modal improvements (a68e2d6)
empty object error (ec90456)
empty table in EDIT menu not shown (b2ca2c6)
empty table upload (4a5204e)
error message when no root folder available (e3ec4f9)
error when createing data dictionary in viya (6deb93d)
excel time exponential value (4b16c93)
excel upload with no data rows (js error was triggered, uncaught) (cdc8784)
exist typo (2b13d75)
extended test on both viya and v9. CI separated viya and v9 test jobs (d41ff50)
filter operators not in sync with selected variable (9e714ab)
filtering modal datepicker (in progress) (3f1b4a2)
handling of getdata error in response from SAS. Fixed abort modal style. (e4c8cc6)
handling trailing slash in dcPath (8808227)
hans-jeurgen processed issue (2f4e5da)
hot dropdown has no arrow (b9ead6a)
if logged out in filter view, cannot log in (4d682d3)
improved upload and submit UX (e6156dc)
improved UX, search dropdown of variable (7a7504b)
keep list (1527248)
layout issue, in/not in filter checking errors (d68b342)
length (48dfd3f)
length issue (37c39cf)
lineage issues (b4b1680)
liveness test requires submitting table to pass (1b43a63)
makeData error detect (b977b2a)
migration for incorrect datetime format (8aefd1b)
missing value (2c69aad)
older versions of edge licensing (d1eea5c)
optional viya call (8e1537e)
pages are getting wrong details on pagination (615af15)
processed_dttm was not dynamic (04d17eb)
refreshcatalog (eae6bfd)
removing old package to remove npm warning (bc99db0)
removing tabs (4742842)
renegade %end (a4a74ac)
replace dependencies with sas macros in header (3acd92b)
requests modal not working if server error (cdcd578)
return from service (4d9a8e5)
rows separator is comma (060ed48)
rxjs imports (production build error) (83d0859)
sas double slash, new loading bar (5fe053e)
sas9 metanav broken (0503e4b)
sas9 startupservice not executed (0914007)
stage component error handling (2d9f417)
startupservice failure handling (d8c3380)
startupservice sasjsAbort catch (9f30bbe)
licensing: registerkey sasjsAbort fix (a615e12)
tests: licensing test fixed unstable behavior (011fcb6)
tests: licensing tests shifted all to quickKey update (6cc0128)
Subject not constructor error (e22afc7)
surrounded data excel upload (612729b)
switch to new SAS 9 folder (41ee6c4)
syssite added to licensing page (009618e)
tests fail when switching between viya and 9 (c315d40)
typos and length checks (69beff1)
unable to VIEW tables in der touristik due to lowercase librefs (945d5ac)
updates to urls to support /services/ in program path (c978f25)
updating sas9 config (54ba22d)
uploading video from ci tests (14868e0)
user menu dropdown was not closing when you click on hot table area. (000e39e)
user nav style fix (2a6af21)
usernav issues (b4bc47d)
using more robust functions for encoding and decoding base64 (899ce20)
var_active addition to mpe_config, moving redshift setup there (35fc30e)
viewer if table eixsts undefined (cbc8cc8)
viewer library collapse after choosing a table (84c6cd6)
viewer rendering offset is to small (52985fb)
viewer table search abort modal (b6388da)
viewing non lineage tables broken in sas9 (fee51ed)
warning (0925733)
web streaming & deployment for SAS 9 (3a36280)
whereClause display wrap/styling (cca4c9e)
wording of EULA (64d9f1c)
service-paths: use relative paths without leading slash (bf0b7c1)
updated: angular 10, clarity 3, optimized (5031ed2)

3.10.0 (2020-08-18)

Features

abort modal complete refactor, removing duplicated code for abort, error handling improved (3175654)
adapter compute api integration (22dad29)
added typedoc (12480c4)
file upload using adapter function (eb0dea9)
handsontable v8, removed edit icons - contextMenu edit button (1092e5c)
jobs error catching (6c01e03)
odd rows different shade (ed336da)
pgsql download (a617d17)
sasjsAbort uses new abort-modal component (2bc300b)
started catching of adapter response error, showing full log in abort modal (e781703)
viewer lineage linking (911d0c7)

Bug Fixes

abort modal added syserrortext syswarningtext (6d6ccaf)
abort modal customizable title (c222f55)
abort modal styling (e753d9a)
abort modal warning and error text style (abaaff8)
abot leftovers in htmls (8de9713)
add record button, modal loading spinner (8527df9)
adding uri to enable lineage linking (2b12f8c)
appLoc checking (7141efd)
appLocCheck for viya only (620b94d)
approve page vlaues overlapping (b1d182d)
approvers casing issue (d4d1112)
autoselect/autodocus (a93bf8d)
bump sasjs/core (5617ced)
bumping core (f5fa141)
contextMenu enabled only on edit (e8b4d30)
data creation refactor (fb0e343)
demo mode add record button is off screen (993b1a6)
deploy compute api fixes (2b6e989)
duplicate key pipe (0116304)
edit after invalid submit not applied (be350d9)
edit from viewer, submit error (e0f2d56)
enabling makedata to run both as url and request format (5989992)
excel submit, UX fixes (5de9c1d)
home component cleanup (9416f75)
lineage download full graph (4d8d10b)
loading spinner on submit (6adc797)
makedata seperation (32f9cd6)
missing dependency (f5debd8)
model updates and build environment updates (528ed9c)
no editable tables configured (7e344df)
options button styling, sasjs adapter & core bumps, excel export fix (2752c5d)
record modal linking UX (94981cf)
Remove the auto-hide of the sidebar above a certain screen size (d841ec6)
table sizing when no demo banner present (e00533d)
to avoid circular reference (c715aed)
uploader multiple files (35e6cfd)
viewer options icon gap (2d7199b)
web query url (ed85e0b)

3.9.0 (2020-07-14)

Bug Fixes

deployServicePack removed (01e3473)
_program conflict (50dfa2b)
adapting to sasjs, removed token functions (706eb3a)
adding maxlen (a1a36e4)
adding seperator (d262685)
autodeploy infos p instead of input (fab1294)
bump macrocore, default value for _program (f3d3e5e)
bump MC and enable public services (5319005)
bump sasjs (582c9e3)
bump sasjs (4b5a167)
bumping sasjs and missing puri in lineage generator (5f25bd6)
clicking icon in viewer menu does not expand menu (3941635)
client token removal (af14883)
data model update (13a53f1)
dcpath in deploy (a157f05)
demo expired styling (61336b0)
deploy and token imporvements (9d05839)
deploy buttons position (b06ad5d)
deploy defaults set (a074787)
deploy navigate to home (17ed9b0)
deploy page fixes (3f7419f)
deploy removed client and secret, debug was not switched on (09475f2)
deploy updates (43083b4)
dynamic build of getviyaclient (21e7b9c)
edit table styling issue (d408a60)
editor title link (a7edd3c)
expired token shows login page (d1ad578)
filter issues (ccf9ea8)
forbid unchanged submit (0ec1c52)
get all contexts, deploy (dae7ee1)
get executable contexts on deploy page (d51c0d0)
header invisible when demo banner removed (7216154)
hide demo banner when license key present (634e14e)
hitting accept before diff load causes error (dbc9fbd)
jobs type in idlookup (3a138c6)
lineage column level linking (bf04597)
lineage is depending only on 'fetchlineage' service, not any other (6631fd9)
lineage libraryid of undefined, cases covered (f44b75a)
lineage multiple requests (45350a0)
lineage table url access fix (ffb2477)
macro invoke (f9b91dc)
macrocore (50bd41b)
macrocore bump (778a891)
makedata (773a62b)
makedata updates (2a6d6ae)
metadata name from response (642428c)
metadata object name when linking (62b6b6c)
metadata objectName param ignore (56cfa9e)
migration for mpe_datadictionary (b6a5edc)
more rendered rows, undefined celValidation (43111bb)
pk duplicate check, removed cellValidtion on frontend (6871191)
pk dups check on first submit (6e41613)
pk issue (58e727b)
predefined colWidths (98bb6e6)
refresh service (6d1d489)
removing 'error:' string (049d04a)
removing access tokens (9031e9a)
removing caslib assignment (53396bb)
removing session table (e50c996)
search data bug in viya (3c54cbc)
siemens issues (lineage, exporter) (7eed379)
sorting is lost after clicking edit/cancel edit (65ef697)
startupservice (367a194)
startupservice abort in console log (9a5e10f)
styling and manual deploy (d683a70)
styling, admin groups limit and sort (6c3bcad)
submit after error (8949021)
submit without changes modal (04998e3)
syscc to 0 on startup (145866a)
table update (69a6e70)
test (bb01cd9)
token expiration (1e5fb39)
tokenauth management (20ae61d)
unable to edit and dropdown blank (06f4aae)
validate primary keys, editor performance (aa66cbc)
viya auth rebuild (f74a4da)
viya fixes (24c6603)
viya token global (4b597f1)
viya usernav with RESTApis (7e12bd5)
viyainstall (3384ee8)

Features

authentication process update (045d6a2)
auto deploy for viya, appLoc exist check (c4466b3)
auto deploy if startupservice not present (635e58a)
auto include sasbuild/viya.json from dist folder (ea5f5c0)
dcdeploy, creating database (f17919d)
deploy page collapsable and improvements (e6fc907)
deploy page json upload (4bca65d)
deploy page with presistent keys (078ff27)
deployEnabled switch, removed buttons on deploy page (36f2e5f)
file uplaod with token, synced with formdata token (e67a841)
lineage svg linking (e64c840)
usernav shift to RESTApis (b70091e)
validate rows, pk duplicates in modal (98ad374)
viya deploy page (8f058d1)
viya deploy without client & access_token (f8c3bc5)
viya including access token (2d4a91f)

3.8.0 (2020-05-31)

Bug Fixes

add record url rewrite (8ab80e8)
finishing up TableLineage (ff600aa)
table lineage and post service macro append (cee486e)
lineage table: libref and table name (f87cf6b)
table lineage: csv download, table name (e4580be)
metadataRoot to appLoc (d437a6f)
moment import (718df90)
using sasjs vars in viya build (bd790b6)

Features

varchar support in Viya (c954f65)
lineage table: title link to viewer (2726d09)
table level lineage (54f7731)
Table Level Lineage (01256a9)

3.7.0 (2020-05-22)

Bug Fixes

ensuring _debug is always present (299a78d)
file upload debug param, staged data download package button (3b62a5c)
secret path (c628553)

Features

download lineage as png (0f2af40)

3.6.0 (2020-05-20)

Bug Fixes

disable filter when editing table (d411f9a)

Features

edit number of rows (f82e15c)
submit only modified rows, redirect to staged data (b3846b6)
submit statistics (ac8e97b)

3.5.0 (2020-05-20)

Bug Fixes

adding cols info to getdata services (211e943)
bumping sasjs version (30aa4b2)
edit button on table viewer (7fbf306)
editor navigation highlight, saving space in viewer and editor (31448a5)
file upload with token (4c0e18d)
filter datetime dropdown to show raw value (6a3008e)
filter values dropdown (cd1ae54)
hot filtering issues, submitting only filtered rows (159bafc)
IE search styling (b2d93ef)
loop in viewer libraries (313495e)
options dropdown position (2ae7402)
perms issues (4953fae)
removing bottom bar, saving space (bd9c35c)
request modal linking (a3f581c)
SCD2 now works with OR filter ops (6745cb1)
schemas in catalog, metarepo in metanav (43d0109)
usernav version bar (34c6ebb)
using existing cols data for filter (3c6ba97)
viya group title (d360ec1)
viya loadfile updates (a25d36a)
web query url duplication and spaces (c27fe3c)

Features

ability to exclude certain libs from the catalog refresh. Also a fix to the lineage process. (f2e95ce)
datastatus_libs (528b84b)
downlaod button on submiter and approval screen (cfbba5a)
meta nav repository presistance (ad46c61)
rows to submit (dc918dd)
selection on view presisted (962ceba)
sql server data dictionary upates (plus removal of error lines) (d8e8586)
sql server integration to dictionary tables (8610d7a)
writeback data in Viya (da3d0ee)

3.4.0 (2020-05-03)

Features

data catalog for libraries, tables and columns (1865eb1)
filter values editable (ffa1065)
viewer number of rows (37fbf3d)
viewer search table (ae65969)

3.3.1 (2020-04-27)

Bug Fixes

ddl download (ece1e79)
submit bug, stage page license key (388c067)

3.3.0 (2020-04-26)

Bug Fixes

backend changes to support frontend fixes (2e7b6ef)
dqdata update (b8db8bf)
invalid values on submit, notnull validation (4ac8088)
parsing errors and warning improved, performance fix, icons added (e2b8a24)
remove syscc=4 in approvals (af24fd3)
switch to mp_streamfile (8cb4529)
warning not linkable (9491ccc)

Features

request modal error and warning linking (ebcf2f4)

3.2.0 (2020-04-23)

Bug Fixes

get username from MF_GETUSER (10bc04f)
double scroll, add record button, add row scroll to bottom (75fd508)
dropdowns (4247114)
editor page not working (c7ae36f)
record modal not opening, paste trim trailings, 'edit' button performance (26da7f5)
WIP dialouge not opening for new row after cancel and reopen (ad37092)

Features

dqdata update (ccbec0c)
exclude data lineage and metanav if serverType is viya (56c0459)
metavav auto open on object url navigation (ce49d75)
usernav functionality for VIYA (63fa9ae)

3.1.0 (2020-04-19)

Bug Fixes

sas path in url dynamically (241911d)
broken url (397857b)
char input length check (69efa6e)
incorrent url for download and upload (2638d58)
link to this record (970f952)
metanav services and utf-8 issue (3820e78)
modal upcase validation, copied to clipboard, number converted to char (9bdcf50)
record modal original column order (2595911)
submit modal, record modal improving (ec1eab2)
excel-upload: add polyfill for DateTimeFormat.formatToParts (22ce409)
sasjs: upgrade adapter version to fix IE (517fff5)
url: remove hardcoded path (7071186)
wrong navigation from approve/submit to view table (d144a2e)

Features

add "NOT IN" option to filter (d41217b)
add / edit record option (e82b346)
autoselect / autofocus on edit submit (8833e11)
metanav attributes search, auto open object details (9dfb112)
record-edit linking (14eedca)
viya support wrapup (d211378)

3.0.0 (2020-04-13)

Bug Fixes

all servies converted to SASjs (f649bf1)
bitemporal loader error removal, build process switched to dcbuild.sh (0ccc4bc)
case sensitive librefs (198a2de), closes #86
configuration and startup service (d4e1d7b)
configurator (f0f2224)
configurator, and metanav services updated (c626f08)
enabling sasjs build (71d65e8)
environtment verson path (8636879)
final build script (9cd80cf)
final for viya (920d9ae)
getting to demo version (9ffbee2)
incorrect validations after duplicate check (24a417d)
lowercase response, approve route (9e07fb1)
metanav SAS integration (3fce458)
page not found on approve details (08fea24)
precision (2321892)
preparing web target (20aaf69)
re-org of files for sasjs-cli 2.2 (81c2094)
removing h54s and boemska (120cd1b)
response lowercase, debug switch (7660cc6)
sas errors in 9 (5d1471c)
sas9 fixes (45b90dd)
setting username on login and request (8e1e0d1)
splash page (6a50a22)
stagedata fref pickup (55572cb)
stagedata table object, debug switch modal close, removing appLoc in request path (c227a2c)
switching mf_abort for mp_abort (1ba790f)
test updates (demo version) (cbc2723)
upgrade to latest sasjs-cli format (8aae0b2)
upgraded sasjs (fdd7c17)
uppercase issue (08d65b8)
user _METAUSER instead of sysuserid for SAS9 (5c12760)
various, including bitemporal (09d77ca)
viya integration (99a8993)
viya integration of getgroupmembers (426bc88)
viya updates (22d6e98)
dcbuild: hostURL starts with // instead of http/https (1f3d6e3)

Chores

readme update (4ded32a)

Features

viya macros (bef208e)
data quality rules on edit mode (65a20c5)
enabling users & groups in Viya (30bed3d)
integrating sasjs (startupService, SAS Requests, Login) (d7e20f9)
sas9 auto-build with latest sasjs-cli (5c2f1e4)
sasjs integration (beb30d8)
viya mods to enable first service (a8c8932)

BREAKING CHANGES

switch to SASjsgit add README.md

2.2.0 (2020-03-28)

Bug Fixes

date capture (c7c3d57)
DOWNCASE->LOWCASE (aecba73)
hot license key (3f5b636)

Features

apply dqrule in edit mode (3b4afbd)

2.1.0 (2020-03-26)

Bug Fixes

closes #83 (decimal truncation issue) (870bf5c)
cypress (56ddfdf)
debug switch wrong state (00d9ad1)
double click triggers edit mode (169b84d)
legacy support for x variable in post edit hook (3777c33)
local vars (ba8ce4c)
migration (81a5e0d)
test update, remove logging (cae0735)
tests (e28d872)
tidyup and enabling views in viewtables (06639cb)

Features

data dictionary and mpe_validations tables, and DQRULES now sent in getData service (856b4f6)
hardselect, closes #84 (859cfd1)
user friendly display when library is empty (cff71f2)

2.0.0 (2020-03-16)

Bug Fixes

backend can take either first or second file as CSV (a3aaab6)
click twice download dialog, link to VIEW in EDIT (9b47b75)
enabling clicking of users in groups page (ab2acc4)
moving to single directory for log / staging data capture. (766e9fc)
pagination of libraries in tree (5e79ec3)
removing 'multiple file load' feature (2f21cc4)
removing 'multiple file load' feature (268fdc1)
saving sub-page in navigation, startup service refactor, edit in VIEW dropdown (98280a9)
typing on X and prettify JS (9ab737d)

Features

backup Excel file (7c5e57e)
excelIntegration: upload both csv and excel file (d90bfdf)
cypress testcases migration (4fa372c)
cypress testcases migration (e2d9998)
cypress testcases migration (8e6ccc4)
excelIntegration: upload both csv and excel file (57698b0)

BREAKING CHANGES

the previous download links will not work following this upgrade

1.3.3 (2020-03-10)

Bug Fixes

dups in groups and missing members (e06b269)

1.3.2 (2020-03-09)

Bug Fixes

removing duplicates on groupnames (8e8f99a)

1.3.1 (2020-03-09)

1.3.0 (2020-03-09)

Bug Fixes

closes #73, adding test data and faster viewLib service (3fbfff2)
moving meta specific macros to macros_meta folder (5bb6fb0)
recursive join issue (was necessary to have a dependency) (cf0c4bf)
services in usernav (cb6630d)

Features

usernav: adding remaining backend services (2f8ccd2)
usernav: sidebar integration (60700fb)
usernav: User Navigation (265c489)
User Navigator services (505b99b)

1.2.1 (2020-02-29)

Bug Fixes

IE and Edge hidding libraries (c59de7c)
resizing sidebar improvments (fe7b4bb)
view new table, old removed, added column dropdown (e8d254b)

1.2.0 (2020-02-27)

Bug Fixes

model change in selectbox table (92fd9be)
remove autologging and make debug mode false by default (cc625f0)
tree library leftover (b2b9c07)

Features

metadata navigator (80c3fcc)
metadata navigator: routing and scroll bar on objects (9a88e5f)
metadata navigator: routing update and repository addition (571da8f)
metadata navigator: search bar on metatypes (3b94c0d)
metadata navigator: search on metadata objects, design improvements (1973147)

1.1.0 (2020-02-26)

Bug Fixes

docs: direct lib now in settings (a572625)
adding npm package (cdb6c87)
dropzone buttons one row (a630a69)
edit integration undefined table approval (b382aa8)
editor libraries bug closes #57 (80c7719)
header match case insensitivity (63ed719)
IE Tree bug, resizing sidebar (2e0db53)
removing call to mm_getlibs and ensuring compatibility with multiple repositories (2520ddd)
this.table (0877332)
using meta libname in settings (550b9ce)
viewer caching issue (bdeffe2)

Features

excel data integration: missing columns addition (5fdab7b)
excel parsing: order doesn't matter + wiscard extra columns if exists in between (c0d0c9a)
excel_integration: header selection method update (be1e2f6)
download DDL (#closes 43) (4ff3398)
download DDL (9a70fff)
excel data Integration (f630f1d)
excelIntegration: Date time header validations (2213bee)
list of metadata repos (new service) (7d5e17e)
usage tracking. closes #45 (dccd7fa)
wide drap/drop and auto upload on file drop (b02cfc2)

1.0.2 (2020-02-12)

Bug Fixes

approve page overflow (711401a)
editor page overlaying header bar (a9cd778)
moving JS to be exernal (05c41ba)
moving JS to be exernal (5b85773)
perms (6721a67)
sidebar duplicates and double selection (edade84)

1.0.1 (2020-02-11)

Bug Fixes

migration mpe-security (7cd7896)
moving scripts.js to external site in demo version (49ad2c0)

1.0.0 (2020-02-09)

Chores

remove whitespace (89fc982)

BREAKING CHANGES

seems this needs to be in the footer for it to work

0.12.1 (2020-02-09)

0.12.0 (2020-02-09)

Bug Fixes

new design: clarity new version fixed elements (inputs, selects...) (755a41c)
new design: filter input elements (broken due new clr version) (338faf8)
issue20 security updates (f7168b7)
new design, viewer sidebar optimizing (bb29fb7)

Features

new design: lineage component (2e070c0)
new design: sidebar searchboxes (b6cca58)
New Design (a4f41da), closes #35
new design: lineage started (6e1ead1)
selectively disable tables in VIEW (44a418e)
TIME support (minus time picker). closes #issue42 (a16e240), closes #issue42

0.11.2 (2020-01-31)

Bug Fixes

missing macro in bitemporal loader (7681d46)

0.11.1 (2020-01-29)

Bug Fixes

enabling embedded carriage returns (d9422dc)

0.11.0 (2020-01-28)

Bug Fixes

short numerics and best. format numerics now handled (b7c1279)
stp registration (8afa679)

Features

short numerics (c840b79)

0.10.1 (2020-01-28)

Bug Fixes

short numerics and numeric formats, #closes issue40 (eb5893c)

0.10.0 (2020-01-25)

Bug Fixes

adding more sample data (89b25d1)
editor column max width (8e803fc)
editor file upload abort message (10cad83)
lineage regenerate problem (354d126)
sample data (b743892)
viewer / editor column max width (6c3abc7)

Features

groups plus metadata refresh backend (850f29a)
lineage refresh cache option (35d1b6c)
max col width 500 plus custom groups feature (5d5b55b)
metadata services (697642c)

0.9.0 (2020-01-19)

Bug Fixes

maxdepth for lineage (28cf028)
MAXOBS for editing data (5ada758)

Features

9.3 compatibility (remove fcmp in windows, updating adapter) (11e7692)
admin tools (config viewer and download) (a95ed90)
extra checking to ensure the install user has the correct metadata and OS permissions (4ef83db)
licence checker plus adding MPE_SELECTBOX to config download (5109670)

0.8.0 (2020-01-13)

Bug Fixes

lineage table removal (e28cb59)
removing configurator after it is run (to prevent accidental overwrite once library is up and running) (8759226)
removing stp dependency in mpeinit (44d3c63)

Features

lineage flatdata csv download (fce560f)

0.7.2 (2020-01-11)

Bug Fixes

empty lineage screen now displays (9876ff9)

0.7.1 (2020-01-07)

0.7.0 (2020-01-02)

Bug Fixes

adding port to web query (07e6a5d)
closes #32 and enbles viewing of tables that only exist in metadata (c942b21)
dropdown to download button inside popup (ceb5b75)
dropdowns and buttons reposition, saving space for lineage graph (e95a713)
editor table, dot check removed (9612323)
IE editor library dropdown, lineage selection width (9a1c923)
index.html metadata (83fb505)
index.html metadata (ff0c552)
index.html metadata comment update (c2e337f)
lineage download buttons hidden (9227ccc)
lineage more space (f2e6375)
lineage popup remove, positions, linkable (9d53f2a)
linking lineage (4c2095b)
padding issues, editor table loading fix (bc0c2be)

Features

IE compatibility (e28ac50)
linkable lineage (d8ebc19)

0.6.0 (2019-12-14)

Bug Fixes

package updates (03ace1f)

Features

lineage and metarepo option (99090a1)
Add Data Lineage (b21a644)

0.5.0 (2019-09-20)

Bug Fixes

error message not surfaced on VIEW table, closes #25 (4687ec4)
format length issue, special chars in usernames issue (447f483)
removing npm audit warnings with devkit update to 13.9 (e1d28a9)

Features

improved deployment process for evaluation version (3a9e846)
Allow WLatin file upload (1c02491)
auto config for eval version (35ab667)

0.4.0 (2019-05-27)

Bug Fixes

additional types added (279fb6c)
editor dropdown remember selections (75391eb)
email fixes (996b14b)
email issues (c74f668)
filter remebering | cleanup (bd59204)
issue 18, use strict (a4ac751)
issue 19 (ca67123)
metadataRoot added back (50243a3)
remember filter editor (6fe1545)
remember filter selections (774a42e)
remember filter viewer (de53590)
remembering filter selections issue15 (d86326a)
remembering filter without regenerating (f5fa1dd)
remembering selections | running service onliy on startup (f8aeef5)
removed some settings (222001a)
removing col freeze as not ready yet (a8ac2bc)
removing not null constraints (b4f4ba8)
save selected library and table (c98bdfd)
unique urls in prod build (605de8a)
unique urls in prod build (b749b35)
upgrading handsontable to 7.03 (08200e0)
viewer dropdowns remember selections (189304c)
viewer dropdowns remember selections (ae29b42)

Features

adding email options in log in mpe_alerts (e546d8e)
adding dropdowns to mpe_alerts table by default (f43db13)
adding frontend filtering, column freeze, and readonly column switch (003373a)
always on debug plus siteid linking for eval version (fa0a418)
locking down eval version to a siteid (bfb6325)

0.3.0 (2019-04-11)

Bug Fixes

closes #16, missing getAuditFile (e6b6717)
issue12 dev work (8b547af)
missing macro in loadfile (334b4a2)
problem with file upload. Also enabling licence key implementation on view & stage components. (0f186e5)

Features

enabling multiColumnSort and manualColumnResize. Closes #1 and closes #13. (56dfc90)
moving ALL config vars to MPE_CONFIG table. Closes #11 (6132793)

0.2.0 (2019-04-07)

Bug Fixes

failing file uploads in demo version of DC resolved. closes #9 (f0a6aeb)
missing mf_abort in getStageTable (97f0c66)

Features

switch settings to be an STP for easier modification (a28057d)
adding switch for library checking, no by default to improve responsiveness. Closes #7 (adcacf5)
enabling emails on SUBMIT, APPROVE and REJECT. Closes #10 (daec738)

0.1.0 (2019-04-03)

Bug Fixes

accidental deletion (8236438)
enabling build (f5e8807)
fixes to fix demo version (6cf6c69)
removing console logs (3d6e6f2)
upgrade to avoid npm warnings (d8f90c3)

Features

clarity: the styling now workscd .. (28b2db5)
single SPK compilation (b785d84)
removing app component replacing with document object, which is safer when importing SPKs over existing packages (0ba14ed)

0.0.1 (2019-01-27)

Bug Fixes

Adding new rows now works (8685b4e)
removing invalid json (7dd24e0)
removing version.ts from source control (186c669)
removing version.ts from source control, now with gitignore (2c8ccf8)

Features

removing font (325f193)

186 KiB Raw Permalink Blame History

6.8.2 (2024-05-03)

Bug Fixes

6.8.1 (2024-05-02)

Bug Fixes

6.8.0 (2024-05-02)

Bug Fixes

Features

6.7.0 (2024-04-01)

Features

6.6.4 (2024-04-01)

Bug Fixes

6.6.3 (2024-02-26)

Bug Fixes

6.6.2 (2024-02-22)

Bug Fixes

6.6.1 (2024-02-19)

Bug Fixes

6.6.0 (2024-02-12)

Bug Fixes

Features

6.5.2 (2024-02-06)

Bug Fixes

6.5.1 (2024-02-02)

Bug Fixes

6.5.0 (2024-01-26)

Features

6.4.0 (2024-01-24)

Bug Fixes

Features

6.3.1 (2024-01-01)

Bug Fixes

6.3.0 (2023-12-04)

Features

6.2.8 (2023-12-04)

Bug Fixes

6.2.7 (2023-11-09)

Bug Fixes

6.2.6 (2023-10-18)

Bug Fixes

6.2.5 (2023-10-17)

Bug Fixes

6.2.4 (2023-10-16)

Bug Fixes

6.2.3 (2023-10-12)

Bug Fixes

6.2.2 (2023-10-09)

Bug Fixes

6.2.1 (2023-10-09)

Bug Fixes

6.2.0 (2023-08-24)

Bug Fixes

Features

6.1.0 (2023-07-25)

Bug Fixes

Features

Changelog

6.0.0 (2023-06-27)

⚠ BREAKING CHANGES

Features

Bug Fixes

5.3.0 (2023-02-23)

Features

Bug Fixes

5.2.0 (2022-11-15)

Features

Bug Fixes

5.1.0 (2022-09-02)

Features

Bug Fixes

5.0.0 (2022-07-11)

⚠ BREAKING CHANGES

Features

Bug Fixes

4.2.2 (2022-03-21)

Bug Fixes

4.2.1 (2022-03-21)

Bug Fixes

4.2.0 (2022-03-17)

Features

186 KiB

Raw Permalink Blame History