views_json raw output does not provide correct field values [#2384329]

Hi!

I tried to create a JSON view from nodes but result is filled with different field names and just node id as value for each field (except for title and nid).

This problem came up while using raw output which seems to be the key to this problem since changing back to normal output field names and values match again.
Maybe some array gets false indexes while generating raw output?

Also watchdog has some errors:
Couldn't find constant JSON_FORCE_OBJECT @ template_preprocess_views_views_json_style_simple() row 31

Comment	File	Size	Author
#10	views_datasource.fix_raw_json_values.2384329_10.patch	2.51 KB	jacob.embree
#3	views_datasource.fix_raw_json_values.2384319_03.patch	1.37 KB	rfay

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

reb00ter CreditAttribution: reb00ter commented 7 January 2015 at 02:19

trying to make custom template for views row, but for every field of node $field->raw gives me $fields['nid']->raw. $field->content outs correct value, but I need to get not formatted integer value without suffix and prefix
am I doing something wrong?

Comment #2

rfay

English

Palisade, CO, USA

CreditAttribution: rfay commented 27 May 2015 at 18:13

Priority:

Normal

» Major

This is a major problem, would love to hear if anybody has looked at it. Changing to major, as it makes all raw json with fields unusable.

Comment #3

rfay

English

Palisade, CO, USA

CreditAttribution: rfay commented 27 May 2015 at 22:07

Status:

Active

» Needs review

File	Size
views_datasource.fix_raw_json_values.2384319_03.patch	1.37 KB

I'm no views expert, but the code was not reaching into places that work for the raw values.

This patch makes it at least *find* the right values. Reviews and improvement appreciated.

Comment #4

rfay

English

Palisade, CO, USA

CreditAttribution: rfay commented 27 May 2015 at 22:08

Title:

Only node id and title available on raw output

» views_json raw output does not provide correct field values

Comment #5

killes@www.drop.org CreditAttribution: killes@www.drop.org commented 6 October 2015 at 22:25

Status:

Needs review

» Reviewed & tested by the community

Works great!

Comment #6

jacob.embree CreditAttribution: jacob.embree at St. Louis Integration commented 19 December 2016 at 15:16

#3 worked for me as well.

Comment #7

jacob.embree CreditAttribution: jacob.embree at St. Louis Integration commented 20 December 2016 at 20:05

Is there a good way to determine which column to return when there is no group_column, such as with image fields? The group_column is set in the field handler's option definition. It looks for a single column or a 'value' column. Fields such as image have more than one column and no 'value' column so the raw value will always be blank.

Comment #8

ZeiP CreditAttribution: ZeiP as a volunteer commented 13 February 2019 at 16:50

Status:

Reviewed & tested by the community

» Closed (duplicate)

Fixed in #1271506: use field_output: raw get wrong outputs. Thanks!

Comment #9

jacob.embree CreditAttribution: jacob.embree at St. Louis Integration commented 13 February 2019 at 17:20

Status:	Closed (duplicate)	» Needs work
Issue tags:	-raw, -nid, -fields	+Needs reroll

This patch solves a problem that is not solved by #1271506: use field_output: raw get wrong outputs. In that one the column used to determine the raw value is hard coded. In this one the column is based on the column selected in the view. For example, with this patch one is able to get the raw tid from a taxonomy_term_reference field. With #1271506: use field_output: raw get wrong outputs that is impossible because "name" is always selected.

When this patch is rerolled it would be good to include the changes from https://cgit.drupalcode.org/sandbox-jacob.embree-2838147/commit/?id=4e134d2 and https://cgit.drupalcode.org/sandbox-jacob.embree-2838147/commit/?id=6b1ec98 made in my fork.