Wednesday, February 13, 2008

ExtJS Ajax Search field

Here is a screenshot of an AJAX search field running in Apex. Putting an example up on the Oracle Apex demo site may not be possible, as I call a PL/SQL package directly. It's based on the ExtJS live search sample. We were running it with Ext version 1.1, but had issues with paging. By default it uses "start" and "limit" as parameters - both reserved words with PL/SQL. If you search the Ext forums, you'll find a solution for Ext 2.0 - just search for mark.lancaster.
Posted by Mark Lancaster at 6:09 AM

6 comments:

Patrick Wolf said...

Mark,

there should be no problem to create a package/procedure on apex.oracle.com. Just grant it to apex_public_user or public as you would normally do.

Patrick

February 13, 2008 7:28 AM
Patrick Wolf said...

BTW, this posting has no title... :-)

February 13, 2008 7:30 AM
Mark Lancaster said...

Hi Patrick

Thanks for the tip on packages, I'll try it out soon.

Sometimes I make assumptions without investigating first :)

February 13, 2008 2:59 PM
Satheesh Kumar said...

Nice work.

I tried to test the same on my apex page. But I am getting some error message "invalid label".

I have used same procedure that u mentioned. Below I have pasted the json data ( pl/sql procedure output)

{"totalRows":4,"rowset":[ {"id":"1", "customer":"Test","address":"Manama","locality":"Test","email":"Test@gmail.com"}, {"id":"2", "customer":"Test Hi","address":"Manama","locality":"Test","email":"Test@gmail.com"}, {"id":"3", "customer":"Test and Test","address":"Manama","locality":"Test","email":"Test@gmail.com"} ] }

June 11, 2008 5:53 AM
Satheesh Kumar said...

I found the problem.

Once again thx

June 11, 2008 11:39 PM
Seek said...
This post has been removed by the author.
November 12, 2009 8:19 AM

Post a Comment

Subscribe to: Post Comments (Atom)