When-List-Changed  Trigger on an Item -> Urgent

Posted on 2009-04-28
Last Modified: 2013-12-19
I wanted to know, if we can write a triiger on an item.
I have few Items and they are associated with Push button, which when clicked give me a List of Values. And they are in a hierarchical order. For Eg:
Product_legal_name is at the highest point. We can select a product_legal_name.
After that there is another list call GL class which depends on the product_legal name.
Even this has push button, which when selected gives a list.
After this we have product_type which depends upon both the above i.e., product_legal_name and GL_Class.

So, I need to write a code in such a fashion that when I select product_type the bottom
option should become ALL. When I select something in the bottom and move to top that it product_legal_name then all the bottom fields should become ALL.

So, some one has advised me to put a When List Changed trigger on each of the item.

Kindly could you suggest me, hoe to get it done.
I need urgent help on this.
Question by:vishal_singh
    1 Comment
    LVL 12

    Accepted Solution

    if i understand your problem correctly, you only have to create a WHEN-VALIDATE-ITEM trigger on those fields, e.g.

    -- Item Legal Name:
        IF :PRODUCT_LEGAL_NAME NOT LIKE 'All Product Brands%' THEN
           :PRODUCT_TYPE := 'Selected Product Types = 0';
           :GL_CLASS := 'All GL Classes';
       END IF;


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now