Synonym based List box

[shyamcharan]

Hi Experts,

I have a requirement where I need to show the values in the list box that matches the synonym words.

For example:

I have a table with synonym words.

SYNONYM:

LOAD * INLINE [

    KeyWord, Synonym

    BW, BAYSWATER

    B Water, BAYSWATER

    LD, LIDDELL

    LDL, LIDDELL

];

FL:

LOAD * INLINE [

    Functional_Location

    Bayswater Power Station

    Bayswater Unit 1

    Bayswater Unit 2

    BW-BAYSWATER

    LIDDELL Power Station

    LD_LIDDELL

];

User would enter something like 'BW' in the Input box. This would in return fetch me the Synonym as BAYSWATER from the Synonym table and I would like to use this to search against the original field Functional location and display only related List of values.

Now, I would like to have a list box Functional Location that matches with the word 'Bayswater' as it has in the synonym table. but not all.

I have tried and attached the same but somehow i am unable to get the wildmatch worked.

Any suggestions on this would be really help ful.

Thank heaps.

Regards,

Shyam.

[perumal_41]

Hi Shyam,

PFA  ,i hope it help you

[shyamcharan]

Hi Jonathan,

Thanks heaps for the help so far. It looks like I am half-way through the requirement.

However, the solution you suggested does not seem to work if there is no entry in the Synonym table with the same key word.

For example: It works only if there is a record in the Synonym Table that has the Keyword and Synonym as same.

Keyword  Synonym

Dog         Dog

I guess this wont be the case all the time. I may not have a table generated in such a way.

Also, the search has to be done on a different column rather on the same Synonym column.

I have attached a QVW where i could not get this worked on the Functional_Location Field list box.

Also, Is there a way I can get the user to enter a string rather one word and get the synonyms for the multiple words in the string and search based on those synonyms.

I know this may be something unachievable but just wondering if there is a way from what we have arrived so far.

Regards,

Shyam

[shyamcharan]

Hi Perumal,

Thanks for the solution and for your effort.

It looks good. But can I get this work if the user enter multiple words?

Also, it does not work if there are multiple Synonyms for the same keyword.

Also it looks like it does not work with the keyword including spaces.

The functional location list box go empty when i enter the keyword 'B Water'

Thanks heaps in advance.

Regards,

Shyam,

[perumal_41]

Hi Shyma,

if  multiple keywords enter  also It will work .in between two key words use & symbol

differentiate

[shyamcharan]

Hi Perumal,

That seems to be working. Thats Great!!!

However, could I get this worked even if the user enters part of the keyword or the Synonym.

It looks like now it is working if the user enters the keyword or even the synonym but it has to be a single word and single word alone not part of the string.

For example:

It works if I have the 'Belt' word alone in KEYWORD or in SYNONYM but it does not work if it is like 'Dog Belt' or 'Belt Fix'.

Also as i mentioned earlier, it would be great if it works with part of KEYWORD or the SYNONYM.

Thanks heaps.

Regards,

Shyam.

[shyamcharan]

Hi Perumal And Gurus,

I have a bit more complex requirement to what the solution have been so far with the help of Perumal.

However, my other requirement would be as below.

Multiple word inputs in the input box, the search need to be done at multiple levels based on the number of words. For example, If I enter BW&LD&.. etc the search should happen with BW based synonym's and then use the second word to search again on the results based on the first word and the again if there is a third word in the input box the search should happen on the result of the second word search.

Its like.

KeyWord one >>Synonym's one>> Results one in List box

KeyWord two>> Synonym's two>> search on (Results one of the List box)=Results two

KeyWord three>> Synonym's three>> search on (Results one of the List box)=Results two)=Results three >> Final for three words in input box.

This has become more complex requirement. Thanks a ton for any help on this.

Regards,

Shyam.