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.
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?
ReplyDeleteGreat Article. Thank you for sharing! Really an awesome post for every one.
DeleteProject Centers in Chennai
Java Training in Chennai
Final Year Project Domains for IT
Java Training in Chennai
Is there a way to find the method_name in the Bind Method Arguments?
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteSince we changed the expansion how about we see what happens when we drag it to Photoshop. https://es.altorotatepdf.com/
ReplyDeletePHP is a simple to utilize Open source; it is essentially autonomous of stage and is adaptable with offices of improved illustrations. Cakephp Programming service
ReplyDeleteThis 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. 정보이용료 현금화
ReplyDeleteGreat Article it its really informative and innovative keep us posted with new updates. its was really valuable. thanks a lot. 亚博体育
ReplyDeleteWhat 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. سایبربان
ReplyDeleteSo it is interesting and very good written and see what they think about other people. Email Extractor Software
ReplyDeletethis is really nice to read..informative post is very good to read..thanks a lot! Kanādas vīza tiešsaistē
ReplyDeleteSome truly wonderful work on behalf of the owner of this internet site , perfectly great articles . pc software download free latest
ReplyDeleteI 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
ReplyDeleteThe post is written in very a good manner and it contains many useful information for me. ufabet เว็บตรง
ReplyDeleteYes 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
ReplyDeleteThey 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