Oracle Configurator (CZ) Model Repository Queries

The below query lists down all the Configurator models along with the folder name and the latest development project id (cz_devl_project). SELECT P.devl_project_id, P.name, R.enclosing_folder, R2.name FOLDER FROM cz_devl_projects P, cz_rp_entries R, cz_rp_entries R2 WHERE R.object_type = ‘PRJ’ AND R.deleted_flag = ‘0’ AND P.deleted_flag = ‘0’ AND P.devl_project_id = R.object_id AND R2.object_id = R.enclosing_folder AND […]

Read More Oracle Configurator (CZ) Model Repository Queries

How to persistently show the details of the logged in user in the header or footer of the page?

We can leverage BM javascript variables and use them in the ‘header and footer’ section. Any html script defined in the header and footer section is shown on all the pages. Below is an example of a html snippet which can be defined in the ‘Header HTML’ section under Admin->Header and footer. http://$BASE_PATH$/javascript/bm-framework.js <table width=”100%” border=”0″ […]

Read More How to persistently show the details of the logged in user in the header or footer of the page?

How to change the background color of a column in the line item grid

The variable name of the commerce sub doc attribute for each column in the line item grid is enclosed in the data-varname attribute of the span tag. For example, for the sub doc commerce attribute whose variable name is  a50th_line, the cell value would be represented as below: <span class=”readonly-wrapper” id=”readonly_3_a50th_line_38679238″ data-varname=”a50th_line”>$102.00</span> Thus the data-varname attribute of the […]

Read More How to change the background color of a column in the line item grid

How to change the position of the Select All Checkbox in the Configuration Layout

If you are using a recommended item rule in configuration which is not mandatory, the user will see a select all checkbox just above the list of optionally selectable items in the mandatory item listing. Depending on how you have customized the Page Template for mandatory items, the select all checkbox can be hard to […]

Read More How to change the position of the Select All Checkbox in the Configuration Layout