Hi I have a requirement to implement a fuzzy logic search in Appian. How can we implement it?
Discussion posts and replies are publicly visible
You could use full-text indexing and the match function in MariaDB and expose it to Appian in a view or stored procedure.
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.
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
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.
Solr is open source. But you need to host it somewhere. To connect to Appian, you will either need the data streaming of the higher priced support levels, or implement an API that exposes the data to Solr.
Appian talks to Solr via web API.