How to obtain raw field value from db table in a view? In Views 2 I am rewriting a field to generate a link that has arguments appended.

One of those fields is referenced as [field_name_value] but outputs 'public' (and translated) value of the field.  In the database the value is stored as 0 or 1 but it outputs No or Yes respectively.  The No/Yes must be coming from the content type template which provides a pair of radio buttons, where 'No' is 0 and 'Yes' is 1.

Is there any way to obtain the raw database (0 or 1) value? Thanks.
One of the last things Views does when it renders a view is to process all the fields raw data and format them according to settings, then theme according to the default or your own custom views templates.

So, if the 'Output format' options in field's settings on the view don't provide what you need, you can get the raw values - before formatting &amp; theming - like so:


Install Views PHP so you can run code from within views fields, arguments etc.
Check the "Exclude from display" option on the fields you want 'raw' to stop them appearing in the output, but still ensure they're in the view data.
Add one "Global: PHP" field for each field for each hidden field.
In the "Output code" at the bottom of the field settings on the new Views PHP field, add something along the lines of print $row-&gt;field_you_want_raw.


Since you've got full PHP in these new fields you can format, tweak and merge any raw field data you need.