Score:0

Drupal7 Views relationship multi value custom column

bo flag

Im using Drupal7 and views, views relationship

Im displaying the results in table format with the help of view along with other custom tables as well as by using views relationship.

I need a help in below issue:

I have a custom table: employee

Columns: nid, uid, role

nid uid role
100 4 manager
100 5 dept-manager
100 6 assistant
100 7 manager2

In the table format of the view, I need to display each user's mail-id for each node.

Example:

nid title manager assistant manager2
100 Helloworld [email protected] [email protected] [email protected]
101 Newtodrupal [email protected] [email protected] [email protected]

Can you assist me to display my results like the above one?

I dont know how to create relationship based on multi-values in one column role in custom table.

Thanks in advance.

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.