[Resolved] Display Views Output In Dashboard Widget?

[Author]

Posts

[julieP]

I have a custom widget that contains a simple SQL query and displays the results in a widget in the wp-admin dashboard. I'd like it to give me more information so I'd like it to also show the value of a custom field with the results conditional on the value of a different custom field. This seems complicated to achieve via an SQL query so I'm wondering is it possible use Views to achieve this and how would I integrate the View into my widget please?

[Shane]

Hi Juilie,

Thank you for getting in touch.

You could add this function below to your custom widget
https://toolset.com/documentation/programmer-reference/views-api/#render_view

Please let me know if this helps.
Thanks,
Shane

[julieP]

Hi Shane

Thanks for a quick response.

That looks like it might be what I need. Will investigate further tomorrow.

Quick question: in the example given in the documentation you linked to, what might myattribute and myvalue be? The documentation states only name, title or ID can be passed so a little puzzled. Thanks

$args = array(
    'title' => 'My View name',
    'myattribute' => 'myvalue'
);
echo render_view( $args );

[Shane]

Hi Juilie,

This can be anything really.

Especially if you add a filter to your view and set the filter to get the value from a shortcode attribute.

So for example you have your normal view shortcode.
[wpv-view name='my-view' vehicle_id='12345']

Then the function equivalent would be.

$args = array(
    'title' => 'My View',
    'vehicle_id' => '12345'
);
echo render_view( $args );

Please let me know if this is clear.
Thanks,
Shane

[julieP]

OK that makes sense, thanks (have tested and it does what I was hoping for)