on 2023 Feb 15 10:12 AM
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.
thanks work, it's little uncomfortable must be add all field without date/time.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
67 | |
10 | |
10 | |
10 | |
7 | |
7 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.