Hi, Roberto!
Search does not work for the field "comment"
Maybe it's because pgsql
Django sends the following query
'SELECT "documents_document"."id" FROM "documents_document" LEFT OUTER
JOIN "documents_documenttype" ON
("documents_document"."document_type_id" =
"documents_documenttype"."id") LEFT OUTER JOIN
"documents_documentversion" ON ("documents_document"."id" =
"documents_documentversion"."document_id") LEFT OUTER JOIN
"metadata_documentmetadata" ON ("documents_document"."id" =
"metadata_documentmetadata"."document_id") LEFT OUTER JOIN
"documents_documentpage" ON ("documents_documentversion"."id" =
"documents_documentpage"."document_version_id") LEFT OUTER JOIN
"taggit_taggeditem" ON ("documents_document"."id" =
"taggit_taggeditem"."object_id") LEFT OUTER JOIN "taggit_tag" ON
("taggit_taggeditem"."tag_id" = "taggit_tag"."id") LEFT OUTER JOIN
"django_comments" ON ("documents_document"."id" =
"django_comments"."object_pk") WHERE
(UPPER("documents_documenttype"."name"::text) LIKE UPPER(%s) OR
UPPER("documents_documentversion"."mimetype"::text) LIKE UPPER(%s) OR
UPPER("documents_documentversion"."filename"::text) LIKE UPPER(%s) OR
UPPER("metadata_documentmetadata"."value"::text) LIKE UPPER(%s) OR
UPPER("documents_documentpage"."content"::text) LIKE UPPER(%s) OR
UPPER("documents_document"."description"::text) LIKE UPPER(%s) OR
(UPPER("taggit_tag"."name"::text) LIKE UPPER(%s) AND
"taggit_taggeditem"."content_type_id" = %s ) OR
(UPPER("django_comments"."comment"::text) LIKE UPPER(%s) AND
"django_comments"."content_type_id" = %s )) ORDER BY
"documents_document"."date_added" DESC'
and scolds me for
ERROR: operator does not exist: integer = text
LEFT OUTER JOIN "django_comments" ON ("documents_document"."id" =
"django_comments"."object_pk")
No operator matches the given name and argument type(s). You might
need to add explicit type casts.
