cds-dbs icon indicating copy to clipboard operation
cds-dbs copied to clipboard

feat(search): enable deep search with path expressions

Open patricebender opened this issue 10 months ago • 0 comments

support search via path expressions:

  • deep search via associations
  • include calculated elements if explicitly requested

to make this work, a non-enumerable searchTerm is attached to the SELECT.search object during inital infer call. The columns which should be searchable must be calculated early because the references need to be considered while building the joinTree for the given query.

In cqn4sql the fully linked search refs are then transformed as a regular function.


rework of https://github.com/cap-js/cds-dbs/pull/252

patricebender avatar Apr 16 '24 17:04 patricebender