[development] views: custom conditions using fields from multiple tables

[Ken Rickard]

Not *custom field handlers*, custom *filter* handlers.

On Fri, Jul 8, 2011 at 1:24 PM, Ken Rickard <agentrickard at gmail.com> wrote:
> I think this is a fair development question, since the answer is "you
> have to write code to do this".
>
> You can do variable query handlers in custom field handlers -- that's
> what I usually do -- but it does require writing code.
>
> Essentially, your query() method can be responsive to input or
> conditions in the rest of the View (including arguments.)
>
> Here's a snippet that (while out of context) will show you the basic approach.
>
> http://drupalbin.com/19138
>
> If you think your logic can be abstracted and used in multiple places,
> a Views filter is a great option. If not, just a custom query is fine.
>
> On Thu, Jul 7, 2011 at 4:30 PM, Ms. Nancy Wichmann
> <nan_wich at bellsouth.net> wrote:
>> This should be in the Support list.
>>
>> I believe using the "Relationship" stuff would allow this, but you may have
>> to build a module to provide that information. In which case, doing your own
>> query is probably faster.
>>
>> Nancy
>>
>> Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King,
>> Jr.
>>
>> From: Roman Zimmermann
>> for a site specific view I'd need to implement a view which's query
>> has a condition that spans multiple tables. It'll look something like:
>> table1.field = 'value' OR table2.field = 'other value'
>>
>> Is this possible using D6/views2 ?
>> Am I better off just using a custom query?
>
>
>
> --
> Ken Rickard
> agentrickard at gmail.com
> http://ken.therickards.com
>



-- 
Ken Rickard
agentrickard at gmail.com
http://ken.therickards.com