BlogBlogtypeA post on somebody's own site or a community platform. Nobody edits it after publication, so it dates from the day it was written.See every one →SAP Community

Improved Search Performance in SAP BTP Core, SAP Cloud Application Programming Model, Node.js Runtime

Explains CDS version 5's @cds.search annotation, which lets a service declare which elements a search query covers, and states that only String-typed elements are searched by default so the generated SQL stays simple. Covers two further changes to @sap/cds's Node.js runtime: metadata about which elements are searchable is now cached, and search over localized text can resolve at query time instead of through a compiled view, avoiding a coalesce function that blocks filter push-down on SAP HANA. Also describes an experimental toggle, cds.env.features.optimized_search, that lets the runtime choose the CONTAINS predicate over LIKE for large data sets.

written for artifact:sap-cds 5

Where it sits

Explains
SearchCAPSearchcapabilityFree-text search across an entity and its compositions, pushed into the database rather than filtered in the service. Declared search, database similarity search and filtering in application code are often lumped together.
Source
reachable

Who is behind it

Arley Triana MorinArley Triana MorinPersonWrote this
In the atlas: contributes to 9, wrote 1
@arleytm
author

Properties

About this work

declared and crawled
Published
declared
Published on
declared
Views
crawled
4,110

For search

on the edge
Applies in
authored
cap

More on this3

Group by
Piece, what it offersStill applies
Also explainingSearch3
Building an SAP BTP Agent Architecture from Scratch: Python + CAP + HANA
SAP Community, neilaspin
nothing recorded
Understanding Fuzzy Search in SAP Fiori Applications
SAP Community, Ruchi5
nothing recorded
Case-insensitive filters in Fiori Elements (List report + CAP)
SAP Community, Kishannaicker
nothing recorded

Details

Graph4 edges
← POINTS HERE
POINTS OUT →
explainsSearchcapability, core and community
published onSAP Communitypublishing source
discovered viaSAP Communitycap-tag
Source
Type
blog
Published on
Host
community.sap.com
First seen
History2
  • explains → applies_to on capability:search (cap)Door scope proposed from the title and summary, so a door page lists the piece only where it holds (docs/concepts/content-on-doors.md).
  • Entered the atlasDiscovered via SAP Community · cap-tag.
For your agent
Ref
content:improved-search-performance-in-sap-btp-core-sap-cloud-application-programming-mo
JSON
/content/improved-search-performance-in-sap-btp-core-sap-cloud-application-programming-mo.json
MCP
Connecting an agent