Drupal 7 add another “filed_data” table value with “views_get_view()” function

by Arun   Last Updated January 12, 2018 10:07 AM

In my project, I am using views_get_view() function to get some values. It doesn't include the data of one field_data table which I required. I need to filter the details of that table too

Is there any way to append the field_data table and apply filter on it?

My current code is

$myview = views_get_view('purchase_tracking');
$myview->set_display('block');
$myview->set_current_page($page);
$myview->set_items_per_page($limit);
$myview->set_arguments(array($person_id));
$myview->execute();
$table_data = $myview->result;
echo '<pre>';
print_r($table_data);
die;

I need to add the data from table field_data_field_void_delete and apply the filter

field_void_delete_value = 0

I also need a filtering with status column in the node table. Where the status should be 1

I added a pagination to the code. So adding the filtering in views function will get the correct output than I do it later after the view function.

Thanks for the help in advance.



Related Questions


Exposed filters go to request arguments

Updated June 04, 2015 02:03 AM

How to alter combined filter value programatically?

Updated March 27, 2015 14:18 PM



How to set up this view of commerce orders...?

Updated January 11, 2017 10:03 AM