Timeline for Getting the value of a user reference field and using it to display information about that user
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 27, 2011 at 5:24 | comment | added | ipwa | I explain how to make a relationship to the profile fields on my answer below. | |
| Jul 26, 2011 at 7:25 | comment | added | marcvangend | I don't know where the data in your profiles table comes from, but if it's regular Drupal content (eg. nodes), Views should be able to access it if you add the appropriate relationships to your view. If your profiles table is not native to Drupal, you could 1) write a custom module, exposing your data to Views, 2) migrate that data to Drupal fields attached to the user object, or 3) write a custom solution (which you were already looking for). | |
| Jul 26, 2011 at 0:28 | comment | added | Richard Luckhurst | As far as I can see I can not direct the output of the View, which is just the Id, to some code, which runs the SQL query, to get the other stuff I need from the profiles table. As far as I can see the Views module returns just a formatted list in the block. If there is some way of taking the returned list of Id's and then pushing that into some code to get the extra data I need from the profiles table and then formatting it into the block I would very much like to know about it. In short I do not want to see the list of Id's, I want to see a list of the data returned from profiles | |
| Jul 26, 2011 at 0:22 | comment | added | Richard Luckhurst | Thanks everyone for your answers suggesting using Views. As far as I have been able to tell Views will not give me the complete result I need. Using Views I have no trouble getting the Id for the key_contact and displaying the list of Id's in a list in a module. That is only half of the job though. What I need to do is take the Id returned from the View and to look inside another table, called profiles, and extract the Id's real name, phone number, email address and a URL that points to an image of them. | |
| Jul 25, 2011 at 13:00 | history | answered | marcvangend | CC BY-SA 3.0 |