on 2024 Nov 12 3:49 PM
Using 'Search' annotation we have exposed some fields data to be searched.
@search.searchable: true
@search.defaultSearchElement: true
@search.fuzzinessThreshold: 0.9
@search.ranking: #HIGH
In the CDS, 2 levels down we have used built-in function CURRENCY_CONVERSION to convert the price value depending on the currency type. Because of this, the search functionality is dumping. We have not used 'Search' annotation on this field (and subsequent fields using this field), but still it is producing error.
Appreciate any help on this.
cast( currency_conversion (
amount => final_margin,
source_currency => currency,
target_currency => cast('US$' as abap.cuky( 5 )),
exchange_rate_date => valid_from,
round => '',
error_handling => 'SET_TO_NULL'
) as zrpd_final_margin ) as Final_MarginUSD,
Request clarification before answering.
No. In the backend, it generates Native HANA sql for the search and we get a dump. There is no useful information in the termination result on why it happened.
If we comment the built-in function currency_conversion and then search, we get the search results back.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
77 | |
30 | |
10 | |
8 | |
8 | |
7 | |
7 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.