I am trying to create a view which will be exposed as a service via Services Views module. I have only defined Default display for this view and added the following field to the list of Fields -
- Node: Nid Nid
- Node: Type Type
- Node: Title Title
- Profile: Author Info: Full Name Author Name
- Node: Post date Post date
- Node: Teaser Teaser
- Node: Promoted to front page Promoted to front page
- Node: Last edited by Last edited by
- Node: Updated date Updated date
- Content: Thumbnail URL to file
All the fields are appearing nicely when I request it (using this url: http://localhost/app/rest/views/articlelist?args[0]=1), but the last field, which is the url to thumbnail file isn't appearing there.
A sample response from the above url is as follows -
<item>
<nid>22</nid>
<type>Article</type>
<title>UK soldier killed in Afghanistan</title>
<author_name>Demo Journalist</author_name>
<post_date>Jul 1 2012 - 4:08pm</post_date>
<teaser>
<p> ret rre tre tretre trtretre tre t re t ret rre tre tretre trtretre tre t re t ret rre tre tretre trtretre tre t re t ret rre tre tretre trtretre tre t re t ret rre tre tretre trtretre tre t re t ret rre tre tretre trtretre tre t re t</p>
</teaser>
<promoted_to_front_page>Yes</promoted_to_front_page>
<last_edited_by>admin</last_edited_by>
<updated_date>Jan 2 2013 - 3:56pm</updated_date>
</item>
What do I need to do to display the related thumbnail url?
Edit
Here is the query that is being executed (obtained from preview) -
SELECT node.nid AS nid, node.language AS node_language, node.type AS node_type,
node.title AS node_title,
profile_values_profile_full_name.value AS profile_values_profile_full_name_value,
profile_values_profile_full_name.uid AS profile_values_profile_full_name_uid,
node.created AS node_created, node.promote AS node_promote,
node.changed AS node_changed,
files_node_data_field_thumbnail_image_node_data_field_thumbnail_image.field_thumbnail_image_fid AS files_node_data_field_thumbnail_image_node_data_field_thumbnail_image_field_thumbnail_image_fid,
files_node_data_field_thumbnail_image_node_data_field_thumbnail_image.field_thumbnail_image_list AS files_node_data_field_thumbnail_image_node_data_field_thumbnail_image_field_thumbnail_image_list,
files_node_data_field_thumbnail_image_node_data_field_thumbnail_image.field_thumbnail_image_data AS files_node_data_field_thumbnail_image_node_data_field_thumbnail_image_field_thumbnail_image_data,
node_data_field_analysis_box.field_analysis_box_value AS node_data_field_analysis_box_field_analysis_box_value,
node.vid AS node_vid
FROM node node LEFT JOIN content_type_article node_data_field_thumbnail_image
ON node.vid = node_data_field_thumbnail_image.vid
LEFT JOIN files files_node_data_field_thumbnail_image
ON node_data_field_thumbnail_image.field_thumbnail_image_fid = files_node_data_field_thumbnail_image.fid
INNER JOIN term_node term_node
ON node.vid = term_node.vid
INNER JOIN users users
ON node.uid = users.uid
LEFT JOIN profile_values profile_values_profile_full_name
ON users.uid = profile_values_profile_full_name.uid AND
profile_values_profile_full_name.fid = '1'
LEFT JOIN content_type_article files_node_data_field_thumbnail_image_node_data_field_thumbnail_image
ON files_node_data_field_thumbnail_image.fid = files_node_data_field_thumbnail_image_node_data_field_thumbnail_image.field_thumbnail_image_fid
LEFT JOIN content_type_article node_data_field_analysis_box
ON node.vid = node_data_field_analysis_box.vid
WHERE (node.status <> 0) AND (term_node.tid IN (1, 2))
ORDER BY node_changed DESC, node_created DESC