Solved

How can I do fuzzy search on text field when queryrecordtype

Forum|Forum|2 years ago
April 23, 2024
8 replies
0 views

How can I do fuzzy search on text field when queryrecordtype, like "like '%text%' " in sql

Best answer by shubhama926776

[mention:2aea1bf0b6954f94815518e79da990c7:e9ed411860ed4f2ba0265705b8793d05]

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)
)

stefanhelzle0001

Brainy

I remember that you are talking to an API to do that. In that case, the API needs to support it directly.

J

jiayingc4832Author

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?

rohitm7223

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.

shubhama926776Answer

Brainy

[mention:2aea1bf0b6954f94815518e79da990c7:e9ed411860ed4f2ba0265705b8793d05]

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)
)

शुभम्

J

jiayingc4832Author

Awesome, thank you!

shubhama926776

Brainy

Is this what you're looking for?

शुभम्

Sign up

Login with SSO

Login to the community

Login with SSO