ARS 5.1.2 SQL 2K
I have a question about a table property qualification that doesn't appear to be working correctly. Our users can submit solution sets for common trouble calls and then use them to autofill tickets to save time. They do this by typing a keyword into a character field and then clicking a search button. The button opens a form with a table field on it that has the following qualification: ( 'Solution_Status' = "Approved" ) AND ( $System_Acronym$ = 'System_Acronym') AND ( 'Solution_Type' = "Solution") AND ( 'Title' LIKE (( "%" + $Solution_Keyword$) + "%" )) On my solution set form, there are 10 solution sets with a system acronym of 'AR System' and solution type = "Solution" yet when I leave the keyword field blank, the table only returns 8 of the solutions. I've isolated the two solution sets that aren't returned in the above case and can't find anything unique that would prevent them from being displayed in that table. This happens on numerous other occasions and I can't figure it out. Any ideas? Thanks, Michael A. McManus, SrA, USAF Remedy Developer HQ 754 ELSG/DOOH DSN: 596-6478/Comm: 334-416-6478 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
