Your Version : 7.9.0 Build Number 7916
Latest Version : 7.9.0 Build Number 7925
Running this query in SQL Server
SELECT [WORKORDERID]
,[FULLDESCRIPTION]
FROM [supportcenter].[dbo].[WorkOrderToDescription]
WHERE FULLDESCRIPTION LIKE '%Generating a PDF That Will be Accepted by the Court%';
gives me > 600 matching records.
How can I create this in a report for a user? The Advanced Filtering box is not working as described.
I tried this:
Reports > Reports by all Requests > Request by Created Date
Run Report, then Edit Report
Under Step 2, no date filter (show me all the matching records)
Run Report > Result 18374 matches
Now, Edit Report again and add
Advanced Filtering: Description, contains, Generating a PDF That Will be Accepted by the Court
Run Report > Result: 0 records
Now, Edit Report again and change filtering to include double-quotes around search string
Advanced Filtering: Description, contains, "Generating a PDF That Will be Accepted by the Court"
Run Report > Result: 0 records (no data available to generate the report ...)
Now, Edit Report again and change filtering to include single quotes around search string
Advanced Filtering: Description, contains, 'Generating a PDF That Will be Accepted by the Court'
Run Report > Result: 0 records (no data available to generate the report ...)
Single word filtering (so just one of the words in my string) gets me some results, but not anything close to the number I get with direct SQL queries.