Tuesday, December 6, 2011

Query to extract Oracle Configurator CX rule information


We can use following query to find out all the CX rules in the Configurator model. The query will display the information for the rules like rule_name, java class associated with it, event name, event scope, and oncommand event name.

SELECT DISTINCT RU.RULE_ID, 
  RU.NAME, 
  (SELECT NAME FROM CZ_SIGNATURES WHERE SIGNATURE_ID=EN.ARGUMENT_SIGNATURE_ID) AS EVENTNAME, 
  CLASS_NAME, 
  DECODE(EN.EVENT_EXECUTION_SCOPE, 1, 'Global', 2, 'Base Node SubTree', 4, 'Base Node', 'Unknown') AS SCOPE, 
  EN.DATA_VALUE oncommandEventName
FROM CZ_RULES RU, 
  CZ_EXPRESSION_NODES EN
WHERE DEVL_PROJECT_ID IN (131343) --for given devl_project_id
  AND RU.RULE_ID=EN.RULE_ID
  AND RU.RULE_TYPE=300 --for CX rules
  AND EN.ARGUMENT_SIGNATURE_ID IS NOT NULL --with valid event
  AND RU.DELETED_FLAG=0 --ignore deleted nodes
  AND EN.DELETED_FLAG=0
  AND EN.EXPR_PARENT_ID IS NULL --definition is only on parent node of expression tree
;

This query is useful at times to find out all CX rules with base node subtree event scope which may usually cause performance issue if its unwanted. You can always add other parameters/clauses to filter information as per your need.

35 comments:

  1. Thank you for the query. Is there a way to find the java class used in the event Binidng? Also can you tell me how to find the values in the argument binding?

    ReplyDelete
  2. Is there a way to find the method_name in the Bind Method Arguments?

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. Since we changed the expansion how about we see what happens when we drag it to Photoshop. https://es.altorotatepdf.com/

    ReplyDelete
  6. PHP is a simple to utilize Open source; it is essentially autonomous of stage and is adaptable with offices of improved illustrations. Cakephp Programming service

    ReplyDelete
  7. This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free. 정보이용료 현금화

    ReplyDelete
  8. Great Article it its really informative and innovative keep us posted with new updates. its was really valuable. thanks a lot. 亚博体育

    ReplyDelete
  9. What a fantabulous post this has been. Never seen this kind of useful post. I am grateful to you and expect more number of posts like these. Thank you very much. سایبربان

    ReplyDelete
  10. So it is interesting and very good written and see what they think about other people. Email Extractor Software

    ReplyDelete
  11. this is really nice to read..informative post is very good to read..thanks a lot! Kanādas vīza tiešsaistē

    ReplyDelete
  12. Some truly wonderful work on behalf of the owner of this internet site , perfectly great articles . pc software download free latest

    ReplyDelete
  13. I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. rust accounts

    ReplyDelete
  14. The post is written in very a good manner and it contains many useful information for me. ufabet เว็บตรง

    ReplyDelete
  15. Yes i am totally agreed with this article and i just want say that this article is very nice and very informative article.I will make sure to be reading your blog more. You made a good point but I can't help but wonder, what about the other side? !!!!!!Thanks low obl

    ReplyDelete
  16. They now have a newly designed flyer that they want to use for a special promotion. They want to start with a small run of high-quality color flyers, and need the option to print more at a moment's notice. The promotion lasts for three weeks. renting impresoras mallorca

    ReplyDelete
  17. This comment has been removed by the author.

    ReplyDelete