0

I am stuck in a strange issue. I have two content types twilio and call recordings. Both content types have caller phone number in common

  1. Recording

    screenshot

  2. Twilio

    screenshot

Now I would like to generate a report using views which can select field between two content types based on phone number.

In non Drupal terms I want inner join based on two text fields.

How can I achieve this?

3
  • based on a quick look at the images you attached, you don't have common field in both content-type, make 1 field first, then add an existing field to the second content-type, so you can have common fields!
    – Sohail
    Nov 20, 2015 at 16:19
  • The fields are not common, but the purpose is common. I want to implement this without altering any structure
    – Shabir A.
    Nov 20, 2015 at 16:20
  • I can smell of a custom module for that, I don't see any way out.
    – Shabir A.
    Nov 20, 2015 at 20:22

1 Answer 1

1

Both content types have to share a field, in the same way a both the database tables used in a INNER JOIN have to share a common field for the join to work.

In Drupal, this is easy as you can reuse fields between your content types and in this wway joining the content types will be super simple with Views.

Current setup:

Recording: field_called_phone, field_caller_phone

Twilio: field_phone_number

Suggested setup:

Recording: field_called_phone, field_phone_number

Twilio: field_phone_number

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.