AnsweredAssumed Answered

Additional Search Arguments properly formatted query

Question asked by MannyR1 on May 15, 2014
Latest reply on Jan 18, 2016 by IvoLages

Hello All, I am new to the CA Service Desk environment and I was asked to figure out how to use the "Additional Search Arguments" to compose a query for finding out all incidents where a  specific use added one or more activities.  I am well versed in SQL Statements but I am not familiar how to construct them in the "Additional Search Arguments" field.  I have been reading the CA_SDM_Tech_Ref_ENU.PDF and it gives out the SQL Table references in the SQL Name to Table and Object but no matter how I write the query I keep getting parse errors.  The last thing I tried was:       act_log.analyst LIKE 'negron'   not sure if the clause WHERE is needed or not.  Any help will be greatly appreciated!  Thanks!