[ASK] Extending WordPress database

  • Resolved Sas Dino

    (@sasdino)


    6 years, 2 months ago

    Hello everyone!
    Hi Peter!

    It is possible to extend wordpress table with a relationships via data designer or data projects?
    For example I create employee table and I want an employee can be assigned as wordpress backend user wp_users.

    Is there any options in data designer or data projects to make it possible updating related table before or after saving particular table?
    For example:
    I have products table that include materials and finished products. In another table I create a bill_of_material table for finished products via a relationships to products table. Can I create a workflow to automatic updating materials stock value in products table after marked a manufacturing process as done?

    • This topic was modified 6 years, 2 months ago by Sas Dino.
    • This topic was modified 6 years, 2 months ago by Sas Dino.
    • This topic was modified 6 years, 2 months ago by Sas Dino.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    6 years, 2 months ago

    Hi Dino (I guess?),

    Interesting stuff! 🙂 Unfortunately the plugin does not support this kind of complex stuff YET…

    I am working on a PRO extension which allows you to add your own PHP code to a project. With the PRO extension you will be able to create a workflow. Should I send you a message when it is available?

    Can you use database triggers? They can be very powerful!

    Best regards,
    Peter

    Thread Starter Sas Dino

    (@sasdino)

    6 years, 2 months ago

    Thank you for fast reply.

    I am working on a PRO extension…

    Pro version of this plugin? I would love to receive information about it.
    Can you give a list of features on Pro version? Any chance Pro version will have report builder module? so plugin user can visually design their report for public information and for printing.

    Can you use database triggers? They can be very powerful!

    Yes, thank for your suggestion.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    6 years, 2 months ago

    Hi Dino,

    These are my plans for the PRO extension (might change…):
    + Style Manager
    Contains about 20 default plugin and dashboard styles. Can be used outside the plugin as well.
    + Inline editing
    Make specific columns in the WP List Table as editable. Configurable in Table Settings.
    + Full text search
    – For InnoDB en MyISAM tables.
    + Individual column search
    – Support publications as well.
    – Code Manager
    Allows to add PHP, JS and HTML code to plugin pages. Will probably support non plugin pages as well.
    – Report Builder
    – Built reports based in database tables.
    – Restful API
    – JSON, maybe more…
    – Grid editor
    – Excel like table editing.

    The feature marked as + are done. I hope to finish the rest before the summer…

    Best regards,
    Peter

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

The topic ‘[ASK] Extending WordPress database’ is closed to new replies.