Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- vector = SearchVector('name') + SearchVector('last_name')
- q = self.strip_punctuation(query_str)
- str_vector = q.split(' ')
- if len(str_vector) > 1:
- query = SearchQuery(str_vector[0])
- for string in str_vector[1:]:
- query |= SearchQuery(string)
- QQ = queryset.annotate(search=vector).filter(search=query)
- else:
- QQ = queryset.filter(Q(last_name__istartswith=q) |
- Q(name__istartswith=q)
- )
- SELECT "id", "polymorphic_ctype_id", "level", "company_id", "profile_id",
- "email", "state", "category_id", "is_aml_cft_responsable", "name",
- "middle_names", "last_name", "preferred_name", "occupation", "role",
- "role_in_relation", "percentage_of_ownership", "pep", "date_created",
- "last_update", "parent_client_id", "shares_held", "must_be_verified",
- "ctype_sort_order", "reason_for_using_amlnz", "other_reason_for_using_amlnz",
- "nature_of_the_business", "nature_of_the_transaction", "value_start",
- "value_end", "value_per", "value_comment", "volume_start", "volume_end",
- "volume_per", "volume_comment", "review_date", "client_number",
- "registration_number", "nzbn", "risk_rating", "has_more_than_25_percent",
- "has_effective_control_relationship", "is_person_for_transactions",
- "is_person_acting_on_behalf", "has_call_nzbn_api", "is_archived",
- "nzbn_api_response", "search_api_response", "date_of_birth", "is_the_same",
- "address", "suburb", "city", "country", "post_code", "authorization_letter",
- "ird_number", "country_of_establishment", "gender", "contact_person_name",
- "contact_person_last_name",
- (to_tsvector(COALESCE("name", )) || to_tsvector(COALESCE("last_name", )))
- AS "search"
- FROM "aml_validations_baseclient"
- WHERE
- ("company_id" = 1
- AND
- (
- to_tsvector(COALESCE("name", )) ||
- to_tsvector(COALESCE("last_name", ))
- )
- @@
- ((plainto_tsquery(William) || plainto_tsquery(Buick))) = true
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement