DBIx::SearchBuilder How to make left join with epression?

RT Users
#1

How do I do a left join and join on an arbitrary expression?
That catch is that I need to refer to the TABLE2 alias in
the expression?

Also, how can I just give DBIx::SB the proper SQL to run
in situations where I can’t get it to generate the proper
SQL?

Thanks.

-Todd

#2

How do I do a left join and join on an arbitrary expression?
That catch is that I need to refer to the TABLE2 alias in
the expression?

Shouldn’t it be enough to use ->NewAlias to create a new alias, pass
it in as ALIAS2, and go from there?

What are you actually trying to do?

Best,
Jesse

Also, how can I just give DBIx::SB the proper SQL to run
in situations where I can’t get it to generate the proper
SQL?

Inside of join conditions, not easily.

Jesse

PGP.sig (186 Bytes)

#3

How do I do a left join and join on an
arbitrary expression?
That catch is that I need to refer to the
TABLE2 alias in
the expression?

Shouldn’t it be enough to use ->NewAlias to
create a new alias, pass it in as ALIAS2, and
go from there?

What are you actually trying to do?

I am doing a LEFT join and my additional criteria
needs to be in the ON clause. And my criteria
needs to refer to the ‘right’ table?

With a left join SB requires TABLE2 instead
of ALIAS2.

Does this make sense?

#4

How do I do a left join and join on an
arbitrary expression?
That catch is that I need to refer to the
TABLE2 alias in
the expression?

Shouldn’t it be enough to use ->NewAlias to
create a new alias, pass it in as ALIAS2, and
go from there?

What are you actually trying to do?

I am doing a LEFT join and my additional criteria
needs to be in the ON clause. And my criteria
needs to refer to the ‘right’ table?

With a left join SB requires TABLE2 instead
of ALIAS2.

Does this make sense?

Best,
Jesse

Also, how can I just give DBIx::SB the proper
SQL to run
in situations where I can’t get it to generate
the proper
SQL?

Inside of join conditions, not easily.

Jesse

Do you have any suggestions when doing a left join or
does SB need some extra magic?

-Todd