Buenas taardes lista , en esta consulta, implemento un vector en un OR
.pero al ejecutarla.. cuando busca por SSN osea un numero.. y es laprimera
parte del or. funciona bien .. pero cuando implemento la busqueda por
nombre que es la segunda parte del OR , obtengo resultado vacio. la consulta
no me devuelve nada..
Les consulto por si pueden mirarla. y decirme porque el vector no em esta
devolviendo valores.
GRacias.
SELECT "advisors"."id" AS t0_r0, "advisors"."organization_id" AS t0_r1,
"advisors"."code_name" AS t0_r2, "advisors"."spouse_name" AS t0_r3,
"advisors"."spouse_dob" AS t0_r4, "advisors"."anniversary" AS t0_r5,
"advisors"."comment" AS t0_r6, "advisors"."created_at" AS t0_r7,
"advisors"."updated_at" AS t0_r8, "people"."id" AS t1_r0,
"people"."organization_id" AS t1_r1, "people"."advisor_id" AS t1_r2,
"people"."personable_id" AS t1_r3, "people"."personable_type" AS t1_r4,
"people"."first_name" AS t1_r5, "people"."middle_initial" AS t1_r6,
"people"."last_name" AS t1_r7, "people"."suffix" AS t1_r8,
"people"."nickname" AS t1_r9, "people"."ssn" AS t1_r10, "people"."dob" AS
t1_r11, "people"."created_at" AS t1_r12, "people"."updated_at" AS t1_r13
FROM "advisors" LEFT OUTER JOIN "people" ON "people".personable_id =
"advisors".id AND "people".personable_type = E'Advisor'WHERE
("advisors".organization_id = 1) AND ((people.ssn LIKE E'%Annuity%' or
to_tsvector(people.first_name || '' || people.last_name) @@ E'Annuity%') AND
("advisors".organization_id = 1)) ORDER BY people.first_name ASC,
people.last_name ASC, advisors.updated_at DESC LIMIT 15 OFFSET 0
