OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » change apex 2.1 interface settings

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » change apex 2.1 interface settings (apex 2.1, oracle 10g xe )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

change apex 2.1 interface settings [message #523245]

Fri, 16 September 2011 06:39

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

Report message to a moderator

Re: change apex 2.1 interface settings [message #530173 is a reply to message #523245]

Sat, 05 November 2011 20:43

hudo
Messages: 165
Registered: May 2004

Senior Member

Is it not possible to customize this parameters somewhere ?

Report message to a moderator

Re: change apex 2.1 interface settings [message #530182 is a reply to message #530173]

Sun, 06 November 2011 00:59

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: change apex 2.1 interface settings [message #530186 is a reply to message #530182]

Sun, 06 November 2011 07:28

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 ?

Report message to a moderator

Re: change apex 2.1 interface settings [message #530194 is a reply to message #530186]

Sun, 06 November 2011 12:49

Littlefoot
Messages: 21823
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 ...

Report message to a moderator

Previous Topic:	Report Query displays no data
Next Topic:	change login page and logout_url

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 05 21:25:12 CST 2025