topic Re: VIEW_MAINTENANCE_CALL and SORT in Application Development and Automation Discussions

VIEW_MAINTENANCE_CALL and SORT

Former Member — Tue, 26 Feb 2008 10:52:16 GMT

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

Re: VIEW_MAINTENANCE_CALL and SORT

Former Member — Tue, 26 Feb 2008 12:09:36 GMT

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.

Re: VIEW_MAINTENANCE_CALL and SORT

Former Member — Tue, 26 Feb 2008 17:20:00 GMT

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

Re: VIEW_MAINTENANCE_CALL and SORT

Former Member — Fri, 25 Apr 2008 11:59:41 GMT

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