How can I do fuzzy search on text field when queryrecordtype, like "like '%text%' " in sql
Discussion posts and replies are publicly visible
I remember that you are talking to an API to do that. In that case, the API needs to support it directly.
You can create a Stored Procedure, which can utilize various algo's like , JARO Winkler, Levenshtein etc. on the specific text field in the backend. which can return Primary keys of record. and then you can use those as per your requirement.
fxzrqjzztrmy You can use includes operator
a!queryRecordType( recordType: Replace_RecordYType, filters: a!queryFilter( field: Replace_ FieldName, operator: "includes", value: Replace_Value ), pagingInfo: a!pagingInfo(1, 5000) )
I made a recordtype that connects to the API, the recordtype has snyc all the data from API, I want to query from the recordtype, is it possible to do fuzzy search on recordtype?
Awesome, thank you!
Is this what you're looking for?
yes
Keep in mind that this is only a substring search, no fuzzy search.