Hello,
I have made a construction with EOQualifier here is my QualifierString:
(languagesavedtemplate.language=%@) and ((name caseInsensitiveLike %@) OR (languagesavedtemplate.savedtemplatedescription caseInsensitiveLike %@)) AND (usersavedtemplate.user=%@) AND (usersavedtemplate.user.usernode.node=savedtemplatenode.node) <-------------
and this is the SQL-statment that is generated:
"SELECT t0."approvaluser_id", t0."ctime", t0."mtime", t0."name", t0."ordercomment", t0."orderref", t0."previewfile", t0."savedtemplate_id", t0."status", t0."template_id", t0."thumb", t0."user_id" FROM "savedtemplate" t0, "language_savedtemplate" T2, "user_savedtemplate" T1 WHERE ((1=1) <----------------- AND T1."user_id" = 1000000 AND (t0."name" LIKE '%test%' COLLATE INFORMATION_SCHEMA.CASE_INSENSITIVE OR T2."savedtemplatedescription" LIKE '%test%' COLLATE INFORMATION_SCHEMA.CASE_INSENSITIVE) AND T2."language_id" = 1000000) AND t0."savedtemplate_id" = T2."savetemplate_id" AND t0."savedtemplate_id" = T1."savedtemplate_id" ORDER BY t0."name" COLLATE INFORMATION_SCHEMA.CASE_INSENSITIVE ASC"
Why is this not working and is: (usersavedtemplate.user.usernode.node=savedtemplatenode.node) generating: (1=1) Is it possible to work with relations that way? Thanks,
Met vriendelijke groeten - Kind Regards Frank Stock Net & Storage Solutions nv Tieltstraat 167 8740 Pittem Belgium T ++32 51 424 010 F ++32 51 402 922
|