Is it possible to export rows from VIEW table?

  • Resolved Alvaro Gois dos Santos

    (@alvarogois)


    3 years, 8 months ago

    Hi,

    I was wondering if I can select and export rows in a VIEW table I created in my database. I tried to build the Data Project but it only works in view mode, therefore I don’t see the select for each row or the export options.

    Is it even possible or I can only do it with regular tables?

    Thanks.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    3 years, 8 months ago

    Hi Alvaro,

    This is possible, but with limitations.

    On the back-end, the plugin needs a primary or unique key to uniquely identify rows in a table and support row based actions. Views do not have such a key. For that reason row based actions on views are not supported on the back-end.

    The Data Publisher is based on another technology which allows row based actions on views. So you can use a view to create a publication table and export from their.

    If you use dashboards, you can also use your publication table on the back-end. 😉

    Does this help?

    Thanks,
    Peter

    Thread Starter Alvaro Gois dos Santos

    (@alvarogois)

    3 years, 8 months ago

    Hi Peter,

    I did manage to create a publication table from my View but I don’t see any export actions. Just the search input.

    What am I missing?

    Thanks.

    Alvaro

    Thread Starter Alvaro Gois dos Santos

    (@alvarogois)

    3 years, 8 months ago

    Oh, I see it, it’s a Premium feature.

    I’m missing a search option in WPDA docs.

    Thanks.

    Alvaro

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    3 years, 8 months ago

    Hi Alvaro,

    >>> I’m missing a search option in WPDA docs.

    I know! A new design including documentation search is coming soon…

    Have you noticed the performance boost on the website? 😉

    Best regards,
    Peter

    Thread Starter Alvaro Gois dos Santos

    (@alvarogois)

    3 years, 8 months ago

    Hi Peter,

    Great!

    As to the performance, I’m sort of a slow reader, I’m afraid I would easily miss that boost. But it does load really fast. Congrats!

    Best,
    Álvaro

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Is it possible to export rows from VIEW table?’ is closed to new replies.