on 01-11-2024 4:31 PM
In a UI5 app some filters are set like
new oFilter("lastName", oFilterOperator.Contains, oParams.name),
new oFilter("firstName", oFilterOperator.Contains, oParams.name),
new oFilter("companyName", oFilterOperator.Contains, oParams.name)
In the cds entity fuzzy search is enabled on database level like
@sql.append: 'FUZZY SEARCH INDEX ON'
firstName : String default '';
@sql.append: 'FUZZY SEARCH INDEX ON'
lastName : String default '';
@sql.append: 'FUZZY SEARCH INDEX ON'
companyName : String default '';
SELECT * FROM Dummy where CONTAINS(lastName, 'Companie', FUZZY (0.8))
Another solution is like the one below.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
75 | |
9 | |
8 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.