Skip to main content
jyotim0995
jyotim0995
Participating Frequently
Apr 11, 2023 9:16 AM UTC
Question

Fuzzy Logic Search

Hi I have a requirement to implement a fuzzy logic search in Appian. How can we implement it?

5 replies

stefanhelzle0001
stefanhelzle0001
Brainy
Apr 11, 2023 9:25 AM UTC

You could use full-text indexing and the match function in MariaDB and expose it to Appian in a view or stored procedure.

stewart.burchell
stewart.burchell
Employee
Apr 11, 2023 9:47 AM UTC

Depending on what level of searching is required and exactly what it is you want to search on you could integrate with something like ElasticSearch, which is designed to index a wide range of data sources, scales and performs at an Enterprise Level and offers Fuzzy Query capability.

stefanhelzle0001
stefanhelzle0001
Brainy
Apr 11, 2023 9:50 AM UTC

I used Apache Solr at a client with huge success. It is a ready-to-use search appliance that, depending on your environment and requirements, can easily be used with Appian.

https://solr.apache.org

jyotim0995
jyotim0995Author
Participating Frequently
Apr 11, 2023 9:57 AM UTC

[mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] Thanks for the suggestion! Do we need license for integrating with Appian? Do we have a plugin for Solr? I want to implement fuzzy search for a cloud instance. At present we do not have a budget for licensing.

Terms & ConditionsAccessibility statement