I'm fairly new to generating my own reports (and to SQL in general), so
I may be missing something obvious, but is the LIKE syntax supported
for reports? I can't seem to get it to work. We are using postgres as
the Track DB.
The following query works:
SELECT id AS ticket, summary, component
FROM ticket t
WHERE component IN ('cuemkvid')
But this one with a LIKE does not:
SELECT id AS ticket, summary, component
FROM ticket t
WHERE component LIKE '%'
Any help would be greatly appreciated. Thanks!
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/trac-users
-~----------~----~----~----~------~----~------~--~---