A is for APEX and Accordion

I had someone internal at Oracle ask for an Accordion widget in APEX. I figured everybody else code use something like this so I figured I'd build out an example in the standard place.

I think the best and easiest way to do this is to base it on a Report Row Template.

There are some caveats to this example.

The first being that #REGION_STATIC_ID# isn't properly substituted in a Report Row Template, I put it in anyway since at some point it will be. All you have to do is surround the report with element with an id or give the report itself an id , this actually isn't a bad idea as I figure most people will only want one of these per page.

The second is if you put multiple accordions on a page the row id has to be unique which is pretty easy to do in the SQL statement.


The accordian can be instatied on page load like this
pAccordian = new Accordion('accordion',true);

The first parameter is the id for the surrounding element.
The second parameter chooses between firing onmouse over (true) or onclick (false).

So here you go,

http://apex.oracle.com/pls/otn/f?p=11933:130

Enjoy

29 Comments:

  1. Patrick Wolf said...
    Carl, nice accordion example! I like the clickable one more, because the other one is to hectic when you just move your mouse around.

    Patrick
    John Scott said...
    Yeah I agree, very nice example. A nice addition to the mouseover one would be a delay (e.g. 500ms) so that it doesn't automatically expand until you leave your cursor over it for that period of time.
    pay per head service said...
    I really enjoy reading the post, thanks for sharing I really like it, I already bookmarked it, thank you guys.
    Anonymous said...
    Good job. Thanks for sharing such a good post.
    click here
    Anonymous said...
    Healthybodyinc phytoceramide said...
    Yep My partner and i acknowledge, comfortable illustration. A good improvement on the mouseover just one would be a wait (e. h. 500ms) in order that it does not automatically grow until you abandon the cursor in excess of this with the period of time.Healthybodyinc phytoceramide
    karya ismail said...
    Anda mencari produk Furniture Jepara dengan desain minimalis ataupun klasik asli mebel jepara dengan harga murah. kami menyediakan berbagai tipe atau model produk Mebel Jepara terutama dengan menggunakan material kayu jati. Disni saya menjual produk produk mebel mulai dari kursi tamu minimalis meja makan jati tempat tidur dan sebagainya. Untuk indormasi lebih lanjut anda bisa langsung menuju katalog website kami.
    Produk produk yang kami tawarkan mempunyai kualitas tinggi dan kami menawarkannya dengan harga yang cukup terjangkau, tentunya kualitas produk tersebut akan kami jaga. Produk Furniture Minimalis selalu banyak diminati oleh banyak konsumen baik itu dari dalam maupundari luar negri. Banyak sekali turis turis asing berbondong bondong ke jepara dengan tujuan yang sama seperti anda yaitu untuk mencari produk Kursi Tamu.
    Kami Cv. Karya Priboemi Jepara sebagai produksen furniture memberikan anda kemudahan untuk berbelanja produk furniture jepara dengan aman melalui transaksi online, kami menyediakan berbagai model di dalam katalog website kami. Anda cukup duduk santai di ruamh, kami kerjakan produk pesanan anda dan tentunya kami akan memberikan garansi jika produk tidak sampai ke tangan anda ataupun produk Furniture Jepara yang anda pesan, kami proses dengan sangat terkontrol, baik itu dalam hal pemilihan kayu, proses kontruksi, pahatan ukir hingga proses finishing. Oleh karena itu kami sebagai perusahaan Furniture Jati selalu mengutamakan kualitas produk serta ramah kepada anda.
    Jepara memang dikenal sudah sejak lama sebagai kota industri Furniture Jepara terbesar oleh beberapa negara. Kota Jepara sendiri selalu menjadi langganan aktif dalam setiap pengadaan pameran furniture Furniture Jati.
    Banyak sekali produk produk yang di tawarkan satunya yang menjadi produk unggulan mebel jepara yaitu Kursi Tamu Jati yang sangat cantik dengan keaslian ukiran khas mebel jepara yang meja makan, set meja makan dan banyak lainnya.
    Oleh karena itu mulai dari lima tahun terakhir kami sudah mengembangkan untuk pembelian produk furniture dengan menawarkannya di Toko Furniture Online yang sudah furniture tersebut diatas tadi di katalog produk kami tersebut disini Furniture jepara Online banyak sekali yang dapat anda Furniture Jati secara online dengan Jadi apabila anda ada keluhan saat bertransaksi Furniture Online dengan kami, jaminan keamanan 100% di toko kami Toko Mebel Online produk produk kami berkualitas karena dikerjakan Tempat Tidur Jati kami sudah mulai membuka pemesanan dengan anda cukup dengan santai diruamh, anda tinggal menyodorkan bagaimana produk Tips Furniture
    jati jepara said...
    Pusat bufet jati menjual berbagai macam produk furniture jepara murah

    terlengkap dan terpercaya produk kami seperti jual sangkar burung . Tidak hanya itu kami melayani

    perbaikan laptop anda yang rusak lagsung saja ke servis laptop semarang siap

    membantu anda dan bulu perindu pengasihan dapat membantu masalah asmara anda. kami juga melayani jual hijab terbaru.
    Sheetal Roy said...
    jessica gill said...
    drana said...
    Ludhiana call girls The town Ludhiana may be their state Punjab money. It's one of the most beautiful city in the India. The town includes a great populace and also the huge numbers of people continue travelling to time to the town for that numerous reasons from time. The Ludhiana escorts have now been an established participant in engaging the service customers along with the main appeal from the country's various regions. You will get anything you want. There are lots of various platforms of entry on consideration of the improvement that is great observed within the current period. All of the services are often available online from any area.
    Karan Gupta said...
    Conduct and the mindset of the escorts in Chandigarh is extremely useful motivating and co-operative. They fulfill the sex hunger of the clients in the best method that is possible. The escort, who you select will give a new method of sex to you. But, you have to be careful about any of it. Lots of people opine that it's a method to possess intercourse using the escort. But, there's nothing beats that.
    Chandigarh escorts
    Chandigarh escort
    escort in Chandigarh
    escorts in Chandigarh
    Chandigarh escorts service
    Chandigarh escort service
    Chandigarh Independent escorts
    Independent escorts in Chandigarh
    Chandigarh female escorts
    call girls in Chandigarh
    Chandigarh call girls
    Chandigarh female escorts
    Chandigarh vip escorts
    sandali khan said...
    Hot Teen Companions using purity encounter that is adorable really wants to fuck a Teenager Companion that is sexy in
    Chandigarh escorts views the Teenager Companions web site to find out more.
    Chandigarh Call-Girls, the absolute most searchable Companions regarding males Chandigarh College Women, they most possess some sensation which makes these warm in mattress plus since they're therefore significantly attractive, begin to see the University Women class for information.
    Mahesh Gulati said...
    Got Bored with cheap escorts in Chandigarh?? Meet real high class independent escort girl Chandigarh. Independent Escort in Chandigarh Both incall and outcall escort service available, whatsapp me and book me now by mail.
    fanni said...
    An agency that's great could make certain you have real events which are pleasant utilizing the girl. The girl will probably be charming visible, wise, spectacular and attractive. Ergo, you are particular to enjoy a wise and fascinating dialogue utilizing the girl. Search for obtaining an call girl in Chandigarh that is appropriate just for licensed agencies. Companions in be generalized. They offer providers basing concerning the requirements of the clients.
    kingescorts said...
    We are frequently as well as you while you need to fulfill with this specific escorts it often does not undoubtedly issue.You simply need certainly to fulfill them-and you'll absolutely drop in love that is large. Why don’t possess an excellent period utilizing the attractive chandigarh escorts? We provide a-team of experts who are in a situation make it possible for one properly need the very best choice and to evaluate by everything you create. Your girls likewise talk adept Hindi and Language; they truly are in a situation to work with the town is found out about by you for anyone who is clear in Chandigarh. You simply need certainly to enroll your name and we shall ensure that you're encountering particular.
    Ruby khanna said...
    Saini Saab said...
    kingescorts said...
    Bodily, she remains at 5'5 and is twenty-two years. 96 pounds live, evaluate a small nonetheless exceptionally contour 36B-22-36 and complement totally into a gown size that is ideal ten. (Amazing issues can be found in hardly any packages). She might be a small but proportional skip a perfect shaped physique and twinkling eye to joy. She's been delineated BEING an interesting, titillating elegance using awe-inspiring face that were and kissable fairly mouth that dependably celebrity her tooth that were silvery having a smile that was mischievous.
    Vip escort service in zirakpur
    zirkpur vip escort service
    escort in mohali
    independent escorts in mohali
    panchkula escort
    panchkula escorts service
    Zirakpur Escorts said...
    Rituverma said...
    Rituverma said...
    best Escorts in Mohali Our Escorts Services Charges are very reasonable and comfortable in Mohali, there is no negotiation is possible. we deals on high profile escorts service in Mohali.
    Gurpreet kaur said...
    We possibly may would rather guarantee you of discretion and discernment at all occasions, we often are a specialist agency that preserves discretion and discernment and you will unwind and luxuriate using some of our impartial Chandigarh escorts in your own time. Something, our women may swing be useful using, is the fact that the indisputable fact that anyone’ll be represented by them everywhere you-go. Be perhaps a unique meeting, or it a noisy celebration using buddies with acquaintances, you will be prepared to permanently consider the proven fact that is particular that the female escort that is truly amazing are likely to have the ability to keep consistently the vocabulary heading and everybody the people there fascinated. That certainly will provide a satisfying atmosphere and method you will increase every your self-confidence. This is often that we are able to verify to search out the best independent call girls for the ideal evening and why it is permanently wise cause to get hold of people nowadays.
    Kajal kaur said...
    Besides, many people, who come here for a longer time period due to their business and sport purposes, stay separated from their dear and close to types, from their wives and g girlfriends especially. They become sleepless or a little unbalanced credited to a much longer parting. To make them happy or perfectly revitalize them, Chandigarh independent escorts women have got arrive towards the procedure. With all the single reason for associated all their simply, they provide different types of satisfaction choices to engage in.
    kingescorts said...
    Escorts solutions in Chandigarh are right now good developing providers that can give you erotic happiness and enjoyment designed for couple of charges with a guy or women. Chandigarh Separate Chandigarh female escorts are the greatest for these sensual services and they capable to provide you riles type your depressions and place joy in your existence. A man w ho devotes period with her girlfriends he feels often some special to all people w ho are alone in the party or anywhere. So Chandigarh Escorts leave your aloneness and make your journey filled with ongoing enjoyments and love.
    Gauhar.in said...
    These ravishing w omen have great appears. They have lovely voice and it is plenty of to keep you continually captivating in happiness and romance simply. These are having breeze in form of charm and happiness. The alternative of producing one cool close friends perform can be found in type of companionship. escorts in Chandigarh allow lives to form at the greatest. These are the synonym of joyfulness and jubilance in boring lives ongoing even. Lift up the drapes of a friendly relationship and romance in lives and hug the best occasions of live with these types of girls.
    chandigarhcallgirls said...
    If you are alone and seeking for Independent escorts in Chandigarh, I am among the best Chandigarh take gal you can hire and I guarantee the extremely best Independent escorts in Chandigarh support. I am very content to display off that I possess an extremely tremendous and different characteristics of myself perishing to amuse you. Examine out my gallery to find all of the photos of mine to become guaranteed, how dating girl you are employing to make your night filled with intimating fun.
    amansharma85449 said...
    Alina Chopra said...
    Alina Chopra is an Independent Mahipalpur escort girl. We offering high class Independent escorts service in Mahipalpur for elite peoples in the city.
    call girls in mahipalpur

Post a Comment