topic Re: Persistent class Query Ordering in Application Development and Automation Discussions

Persistent class Query Ordering

robert_ktr — Wed, 14 Mar 2018 13:45:41 GMT

Hello...

I am using persistent class for custom logs.

Everything is working OK, but I need one suggestion.

My code:

DATA(lv_query) = cl_os_system=>get_query_manager( )->create_query( i_filter = |APPID = PAR1 AND GUID16 = PAR2| i_ordering = ??? ).

DATA(lt_obj) = /ktr/ca_sys_logs=>agent->if_os_ca_persistency~get_persistent_by_query(i_query = lv_queryi_par1 = _appidi_par2 = _uuid).

For creating the QUERY I use two parameters for APPID and GUID16. and that is for query parameter i_filter. That is OK! For that query I get internal table with more rows and my problem is that I want to sort this table by one column!

I think that parameter I_ORDERING in method create_query is for that purpose....or not?

Can anyone show me an example how to use parameter I_ORDERING syntax?

Thanks in advance!

Best Regards

Robert

Re: Persistent class Query Ordering

retired_member — Wed, 14 Mar 2018 16:45:48 GMT

attr ASCENDING attr DESCENDING ...

https://help.sap.com/http.svc/rc/abapdocu_752_index_htm/7.52/en-US/index.htm?file=abenos_query_comps.htm

https://help.sap.com/http.svc/rc/abapdocu_752_index_htm/7.52/en-US/index.htm?file=abenos_query_sort_cond.htm

Re: Persistent class Query Ordering

robert_ktr — Thu, 15 Mar 2018 08:54:28 GMT

Hello Mr. Keller...

Thank you very much for solution! Now it is working!

DATA(lv_query)   = lv_manager->create_query( i_filter   = |APPID = PAR1 AND GUID16 = PAR2|
                                             i_ordering = |SORTID DESCENDING| ).

Best regards!

Re: Persistent class Query Ordering

retired_member — Thu, 15 Mar 2018 09:41:22 GMT

And I added that to the query example 🙂