[Dbix-class] Query is NOT created successfully.

[Peter Rabbitson]

On Mon, Dec 17, 2012 at 01:50:06PM -0800, dkim wrote:
> Hello,
> 
> When I use DBIx::Class::ResultSet::search() method with a complex query with
> multiple joins,  the query produced from DBIx::Class is not complete. Some
> conditions are missing in the SQL query when I check the SQL. If I test it
> with each condition separately, then SQL is OK with that condition. 
>  
> I am wondering if anybody has the same issue before and/or how to resolve
> this kind of issue.
> 
> I will appreciate it if somebody can help me.
> 

It is unlikely you will receive any help - your question is too vague. 
Please provide your search() arguments and the resulting DBIC_TRACE and 
explain which parts you think are incorrect. *Then* someone would be 
able to identify the problem.

Cheers