Saturday, November 30, 2013

Update Java Extension ClassName for Configurator CX rules using query

Following query will update the java classname (from xxcz.cx.MyOldClass to xxcz.cx.MyNewClass ) for all the models which are under repository folder name 'Models - In Process'

UPDATE cz_rules ru
SET ru.class_name        = 'xxcz.cx.MyNewClass'
WHERE exists(SELECT
  rpf.name folder_name,
  p.name model_name,
  p.devl_project_id,
  r.name rule_name,
  r.rule_id,
  r.class_name
FROM cz_rules r,
  cz_devl_projects p,
  cz_rp_entries rpp,
  cz_rp_entries rpf
WHERE r.devl_project_id=p.devl_project_id
AND r.rule_type = 300 -- CX rules
AND rpp.object_id       =p.devl_project_id
and rpp.enclosing_folder = rpf.object_id
AND rpp.object_type     ='PRJ'
AND R.DISABLED_FLAG=0  --update only enabled rules
AND rpf.object_type = 'FLD'
--AND P.DEVL_PROJECT_ID=1037298 --add this if you want to update specific model only
AND class_name LIKE 'xxcz.cx.MyOldClass'
AND RPF.NAME LIKE 'Models – In Process'
AND r.rule_id=ru.rule_id
);

24 comments:

  1. Credit rating reporting is not something but oracle fusion procurement manner wherein viable avail with options to offer the customer or the monetary employer commercial enterprise organization with all of the credit rating and debt facts
    oracle fusion financials training
    oracle fusion financials online training
    oracle fusion Procurement training training
    oracle fusion procurement online training

    ReplyDelete
  2. We have good game slots best casino games in history Get winnings here and now.

    ReplyDelete
  3. i never know the use of adobe shadow until i saw this post. thank you for this! this is very helpful. daftar slot online

    ReplyDelete
  4. Excellent blog! I found it while surfing around on Google. Content of this page is unique as well as well researched. Appreciate it. บาคาร่าออนไลน์

    ReplyDelete
  5. Do you want a printer that can fire off its copies in as quick of an amount of time as possible? If so then you will want to look towards a laser printers because it is dramatically faster than an inkjet printer. renting impresoras murcia

    ReplyDelete