Radicore Forum: How To » Search for field in related table

Home » RADICORE » How To » Search for field in related table

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

Re: Search for field in related table [message #1788 is a reply to message #676]

Wed, 05 November 2008 03:23

rhogan
Messages: 4
Registered: November 2008
Location: Wolfeboro, NH

Junior Member

AJM wrote on Tue, 13 March 2007 13:20

The contents of $where ($sql_where) is filtered to remove any columns which do not exist in the current table. If you are joining to other tables then search criteria for these other tables can be placed inside $this->sql_search using code inside the _cm_pre_getData() method. The contents of $this->sql_search has a different filter mechanism.

Could you provide a specific example of this? What code goes in which file?

For instance, I've got 2 tables with a one-to-many relationship, one person to many phone numbers.

I'd like to add phone number to the search screen for person in a drop down. So the user who has a phone number can find out what person it belongs to. In other words, I want to do a search on the senior table, based on a value in the junior table, and I need to have that field appear for input on the senior table search screen.

This seems like it should be simple, but I've been working through the tutorial for at least a week and I just can't find the solution. I can't have a user pick the person before getting to phone, because, that's what they would be searching for.

Thanks,
Boz

[Updated on: Wed, 05 November 2008 03:27]

Report message to a moderator

[Message index]

		Search for field in related table By: janalwin on Tue, 13 March 2007 12:19
		Re: Search for field in related table By: AJM on Tue, 13 March 2007 13:20
		Re: Search for field in related table By: bmoore on Wed, 22 October 2008 16:54
		Re: Search for field in related table By: AJM on Wed, 22 October 2008 17:07
		Re: Search for field in related table By: rhogan on Wed, 05 November 2008 03:23
		Re: Search for field in related table By: AJM on Wed, 05 November 2008 04:52
		Re: Search for field in related table By: rhogan on Tue, 02 December 2008 11:40
		Re: Search for field in related table By: AJM on Tue, 02 December 2008 12:37
		Re: Search for field in related table By: rhogan on Tue, 02 December 2008 12:45
		Re: Search for field in related table By: AJM on Tue, 02 December 2008 13:47
		Re: Search for field in related table By: rhogan on Tue, 02 December 2008 13:49
		Re: Search for field in related table By: janalwin on Tue, 13 March 2007 16:26

Previous Topic:	Use a popup from a navigation button
Next Topic:	Dynamic Report Column Headings

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Jul 11 05:46:08 EDT 2025

Total time taken to generate the page: 0.19058 seconds