VIEW_MAINTENANCE_CALL and SORT

[Former Member]

Hey everyone.

I'm using VIEW_MAINTENANCE_CALL to display/change entries from a client table.

Is there any way i can sort the entries before displaying it?

Thanks,

Mário

[Former Member]

Hey everyone.

I'm using VIEW_MAINTENANCE_CALL to display/change entries from a client table.

Is there any way i can sort the entries before displaying it?

Thanks,

Mário

[Former Member]

Hi Mario,

I think it is not possible to use directly sort for this FM, but one thing you can do is you can always pass the selection criteria to this function module using TABLE parameter DBA_SELLIST. Please see if it is useful. You can find the documentation for this as well.

[Former Member]

That would only select a given set of fields, right?

Maybe i can do it within one Modification -> Events in table maintenance generator ...

Thanks for your input.

Edited by: Mario Semedo on Feb 26, 2008 5:23 PM

[Former Member]

Hi Mario,

View maintenance does not largely support SORT functionality, as it often deals with hexadecimal data. When you call the module VIEW_MAINTENANCE_CALL, there are no options to specify a sort sequence here. The data displayed subsequently in the view screens is by default sorted based on the Key Fields of the table/view.

But what you could try doing is this - goto the generated coding of the view/table, and you programmatically modify the sorting order on the display screen, but without affecting the key-fields. Or, you could use the Events to change the logic as well.

Cheers,

Rekha