GL Code Contains Lookups

[Stan-Lyn, Stanley Barnett]

Hi Richard,

An index would be of no value here as it needs to search the tags field's entire contents to see if what the user has entered is contained anywhere in the tags field.  Then a sorted selectable scrollable combobox containing all the matching records is presented to the user for selection.  

Using an incremental search would even be better whereas the results dialog gets updated as each letter is typed into the search dialog. 

GL Table Example:
Field list: gl_code, gl_desc, tags (delimited and I'm using a suffix of "-" in the examples below used for humans only when adding the tags...

a. 1234-1234, GASOLINE, gasoline- fuel- gasoline- truck stop- convience store- exxon- marathon- shell- oil- kerosene- diesel- bp- kwik- business- and more...
b. 4567-1127, LODGING, motel- hotel- extended stay- Super8- Marriot- Days Inn- Motel 6- business- and more...
c. 1452-9987, OFFICE SUPPLIES, paper- pens- toner- pencils- folders- briefcase- legal pads- business cards- and .... 

When user is in AP field that needs the gl_code inserted and hits a hotkey which triggers an input search dialog prompting the user to enter a tag.  The user enters "exxon" and the resulting scrollable dialog would only contain one record which is "a." above.

If the user enters "business", then the dialog would have all 3 records (a., b., c.) above available for selection in the drop down dialog to choose the one they want, because the string "business" can be found in all 3 record's tag field.  However, if the user enters "business c", then only c. would show as it is the only one that matches.   

My version of filepro is 5.0.14d on SCO os5.  What filepro version is needed to pull this off?

Thanks,
Stanley



-----Original Message-----
From: Richard Kreiss <rkreiss at gccconsulting.net> 
Sent: Friday, October 18, 2019 2:47 PM
To: Stan-Lyn, Stanley Barnett <stanley at stanlyn.com>
Subject: RE: GL Code Contains Lookups

That would depend on the version of filePro you are running.

1. is there an index on your Tags field?

Richard Kreiss

> -----Original Message-----
> From: Filepro-list 
> <filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com>
> On Behalf Of Stan-Lyn, Stanley Barnett via Filepro-list
> Sent: Friday, October 18, 2019 3:33 AM
> To: Filepro-list at lists.celestial.com
> Subject: GL Code Contains Lookups
> 
> Hi,
> 
> 
> I'm trying to come up with an easy way to do a GL code lookup by a tag name.
> The idea here is the GL table has a long field named "tags" where tag 
> names will be added in any order.
> 
> 
> 
> Then when the user triggers a lookup via a hot key within the accounts 
> payable form, it presents the user with an input popup that receives a 
> value from the user to search for.  That value will then be used to do 
> a "contains" search against the "tags" field.
> 
> 
> 
> The system then presents the user with a selectable combo box with all 
> the records that matches/contains the value searched for.  The user 
> selects one and presses enter and the GL # will be inserted within the AP.
> 
> 
> 
> Any ideas on how to pull this off?  The forms are full with no scrolling fields.
> Upgrading is probably not an option, however if there enough 
> compelling stuff, then they may be interested.
> 
> 
> 
> Thanks,
> 
> Stanley
> 
> -------------- next part -------------- An HTML attachment was 
> scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-
> list/attachments/20191018/b15723d8/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes 
> http://mailman.celestial.com/mailman/listinfo/filepro-list