I wrote a blog entry on my company’s Blog about deploying Application Express applications. It describes the pitfalls on manual and automatic deployment, and hopefully some useful tips.
If you have any comments or questions, feel free to place a comment and I’ll update the blog.
In Application Express, there is no standard way of copying users in an existing workspace to a new workspace. Everytime you create a new workspace, all developers and users must be added manually.
Here’s a little script that does the work for you. Just replace the WORKSPACE with the name of your own workspace where you want to copy the users from, and execute in a SQL Command window in a new workspace. Might save you some time!
declare cursor c_usr is select t.user_name, t.first_name, t.last_name, t.email_address , t.default_schema , fd.developer_role from APEX_040100.WWV_FLOW_FND_USER t join apex_040100.wwv_flow_developers fd on fd.user_id = t.user_id where t.security_group_id = ( select cp.PROVISIONING_COMPANY_ID from apex_040100.wwv_flow_companies cp where cp.short_name = 'WORKSPACE') ; begin for r_usr in c_usr loop APEX_UTIL.CREATE_USER( p_user_name => r_usr.user_name , p_first_name => r_usr.first_name, p_last_name => r_usr.last_name, p_description => null, p_email_address => r_usr.email_address, p_web_password => 'Welkom01', p_developer_privs => r_usr.developer_role, p_default_schema => r_usr.default_schema, p_allow_access_to_schemas => null, p_change_password_on_first_use => 'Y' ); end loop; end;
A question often asked by users, is the addition of tooltips with extended functions (like line breaks or formatting) to Application Express. There is no default functionality in Apex for that, other than the standard alt or title tag in HTML, which I think is rather boring.
There is a more versatile and nice looking alternative for that, called qTip2. It’s an extension for JQuery, which is already incorporated in Apex since version 4.0.
I found it a little challenging to get qTip2 working in Apex, so here’s a how-to for you.
- go to the Edit Page section and add this to the HTML Header Atribute :
<link type="text/css" rel="stylesheet" href="#WORKSPACE_IMAGES#jquery.qtip-2.0.0.css" />
- Add this to the Footer Text Attribute a little lower:
- And add this code to the Function and Global Variable Declaration. It replaces the standard title attributes with the qTip attribute. Mind you: alltitle attributes on the page. That’s ok, it ensures a consistent look of your tooltips on the page.
- Now let’s give it a try. Create a new Text item on your page, and put this in the Label attribute:
<a href="#" title="Your <i>custom</i> label Tooltip">A tooltip label</a>
- And look at the result:
Of course you can also use the syntax used in step 7 in other parts of your page, like report headers, poplists or just plain text.
Here are 2 simple tips for Application Express. Watch the short videos for a hands-on tutorial.
1) creating a Shared LOV from a LOV in an item.
This is especially useful if you created an item LOV and discover you want to use it in othet places too.
2) Create a dynamic autocomplete field.