Example of using Lawson Filters?

 3 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
Karl Kemp
Basic Member Send Private Message
Posts: 20
Basic Member

Was wondering if anyone had an example they would like to share of using the Lawson API's to do Index Filtering ala 890 INDEX FILTER API's

What I am trying to do in an online inquiry app is to provide the user with the ability to look up an item via the vendor item description where the user may only know part of what the actual description would be.

As an example, a simple oracle sql query where the user might know that the description contained "BAT" would be:

select * from itemmast where ven_item_desc like '%BAT%'

It looks like the 890 INDEX FILTER API's should allow you to do this, but I have yet to get this to work.

Or, maybe you have another solution?

 

Thanks!

John Henley
Send Private Message
Posts: 3355
If you have 9.0 apps, look at MA67.
Thanks for using the LawsonGuru.com forums!
John
Karl Kemp
Basic Member Send Private Message
Posts: 20
Basic Member

We're on 8.1.6

John Henley
Send Private Message
Posts: 3355
You probably have the code, look at MA67PD and search for LIKE.
Thanks for using the LawsonGuru.com forums!
John