display all libraries in MPE_SECURITY dropdown #279

New Issue

2026-07-21T09:47:02Z

allan commented

2026-07-21 09:47:02 +00:00

Seems we only show the EDITABLE libraries by default

insert into &lib..MPE_VALIDATIONS set
    tx_from=0
    ,base_lib="&lib"
    ,base_ds="MPE_SECURITY"
    ,base_col="LIBREF"
    ,rule_type='HARDSELECT'
    ,rule_value="&lib..MPE_TABLES.LIBREF"
    ,rule_active=1
    ,tx_to='31DEC5999:23:59:59'dt;

replace with:

insert into &lib..MPE_VALIDATIONS set
    tx_from=0
    ,base_lib="&lib"
    ,base_ds="MPE_SECURITY"
    ,base_col="LIBREF"
    ,rule_type='SOFTSELECT_HOOK'
    ,rule_value="services/validations/libraries_all"
    ,rule_active=1
    ,tx_to='31DEC5999:23:59:59'dt;

Seems we only show the EDITABLE libraries by default ``` insert into &lib..MPE_VALIDATIONS set tx_from=0 ,base_lib="&lib" ,base_ds="MPE_SECURITY" ,base_col="LIBREF" ,rule_type='HARDSELECT' ,rule_value="&lib..MPE_TABLES.LIBREF" ,rule_active=1 ,tx_to='31DEC5999:23:59:59'dt; ``` replace with: ``` insert into &lib..MPE_VALIDATIONS set tx_from=0 ,base_lib="&lib" ,base_ds="MPE_SECURITY" ,base_col="LIBREF" ,rule_type='SOFTSELECT_HOOK' ,rule_value="services/validations/libraries_all" ,rule_active=1 ,tx_to='31DEC5999:23:59:59'dt; ```

allan changed title from ~~display all tables in MPE_SECURITY DSN dropdown~~ to display all libraries in MPE_SECURITY dropdown

2026-07-21 09:48:53 +00:00

allan referenced this issue from a commit

2026-07-21 17:08:48 +00:00

feat: using ALL libraries as validation in MPE_SECURITY. Closes #279

allan referenced a pull request that will close this issue

2026-07-21 17:34:03 +00:00

v7.12 release #278

Yury closed this issue

2026-07-28 09:52:13 +00:00

gitea-actions bot referenced this issue from a commit

2026-07-28 10:15:55 +00:00