rtucci_1 Posted April 2, 2013 Share Posted April 2, 2013 I have a history report for incidents, the history table contains the lifecycle of the incident cases (who it was assigned to and when etc.)The report needs to show all cases where a specific support group (value) exists. So if the field contains (X value) I need to see it.I have tried Is Like or like, but it does not work, is there a "contains" SQL expression I can use? Link to comment Share on other sites More sharing options...
lisacbeaton Posted April 2, 2013 Share Posted April 2, 2013 You could try a regular expression (formatted for Oracle here -- the 'i' makes it case insensitive -- format to suit your own database):REGEXP_LIKE(COLUMN_NAME, 'seach term', 'i') Link to comment Share on other sites More sharing options...
rtucci_1 Posted April 3, 2013 Author Share Posted April 3, 2013 Unfortunately I am using a Sequel database, is there a similar function is SQL? Link to comment Share on other sites More sharing options...
rtucci_1 Posted April 3, 2013 Author Share Posted April 3, 2013 Unfortunately I am using a Sequel database, is there a similar function is SQL? Link to comment Share on other sites More sharing options...
rtucci_1 Posted April 3, 2013 Author Share Posted April 3, 2013 Unfortunately I am using a Sequel database, is there a similar function is SQL? Link to comment Share on other sites More sharing options...
rtucci Posted April 10, 2013 Share Posted April 10, 2013 This is how i resolved my issue by using a nested queryHPD_AssignmentTracking."Case_ID" IN ( SELECT DISTINCT HPD_AssignmentTracking."Case_ID" FROM "dbo"."HPD_AssignmentTracking" HPD_AssignmentTracking WHERE HPD_AssignmentTracking."Case_Assigned_To_Group" = 'DOITT:Service Desk' )This shows me all cases where a specific support group has been assigned. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now