Author Topic: Views 4.1 , need to merge tables together with a logical selection. (Read 852 times)

Albana_12 · May 18, 2012, 01:33:16 am

Hi everyone,

we have created a website with civicrm and we are encountering some problems. we've seen that this module is well integrated in views but the problem is that i have created some Events where each event has an agency and each agency has a hostess.

I can query information for all this three but separately, how can i connect the contact id of the hostess with the one of the events? I mean beside the information for the events i need to put even all the information of the hostess that belongs to that event, merging this two tables.

I would really appreciate your help!

petednz · May 18, 2012, 12:20:16 pm

how have you set up the agency/hostess - are these Event-based Custom Fields?

If so are you saying these are not accessible in a CiviCRM Event based View?

Hershel · May 19, 2012, 01:19:09 pm

Using Views, if the View is of CiviEvents, you can get the Agency ID. Then you would have to customize a template (or use a View field that allows PHP) and use the CiviCRM API to fetch the data for the Hostess of that Agency.

CiviCRM Community Forums (archive)

News:

Author Topic: Views 4.1 , need to merge tables together with a logical selection. (Read 852 times)

Albana_12

Views 4.1 , need to merge tables together with a logical selection.

petednz

Re: Views 4.1 , need to merge tables together with a logical selection.

Hershel

Re: Views 4.1 , need to merge tables together with a logical selection.