topic Re: What is the sort oder when using filter #() ? in Application Development and Automation Discussions

What is the sort oder when using filter #() ?

jrgkraus — Thu, 13 Dec 2018 06:38:55 GMT

I am wondering if filter #( ) produces a defined sort order in its result. If I use for example

types table_type type standard table of line_type<br>  with default key<br>  with non-unique sorted key date components date time.

filtered_table = filter #( full_table using key date where date = today ).
data(first_row) = filtered_table[ 1 ].

Will I get in first_row the entry with the earliest time for that day?

Re: What is the sort oder when using filter #() ?

nabheetscn — Thu, 13 Dec 2018 07:21:44 GMT

Hello Jorg

Yes when you filter using the defined key it sorts and filters it. Try this dummy code

REPORT ztest_cr.
TYPES:BEGIN OF line_type,
        date TYPE sy-datum,
        time TYPE sy-uzeit,
      END OF line_type.
TYPES table_type TYPE STANDARD TABLE OF line_type
  WITH DEFAULT KEY
  WITH NON-UNIQUE SORTED KEY key1 COMPONENTS date time.
DATA:full_table TYPE table_type.
DATA(out) = cl_demo_output=>new( ).
INSERT VALUE #( date = '20181213' time = '071901' ) INTO full_table INDEX 1.
INSERT VALUE #( date = '20181213' time = '071001' ) INTO full_table INDEX 2.
INSERT VALUE #( date = '20181213' time = '071301' ) INTO full_table INDEX 3.
INSERT VALUE #( date = '20181214' time = '071301' ) INTO full_table INDEX 4.
INSERT VALUE #( date = '20181215' time = '071301' ) INTO full_table INDEX 5.
DATA(filtered_table) = FILTER #( full_table USING KEY key1 WHERE date = sy-datum ).
DATA(first_row) = filtered_table[ 1 ].
out->write( first_row ).

Re: What is the sort oder when using filter #() ?

jrgkraus — Thu, 13 Dec 2018 09:06:11 GMT

to nabheet.madan3: Your answer is correct - but since you posted it as comment and not as answer I am not able to accept it. Thanks a lot

Re: What is the sort oder when using filter #() ?

matt — Thu, 13 Dec 2018 12:47:02 GMT

I've asked the moderators to change it to an answer

Re: What is the sort oder when using filter #() ?

iftah_peretz — Sun, 16 Dec 2018 09:26:57 GMT

Hey,

For some reason I can't convert the comment to an answer. I will keep this thread open in case nabheet.madan3 would transform it to an answer and then you can accept it.

Best,

Iftah

Re: What is the sort oder when using filter #() ?

nabheetscn — Sun, 16 Dec 2018 12:09:47 GMT

Converted it to an answer, Thanks.