Index: grails-app/services/com/lemans/distribution/document/DistributionDocumentService.groovy =================================================================== diff -u -r542edf636049ec59e95ddb8edb6c6b98afc428dd -r474373cde048f7512eb932637794a79c5a066c45 --- grails-app/services/com/lemans/distribution/document/DistributionDocumentService.groovy (.../DistributionDocumentService.groovy) (revision 542edf636049ec59e95ddb8edb6c6b98afc428dd) +++ grails-app/services/com/lemans/distribution/document/DistributionDocumentService.groovy (.../DistributionDocumentService.groovy) (revision 474373cde048f7512eb932637794a79c5a066c45) @@ -36,7 +36,7 @@ private List clauses(Map criteria) { List clauses = [] - convertToLikeSearch(criteria, ['documentName', 'documentDescription', 'originalFileName', 'fileName']) + convertToLikeSearch(criteria, ['documentName', 'documentDescription', 'originalFileName', 'fileName', 'documentSearch']) if (criteria.mediaTypeId) { clauses << 'mediaTypeId = :mediaTypeId' } if (criteria.mimeTypeId) { clauses << 'mimeTypeId = :mimeTypeId' } if (criteria.documentTypeId) { clauses << 'documentTypeId = :documentTypeId' } @@ -68,9 +68,9 @@ clauses << 'endDate < :endDateRangeEnd' } if (criteria.documentSearch) { - clauses << """documentDescription LIKE '%$criteria.documentSearch%' - OR documentName LIKE '%$criteria.documentSearch%' - OR fileName LIKE '%$criteria.documentSearch%' """ + clauses << """documentDescription LIKE :documentSearch + OR documentName LIKE :documentSearch + OR fileName LIKE :documentSearch """ } clauses }