Posts Categorized: Maconomy

Find MenuID and RoleID corresponding to ComponentID in Maconomy Portal

Posted by & filed under Maconomy.

Component/Role/Menu SELECT COMPONENTID , ROLEID , MENUID FROM MENUITEM WHERE COMPONENTID LIKE '%::BPM::%' DFME: SELECT DISTINCT COMPONENT.COMPONENTID , COMPONENT.LABEL COMPONENT_LABEL , MENU.NAME MENU_NAME , USERROLE.NAME USERROLE_NAME , FIELDATTRIBUTE.ATTRIBUTEVALUE FROM MENUITEM INNER JOIN COMPONENT ON MENUITEM.COMPONENTID = COMPONENT.COMPONENTID INNER JOIN MENU ON MENUITEM.MENUID = MENU.MENUID INNER JOIN USERROLE ON USERROLE.ROLEID = MENUITEM.ROLEID LEFT JOIN FIELDATTRIBUTE ON […]

Archiving Pentaho log table in SQL Server

Posted by & filed under Kettle, Maconomy.

Pentaho Data Integration displays only the last 50 log entries but anytime you open a transformation it has to read the whole log table. When the log table gets large, opening a transformation may take long time and PDI freezes for this time. A solution is to archive old entries from the log table. Create […]

Maconomy version

Posted by & filed under Maconomy.

SELECT MAINVERSIONNUMBER, PATCHNUMBER FROM ( SELECT MAINVERSIONNUMBER, PATCHNUMBER, ROW_NUMBER() OVER (ORDER BY MAINVERSIONNUMBER DESC, PATCHNUMBER DESC) RN FROM SYSTEMMAINTENANCELOG )A WHERE RN = 1