RE: [development-axapta] Filtering on a memo field

[Malcolm Burtt]

Hi   I built a simple search engine in Axapta 2.5 to overcome this. I have a background job that periodically reads through new and modified records in a set of user defined memo fields. For each field it splits the memo field into individual words, discards anything of less than 4 letters (for efficiency) and then stores an index record pointing back to the table and record Id where that word can be found. I have a search wizard form that allows the user to enter words they want to look for and it returns a list of records showing the whole of the original text where a match was found. The form is sorted so that the records with the most words that match the search criteria are shown first.   In version 3 there's a data crawler that might do something similar. I've not had a chance to look into using that yet.   Regards   Malcolm Burtt Project Leader Global IT Group -----Original Message----- From: Don Price [mailto:[EMAIL PROTECTED] Sent: 22 January 2004 15:07 To: [EMAIL PROTECTED] Subject: [development-axapta] Filtering on a memo field Hi All,     Has anybody ever been able to come up with a solution to filter on a memo field?  Currently if you try to set a range on this type of field it will throw an exception. The only possible solution I’ve thought of is searching the table myself in a loop and building a range of recids to pass on to the query.  So that’s probably not good for performance. I would appreciate any hint or solution.   Thanks Don Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/   To unsubscribe from this group, send an email to: [EMAIL PROTECTED]   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/   To unsubscribe from this group, send an email to: [EMAIL PROTECTED]   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.