This discussion is archived
1 6 7 8 9 10 14 Previous Next 201 Replies Latest reply: Oct 30, 2007 4:38 AM by 478676 Go to original post RSS
  • 105. Re: APEX 3.1 Enhancements
    PaoloM Newbie
    Currently Being Moderated
    Jes,
    I am already using this approach in my current applications when I want to call APIs in a SUBMIT process, but as you can guess it becomes a real inconvenience when I want to have a simple SQL report on APPS secured views.

    In this case, I have to save the old value from the CLIENT_INFO and set it to 0 (or whatever other number), initialize the HR security in a before regions process, have the region render the report on the secured views, put back the saved value in the CLIENT_INFO in an after regions process and hope that in the meantime I didn't involuntarily break any internal functionality of APEX that relies on the contents of the CLIENT_INFO...

    And this should happen on EVERY page where I want to use reports on secured views.
    Wouldn't be easier not having to worry about the CLIENT_INFO?

    Thanks,
    Paolo
  • 106. Re: APEX 3.1 Enhancements
    Jes Oracle ACE
    Currently Being Moderated
    Hi Paulo,

    Yes but you can wrap up a lot of that into a packaged procedure and then simply call the procedure from a Before Header process, then run your report then reset it in an After Header process, really once you've wrapped it up it's only a couple of processes on the page.
    Wouldn't be easier not having to worry about the CLIENT_INFO?
    But remember, the reason that CLIENT_INFO is being set is because it's useful for debugging APEX apps etc, it's just 'unfortunate' that this is also the method that is being used in your other apps.
  • 107. Re: APEX 3.1 Enhancements
    WilliFirulais Newbie
    Currently Being Moderated
    An "Image" field in the "Region Definition" (like that in the "Create / Edit List Entry") that can also be used in the template for a region.

    That will help create fancy looking applications by not only using a simple text as a region header but also images. And todays applications have to be that.

    Thx, Willi
  • 108. Re: APEX 3.1 Enhancements
    WilliFirulais Newbie
    Currently Being Moderated
    Hallo,

    A concept for modular use of different apex applications as they were a single one.

    E.g. download a discussion forum, a photo album, a ... (they already exists) and using them in addition to a self build application as they were one (e.g. sharing the same theme, authentication, etc. without coping it.)

    Today custom devloped software is mainly driven by assembling software modules (SOA is the glue/adhesive for this). If there where some concepts in Apex reusing modules the community is developing (and there are a lot out of them) this may a huge leverage effekt. The Quicker a cool application can be developed with more (standard) features in it the better all the Apex Developers are in reporting their success.

    Thx Willi

    Btw, i like the "Page 0" concept. Developing Regions there allows to have a "block" like system, where the page 0 regions can be displayed on selected pages. If there could be developed "pages" and then used as "regions" would be very cool.
  • 109. Re: APEX 3.1 Enhancements
    mfuller Newbie
    Currently Being Moderated
    My main enhancement request would be to make the next version compatible with XE.
  • 110. Re: APEX 3.1 Enhancements
    Phil UK Newbie
    Currently Being Moderated
    I am modifying an application and I want to move a region from page x to page y including relevant items and potentially page processes driven by these buttons etc. This would allow even faster app modifications as I am not aware of a way of doing this apart from manually?
    Phil

    Ignore me - just engaged brain and realised I can copy and then delete the original...

    Message was edited by:
    Phil UK
  • 111. Re: APEX 3.1 Enhancements
    538097 Journeyer
    Currently Being Moderated
    Hello

    Is it possible to increase the length of region source (HTML Region). It seems that ApEx use the maximum value of varchar2 for storing source code. It is possible to change it to CLOB?

    Best Regards, Kostya Proskudin
  • 112. Re: APEX 3.1 Enhancements
    WilliFirulais Newbie
    Currently Being Moderated
    Hallo,

    Get a free trial account and have a look at http://www.quickbase.com/p/home.asp

    I know Apex could do all that what is in there - but you have to programm it.

    If there would be some nice new theme in 3.1 that has a lot of that DHTML, AJAX, etc. in it and you can build similar applications as the above mentioned with it (without a lot of programming), this will absolutly bring Apex over Acc*ss in the area of departamental applications.

    See the menu, the nice inline edit, the select lists with a nice option to quick add new values, ...

    Thx, Willi
  • 113. Re: APEX 3.1 Enhancements
    579100 Newbie
    Currently Being Moderated
    One thing I think would be nice in 3.1 is a fix to the bugette when creating a "Form on a Table with a Report" through the create page functions. If you choose to "Use an existing tab set and create a new tab within the existing tab set" for the report page, when you get to the same choice for the form page the new tab created should be available for selection under the "Use an existing tab set and reuse an existing tab within that tab set." choice. In my mind it's logical to group both pages under one tab and nest the breadcrumb for the form page beneath the report page.
  • 114. Re: APEX 3.1 Enhancements
    FintanStack Newbie
    Currently Being Moderated
    I would like to second the following suggestions

    From danusgov

    How about a form based on a collection? The collection's format could be based off a PL/SQL data type, and worked with like a Tabular form.

    It would live in session until it is either purged or stuffed into an appropriate database table.

    And from Heinz

    Beside all already mentioned enhancements I would like to have LOVs and popup LOVs with more than one return-value (like in Oracle Forms !)

    Also how about being able to export a page and import it into a different application to make it easier to release individual pages from a test into a live environment.
  • 115. Re: APEX 3.1 Enhancements
    dsykes Newbie
    Currently Being Moderated
    Just got back from ODTUG in Daytona Beach,FL. Excellent conference. There was
    a lot of buzz and a tremendous amount of energy surrounding APEX. This is the
    most energized ODTUG conference in years. According to Mike Hichwa 3.1
    should be downloadable from this site this week.

    Couple of enhancements for 3.2

    -- Improved Export to csv/spreadsheet. Current csv export is very
    limited in terms of data formatting and protecting (text not numbers
    and/or dates). Have downloaded and implemented
    Tom Kyte's excellent owa_sylk package. Of course this means
    I need to write 2 queries - one for the html output and one for excel.
    Something like this should be integrated into APEX.
    When I say integrated I mean just like one enables the CSV output and link on the report attributes page today.

    -- Easier PDF printing. Have implemented FOP on the 10g app server but
    unhappy with the output. I'm getting lines and text smashing into each other.
    Still going to Oracle Reports for nice PDF
    output. Of course this requires another tool. And no security integration with
    APEX. PLPDF looks promising. I will buy a couple of copies of this in the interim.
    Still I need to write a separate query.


    Dave
  • 116. Re: APEX 3.1 Enhancements
    dsykes Newbie
    Currently Being Moderated
    I have also downloaded and implemented Dene Kubicek's download
    to Excel package. Nice integration with APEX. Here is the link:



    http://htmldb.oracle.com/pls/otn/f?p=31517:108
  • 117. Re: APEX 3.1 Enhancements
    Justin Patterson Explorer
    Currently Being Moderated
    Dave,

    I think you mean 3.01 will be out soon. 3.1 from what I was told, they are pushing for Open World but that isn't a firm date yet.. And from what I saw 3.1 looks awesome!

    Justin
  • 118. Re: APEX 3.1 Enhancements
    445907 Newbie
    Currently Being Moderated
    Thank god that this (for me) very easy but important feature is applied.

    THX!
  • 119. Re: APEX 3.1 Enhancements
    dsykes Newbie
    Currently Being Moderated
    I did mean 3.0.1 not 3.1 Saw some really cool 3.1 features at ODTUG.
    The report filtering (click on Column header go into an AJAXy dialog and
    select the filter value from a pre-populated list) was really neat.


    Dave
1 6 7 8 9 10 14 Previous Next