Hi Michael,
Mostly in the qualification the Current form fields appear after the
qualifier symbol thus your qualification will be
( 'Solution_Status' = "Approved" ) AND
('System_Acronym'=$System_Acronym$ ) AND ( 'Solution_Type' = "Solution")
AND ( 'Title' LIKE (( "%" + $Solution_Keyword$) + "%" ))
As I have gone through the same scenario some days prior which worked
successfully.
Regards,
Neha P.
--
www.vyomlabs.com
Consulting | Oursourcing | Training || ITIL | IT Governance |BMC Remedy
McManus Michael A SrA HQ 754 ELSG/DOO wrote:
**
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
__20060125_______________________This posting was submitted with HTML
in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
