Query and View

  • Resolved Alph

    (@alpph)


    3 years ago

    Hi,

    Newbie is this Plugin, I have a basic question.

    I created a query and save it with a specific name.

    I want to use it in the Data Publisher.

    On the Create publication of the Data Publisher, on the fourth line with the * Table/View Name, I can not find the query I created.
    Is the query just stored in a plugin table and there is no view creation ?
    How to create a view? In the same way as Table design and Table creation.

    I know how to create a view with phpMyAdmin or MyWebSQL. Do I have to use this method to creat my views ?

    Salutations

    A. Philippe

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

    (@peterschulznl)

    Hi,

    The Data Publisher does not yet support SQL queries. Only tables and views. Query support is planned but not yet available.

    You can use the Query Builder to save your query as a view. In the Query Builder, just enter “create or replace view view_name as” in front of your query.

    Does this help?
    Peter

    Thread Starter Alph

    (@alpph)

    Hi,

    A way to create manually, without GUI, a view !!

    Thanks

    AP

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Your welcome! ??

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Query and View’ is closed to new replies.