How did those MBS functions fail for you?
problem might remain, You could have infinity text...
- create an ID for each product
- create a value list with ID and name
- select/search via popup list based on that value list..
- You can have popup-lists depending on 'pre-selection', ie select first BMW 420d, them all models of that type..
1 of 1 people found this helpful
Here are two example files that explore a number of methods less ambitious than those MBS functions for selecting from a list of values. They come with detailed documentation and a working example of each technique. You may find a method in one of these two files to your liking.
you can also try == search
I found something after a longer serach. Its calles Elasticsearch and can be installed unter Win or Mac locally and be used with FM with a API.
I am not so far that i have a ready API client using MBS Plug-in but so far I did some things with command prompt and its great.
Is has scoring, fuzzylogic and you can rate things.
Anyone has a API acees to it readdy programmed?
When I did a websearch on the name, Text.LevenshteinDistance sounded like something that could be used with a filtered search portal in place of the "partial text matching" that I use in the Adventures #2 file.
Assuming that it returns a value from 0 to 1, 1 a perfect match, you could use such a function to compare the text in a global search field with the text in the portal's table with an expression that compares the resulting "score" to a threshold value such as Text.LevenshteinDistance ( globalSearchFIeld ; Portal::TextField ) > 0.8
I'm not familiar with the exact syntax of this function so you may have to modify what I show here to use the correct syntax for that external function.
You could also sort the portal on this score to put most closely matching values at the top of the list.
This is why I asked why those MBS functions didn't work for you, but you never answered my question.