Query in Search Help

[Former Member]

Hi Gurus,

we have a custom elementry search help. It uses a view , which is a combination of 5 tables. Now I need to change the logic of this search help as below.

If there are entries found in 1st table with combination of a 6th (another table) table. then Search help has to pick the values form that combination. else it has to pick the values from the first 5 tables combination.(i.e. the old logic)

Can we create a new view in combination with the view(which has 5 tables) and with the 6th table?

or how we have to write the code in exit?

Please suggest the best way to get the output. this is the first time am working on search helps.

Awaiting your response.

Regards

Hanu M

[Former Member]

Hi Gurus,

we have a custom elementry search help. It uses a view , which is a combination of 5 tables. Now I need to change the logic of this search help as below.

If there are entries found in 1st table with combination of a 6th (another table) table. then Search help has to pick the values form that combination. else it has to pick the values from the first 5 tables combination.(i.e. the old logic)

Can we create a new view in combination with the view(which has 5 tables) and with the 6th table?

or how we have to write the code in exit?

Please suggest the best way to get the output. this is the first time am working on search helps.

Awaiting your response.

Regards

Hanu M

[Former Member]

Hi

If there are entries found in 1st table with combination of a 6th (another table) table. then Search help has to pick the values form that combination. else it has to pick the values from the first 5 tables combination.(i.e. the old logic)

So u must create a new view so that search help can be used to gather data from the views those having common data.

[Former Member]

Hi

If I create a new view with all 6 tables then it will be intersection of all tables.

But here my requirement is combination of first five tables union 1st table and 6th table. Here I need to give priority to 1st table and 6th table combination, if that record not found then I have to fetch data on first 5 tables join conditions.

Please suggest.

Regards

Hanu M

[Former Member]

Hello Hanu,

As per my understanding, you create a separate view on Table 1 and 6.

Then in the Search help exit, in the SELECT command, write ur code to check that if data found in the view for Table 1 and 6, display that else fetch the data from the other view.

Hope this helps,

Regards,

Himanshu

[nabheetscn]

Hi,

Use the concept of search help exit. Go to your search help and you will see a place to enter your search help exit. Write the code in the function module.

Hope it helps.

Nabheet