Loading...
Integrating ExtJS javascript library with Oracle Application Express
APEX_PUBLIC_USER
Logout
Property
Value
Rows Displayed
10
15
20
25
50
100
200
500
1000
10000
Instructions
View the source for the javascript code to build the customer lookup.
The javascript calls a database procedure:
PROCEDURE customer_lookup
(p_callback varchar2
,p_query varchar2 default null
,p_limit number default 20
,p_start number default 0
,p_customer_id number default null
);
Nothing very tricky on the database side - just a cursor loop, returning records in a JSON format using htp.p statements.
I've rolled my own JSON escape function, but noticed there is one in the
FLOWS_030100.wwv_flow_ajax
package - must investigate this further.
You'll also notice I over-rode some CSS for the interactive report region to make it look more like the rest of the app. Just enough to show it's do-able.
Holiday Log
Cancel
Create
#
Customer
#
Country
-
Afghanistan
Albania, Republic of
Algeria, People's Democratic Republic of
American Samoa
Andorra, Principality of
Angola, Republic of
Anguilla
Antarctica (the territory South of 60 deg S)
Antigua and Barbuda
Argentina, Argentine Republic
Armenia
Aruba
Australia, Commonwealth of
Austria, Republic of
Azerbaijan, Republic of
Bahamas, Commonwealth of the
Bahrain, Kingdom of
Bangladesh, People's Republic of
Barbados
Belarus
Belgium, Kingdom of
Belize
Benin, People's Republic of
Bermuda
Bhutan, Kingdom of
Bolivia, Republic of
Bosnia and Herzegovina
Botswana, Republic of
Bouvet Island (Bouvetoya)
Brazil, Federative Republic of
British Virgin Islands
Brunei Darussalam
Bulgaria, People's Republic of
Burkina Faso
Burundi, Republic of
Cambodia, Kingdom of
Cameroon, United Republic of
Canada
Cape Verde, Republic of
Cayman Islands
Central African Republic
Chad, Republic of
Chile, Republic of
China, People's Republic of
Christmas Island
Cocos (Keeling) Islands
Colombia, Republic of
Comoros, Union of the
Congo, Democratic Republic of
Congo, People's Republic of
Cook Islands
Costa Rica, Republic of
Cote D'Ivoire, Ivory Coast, Republic of the
Croatia, Republic of
Cuba, Republic of
Cyprus, Republic of
Czech Republic
Denmark, Kingdom of
Djibouti, Republic of
Dominica, Commonwealth of
Dominican Republic
Ecuador, Republic of
Egypt, Arab Republic of
El Salvador, Republic of
Equatorial Guinea, Republic of
Eritrea
Estonia
Ethiopia
Falkland Islands (Malvinas)
Faroe Islands
Fiji, Republic of the Fiji Islands
Finland, Republic of
France, French Republic
French Guiana
French Polynesia
French Southern Territories
Gabon, Gabonese Republic
Gambia, Republic of the
Georgia
Germany
Ghana, Republic of
Gibraltar
Greece, Hellenic Republic
Greenland
Grenada
Guadaloupe
Guam
Guatemala, Republic of
Guernsey, Bailiwick of
Guinea, Revolutionary People's Rep'c of
Guinea-Bissau, Republic of
Guyana, Republic of
Haiti, Republic of
Heard and McDonald Islands
Holy See (Vatican City State)
Honduras, Republic of
Hong Kong, Special Administrative Region of China
Hungary, Hungarian People's Republic
Iceland, Republic of
India, Republic of
Indonesia, Republic of
Iran, Islamic Republic of
Iraq, Republic of
Ireland
Isle of Man
Israel, State of
Italy, Italian Republic
Jamaica
Japan
Jersey, Bailiwick of
Jordan, Hashemite Kingdom of
Kazakhstan, Republic of
Kenya, Republic of
Kiribati, Republic of
Korea, Democratic People's Republic of
Korea, Republic of
Kuwait, State of
Kyrgyz Republic
Lao People's Democratic Republic
Latvia
Lebanon, Lebanese Republic
Lesotho, Kingdom of
Liberia, Republic of
Libyan Arab Jamahiriya
Liechtenstein, Principality of
Lithuania
Luxembourg, Grand Duchy of
Macao, Special Administrative Region of China
Macedonia, the former Yugoslav Republic of
Madagascar, Republic of
Malawi, Republic of
Malaysia
Maldives, Republic of
Mali, Republic of
Malta, Republic of
Marshall Islands
Martinique
Mauritania, Islamic Republic of
Mauritius
Mayotte
Mexico, United Mexican States
Micronesia, Federated States of
Moldova, Republic of
Monaco, Principality of
Mongolia, Mongolian People's Republic
Montenegro, Republic of
Montserrat
Morocco, Kingdom of
Mozambique, People's Republic of
Myanmar
Namibia
Nauru, Republic of
Nepal, Kingdom of
Netherlands Antilles
Netherlands, Kingdom of the
New Caledonia
New Zealand
Nicaragua, Republic of
Niger, Republic of the
Nigeria, Federal Republic of
Niue, Republic of
Norfolk Island
Northern Mariana Islands
Norway, Kingdom of
Oman, Sultanate of
Pakistan, Islamic Republic of
Palau
Palestinian Territory, Occupied
Panama, Republic of
Papua New Guinea
Paraguay, Republic of
Peru, Republic of
Philippines, Republic of the
Pitcairn Island
Poland, Polish People's Republic
Portugal, Portuguese Republic
Puerto Rico
Qatar, State of
Reunion
Romania, Socialist Republic of
Russian Federation
Rwanda, Rwandese Republic
Samoa, Independent State of
San Marino, Republic of
Sao Tome and Principe, Democratic Republic of
Saudi Arabia, Kingdom of
Senegal, Republic of
Serbia, Republic of
Seychelles, Republic of
Sierra Leone, Republic of
Singapore, Republic of
Slovakia (Slovak Republic)
Slovenia
Solomon Islands
Somalia, Somali Republic
South Africa, Republic of
South Georgia and the South Sandwich Islands
Spain, Spanish State
Sri Lanka, Democratic Socialist Republic of
St. Helena
St. Kitts and Nevis
St. Lucia
St. Pierre and Miquelon
St. Vincent and the Grenadines
Sudan, Democratic Republic of the
Suriname, Republic of
Svalbard and Jan Mayen Islands
Swaziland, Kingdom of
Sweden, Kingdom of
Switzerland, Swiss Confederation
Syrian Arab Republic
Taiwan, Province of China
Tajikistan
Tanzania, United Republic of
Thailand, Kingdom of
Timor-Leste, Democratic Republic of
Togo, Togolese Republic
Tokelau (Tokelau Islands)
Tonga, Kingdom of
Trinidad and Tobago, Republic of
Tunisia, Republic of
Turkey, Republic of
Turkmenistan
Turks and Caicos Islands
Tuvalu
US Virgin Islands
Uganda, Republic of
Ukraine
United Arab Emirates
United Kingdom of Great Britain and N. Ireland
United States Minor Outlying Islands
United States of America
Uruguay, Eastern Republic of
Uzbekistan
Vanuatu
Venezuela, Bolivarian Republic of
Viet Nam, Socialist Republic of
Wallis and Futuna Islands
Western Sahara
Yemen
Zambia, Republic of
Zimbabwe
Åland Islands
Holiday Start
Holiday End
Holiday Description
Page Comments
Author
Comment
Nice work Mark!
I try to use this sample to build a search field on a standard ApEx LIST ITEM, but I have problems to view items listed, anche the stored data when I go to edit a record...any suggestion?
sihem
it is very nice good application;thank you very much for your help......
regards sihem
ads
adsasdad
sgsfdf
sdvsdfds
CineQ
test
Partha
If you minimize the "more information" and maximize it again (or resize the region), then, the Options in Interactive reports is not displayed properly;
Me Myself and I
Nice interface
I like this editor
popol
very good job
hi
nice stuff
me
Yeah
!
natasa
Bravo!
Thor
Very nice
Max
Dude, this is very good stuff!
ddd
very smart
test
test
1 - 15
Rows
1
5
10
15
20
25
30
50
100
200
500
1000
5000
All
Select Columns
Filter
Sort
Control Break
Highlight
Compute
Aggregate
Chart
Flashback
Reset
Help
Download
Customer
Home Address
Destination
Holiday Start
Holiday End
Description
kkkkkk, Angela
15 Joffre St 000000 WESTERN CREEK TAS 7304
France, French Republic
16-FEB-2009
28-OCT-2009
-
Doe, sdsdfsd
Main Street sdfsdfdfd 568 YO
Anguilla
18-FEB-2009
16-FEB-2009
jg
Abelaaff, Ellena 235 srt
29 Elizabeth Road's Street 30 SANDSTRON234 CA 6639713
United States of America
-
-
-
cabarkapa, vukosav
2/482-484 Sandy Bay Rd fsdsdfsd DARLINGHURST NSW 1300
Andorra, Principality of
10-FEB-2009
28-FEB-2009
-
Abelaaff, Ellena 235 srt
29 Elizabeth Road's Street 30 SANDSTRON234 CA 6639713
Marshall Islands
20-FEB-2009
28-FEB-2009
-
aaa, aaa
-
Afghanistan
19-FEB-2009
20-FEB-2009
kurzurlaub - vermutlich nicht erholsam
Abelaaff, Ellena 235 srt
29 Elizabeth Road's Street 30 SANDSTRON234 CA 6639713
Haiti, Republic of
10-FEB-2009
27-FEB-2009
-
Adams, RFQWADGVAER
254 Bathurst Street ff SEACOMBE GARDENS ny 5047
Angola, Republic of
-
-
-
Smith, Bernadette
24 Tingira Rd PARRAWEENA NSW 2339
Antigua and Barbuda
-
-
-
kkkkkk, Angela
15 Joffre St 000000 WESTERN CREEK TAS 7304
Afghanistan
26-FEB-2009
26-MAY-2009
Not so good
Adams, RFQWADGVAER
254 Bathurst Street ff SEACOMBE GARDENS ny 5047
Aruba
26-FEB-2009
27-FEB-2009
test
Adamsss, Claret
Wqwser test by visitor2 NOONBI NSW 2794
Andorra, Principality of
18-FEB-2009
26-FEB-2009
qsswsd
kkkkkk, Angela
15 Joffre St 000000 WESTERN CREEK TAS 7304
Russian Federation
01-MAR-2009
04-MAR-2009
FDFDFDFDFDF
kkkkkk, Angela
15 Joffre St 000000 WESTERN CREEK TAS 7304
Albania, Republic of
-
-
-
kkkkkk, Angela
15 Joffre St 000000 WESTERN CREEK TAS 7304
Angola, Republic of
03-MAR-2009
14-OCT-2009
-
1 - 15
Page Ref: 200801:2007
Generate: 0.40
Release 1.0
©2008 Mark Lancaster. All rights reserved.
Loading...