Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Tricky: Column sort with Popup-key LOV

614097Feb 8 2008 — edited Feb 27 2009
Hi everyone,

I guess this is a tricky one:
Column sorting doesn't seem to work if you have a Popupkey LOV in your tabular form.

See the following example:
http://quickimg.com/uploads/f6388ab3680bdeac63cb8795a98d81fe.png

(The yellow fields you see are form detail information displayed by the Firefox Extension Web Developer Toolbar, highly recommendable, by the way)

The form element names now are in the right order (00, 01, 02, 03 ...).

However, if you sort the table by Column 1 (Source) this order gets tumbled:
http://quickimg.com/uploads/93b976c603132db84fc8881211617718.png

That's quite some problem because the Key returned by the popup refers to the ROWNUM which does not correlate with the correct row anymore.

Anyone got an idea how to workaround this problem?

cheers,

Michael

Comments

Marc Sewtz-Oracle

Hi - I have not heard of performance issues with tabular forms using IE before. Is this just a plain, standard, wizard-generated tabular form? Perhaps you could re-create a tabular form page that has these issues in a workspace on apex.oracle.com and point me to that example, so I can take a close look at what might be causing this?

Thanks,

Marc

Turlock22

Hi Marc

Thanks for coming back, I tried to recreate the issue on apex.oracle.com but the issue won't replicate in 5.1, my current version is 5.0.4, is there a version of that available for testing?

Yeah the issue is with a completely bog standard MRU table, so I get a hundred row table with about 10 columns (although really doesn't need that many rows at all), include all columns for updating and as I scroll through the page the browser slows down to bits.

It only happens when I scroll over the MRU table, so further down the table there's charts etc, once the MRU's are off the screen everything speeds right up

Hard to show it without a demo, I'll look into upgrading to 5.1 but that probably won't be for a while

Turlock22

Oh and just to confirm I've installed Fiddler to monitor web traffic and when it's going slow there's no traffic going up and down, so it literally just seems to be a rendering issue with the screen in IE, very odd :/

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 27 2009
Added on Feb 8 2008
#apex-discussions
9 comments
2,309 views