Example of using Lawson Filters?

 3 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
Karl Kemp
Basic Member
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
    Posts: 3353
      If you have 9.0 apps, look at MA67.
      Thanks for using the LawsonGuru.com forums!
      John
      Karl Kemp
      Basic Member
      Posts: 20
      Basic Member

        We're on 8.1.6

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