Radicore Forum: How To » RIGHT JOIN in LINK

Home » RADICORE » How To » RIGHT JOIN in LINK

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RIGHT JOIN in LINK [message #2647]

Sun, 02 January 2011 16:25

gpatti
Messages: 283
Registered: August 2008

Senior Member

Is it possible to create a LINK entity that restricts the number of possible combinations by using a RIGHT JOIN rather than a CROSS JOIN?

I can write the SQL to obtain the results I want but can only get the framework to generate a CROSS JOIN in a LINK transaction?

If not can I hardcode my statement to be used by a LINK transaction? I have tried setting $this->sql_select, $this->sql_from and $this->sql_where in _cm_pre_getData() but this generates a statement with both a CROSS JOIN and a RIGHT JOIN. I can't seem to avoid the CROSS JOIN!

Report message to a moderator

Re: RIGHT JOIN in LINK [message #2648 is a reply to message #2647]

Mon, 03 January 2011 06:23

AJM
Messages: 2367
Registered: April 2006
Location: Surrey, UK

Senior Member

If you want to restrict the number of records which are returned then what is wrong with using search criteria? Surely that is much easier than changing the JOIN clause?

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: RIGHT JOIN in LINK [message #2649 is a reply to message #2648]

Mon, 03 January 2011 08:05

gpatti
Messages: 283
Registered: August 2008

Senior Member

OK I've added a search navigation button to the link screen and of course it works.

However, this is a logical implementation on top of the physical one and I don't want the user to have to manually search, as the other link entities are logically invalid.

Is there a way to implement a filter automatically?

Report message to a moderator

Re: RIGHT JOIN in LINK [message #2650 is a reply to message #2649]

Mon, 03 January 2011 09:55

AJM
Messages: 2367
Registered: April 2006
Location: Surrey, UK

Senior Member

You can hard-code the search criteria into the task either by putting code into the relevant table class, or by putting it into the 'Selection (fixed)' area of the task's details as described in http://www.tonymarston.net/php-mysql/menuguide/appendixd.htm l#selection-fixed

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Previous Topic:	grandparent - parent - child link entity
Next Topic:	Display combined fields on Output3 report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Nov 22 23:40:43 EST 2024

Total time taken to generate the page: 0.03747 seconds