Error about search Free text on FPM SADL data source CDS with timestamp cast to date/time field

[MassimoX]

I have CDS with timestamp cast to date/time fields for better selection and filter(FPM_SADL_SEARCH) and work very fine FPM SADL,Timestamp is not very user friendly for search.

CDS code:

      created_at,
      cast( tstmp_to_dats( created_at, abap_system_timezone( $session.client,'NULL' ), $session.client,'NULL' ) as cr_date )    as crea_date,
      cast( tstmp_to_tims( created_at, abap_system_timezone( $session.client,'NULL' ), $session.client,'NULL' ) as createtime ) as crea_time,
      created_by,
      changed_at,
      cast( tstmp_to_dats( changed_at, abap_system_timezone( $session.client,'NULL' ), $session.client,'NULL' ) as cfaedtm )    as lchg_date,
      cast( tstmp_to_tims( changed_at, abap_system_timezone( $session.client,'NULL' ), $session.client,'NULL' ) as aenzt )      as lchg_time,

But when try search with free text (FPM_SADL_FREE_TEXT_SEARCH_TERM) with "test"

occurred this dump:

Remove fields date/time from CDS, free text work without problem.

There are some CDS annotation to fix error? or SADL parameter?

Thanks.

[MassimoX]

thanks work, it's little uncomfortable must be add all field without date/time.

[Katja_Ohliger]

Hello,

you might try to redefine method MODIFY_SEARCH_SCOPE. In this method you define the fields which should be included in the search and exclude the date / time fields.

Best regards, Katja