Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » change apex 2.1 interface settings (apex 2.1, oracle 10g xe )
change apex 2.1 interface settings [message #523245] Fri, 16 September 2011 06:39 Go to next message
hudo
Messages: 165
Registered: May 2004
Senior Member
How can I change the apex 2.1 interface settings permanently ?

I like the view "details" instead of "icons"
and at least 100 displayed rows/items instead of the default 15


Re: change apex 2.1 interface settings [message #530173 is a reply to message #523245] Sat, 05 November 2011 20:43 Go to previous messageGo to next message
hudo
Messages: 165
Registered: May 2004
Senior Member
Is it not possible to customize this parameters somewhere ?
Re: change apex 2.1 interface settings [message #530182 is a reply to message #530173] Sun, 06 November 2011 00:59 Go to previous messageGo to next message
Littlefoot
Messages: 21612
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, there's no such an option, which would allow you to set the default number of records (for all newly created reports).

However: I never used that Apex version, but ... you might check whether the following exists in yours (I would say it does): in SQL*Plus, connect to APEX_xxxxxx user (in higher, 3.2 version, its name is APEX_030200 so I suppose your user name is APEX_020100). It contains the WWV_FLOW_WORKSHEET_RPTS table which contains the DISPLAY_ROWS column. A simple UPDATE statement would modify number of records for all existing reports (or, if you include a WHERE clause, you could restrict which ones to modify (or not)):
update wwv_flow_worksheet_rpts set
  display_rows = 100
  where ...

You should save this statement for future use (or, obviously, modify that number while creating a new report).

As of modifying default view settings (i.e. details instead of icons), it is available in Apex 3.x version (once connected to Apex, you'd go to Application Builder, follow the "Developer preferences" task link and change "Set view mode" value. No idea about your version.

Re: change apex 2.1 interface settings [message #530186 is a reply to message #530182] Sun, 06 November 2011 07:28 Go to previous messageGo to next message
hudo
Messages: 165
Registered: May 2004
Senior Member
Littlefoot,

thanks for your reply.

I connected as SYSTEM and inspected all tables owned by FLOWS_020100, the mentioned WWV_FLOW_WORKSHEET_RPTS table is not present here. At least you gave me an idea of a basic approach.

Am I right, that SYSTEM is able to perform the mentioned update ?
Re: change apex 2.1 interface settings [message #530194 is a reply to message #530186] Sun, 06 November 2011 12:49 Go to previous message
Littlefoot
Messages: 21612
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Yes, SYSTEM should be able to do that; you'd have to precede table name with owner's name, such as
update apex_user.that_table set
  some_column = 100
where ...
Previous Topic: Report Query displays no data
Next Topic: change login page and logout_url
Goto Forum:
  


Current Time: Tue Oct 27 05:10:44 CDT 2020