Parent/child

  • Resolved davitabile

    (@davitabile)


    3 years, 10 months ago

    Hi Peter,
    thanks in advance for your support and congratulation for your plugin.
    I’m a biologist and I’m trying to setup a system to store meeting reports.
    I have a table topics. For each topich I have multiple issue and for each issue I have multiple decisions.
    Therefore, I put issues as child of Topics (one to many relationship) and I would put decisions as child of issues table (again one to many).
    When I insert a new topic and click on modify I can see the child table “issues” and so I can insert the firt issue.However, when I click on modify issue, I can’t see the child page “decisions”.
    to see the child table decision I need to access the table issue independently from Topics.
    Could you explain me why this happens? Is there any solution to create nested parent/child table?
    Thanks again in advance
    Daniele

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

    (@peterschulznl)

    Hi Daniele,

    Thank you for your complement! ??

    You requirement makes sense! For a user it feels natural to click through a hierarchy. Unformatunately the plugin does not support multiple hierarchies. When you run Data Projects in the dashboard or with shortcode wpdadiehard on a web page, a page request is send on every user action. That request needs to maintain the whole state to (re)build the hierarchy. Supporting multiple hierarchies would make the plugin awful complex. At least for me… ??

    Data Forms is a new (premium) feature which can overcome this issue. With Data Forms it will be possible to handle multiple hierarchies. Data Forms however is in its early stages. So please don’t expect it to be available very soon. There is still a lot to do.

    Does this answer your question?

    Thanks,
    Peter

    Thread Starter davitabile

    (@davitabile)

    Hi Peter thanks a lot for your kind reply

    The form solution looks very interesting as well as other functions such as the possibility to export or copy data from tables. I’m close to convince my boss to get the premium version!
    In the meanwhile I have found a solution that could work form me:
    I inserted the topic # in the issue table using a lookup. Decision Table is a child table of “issues” one to many
    To display data correctly I would need to create a View, however I really don’t understand why import function is not working to me
    I have created an Sql query that works for sure since I have tested it with another system.
    I have tryed also a very simple script with no success:

    CREATE VIEW ‘Vrb_argomenti’ AS
    SELECT
    Vrb_Id AS Arg#
    FROM
    Vrb_2;

    I always get the following

    ERROR: Import sqltest.sql failed [check import file]

    Could you help me to understand where am I wrong?

    Thanks a lot in advance

    Daniele

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Daniele,

    I think there are two minor issues with your create view script;
    – Please write the view name between backticks (not quotes)
    – If you want to use # in your alias, you need to write Arg# between backticks as well

    This should work:
    CREATE VIEW *Vrb_argomenti* AS SELECT *Vrb_Id* AS *Arg#* FROM *Vrb_2*;

    Sorry, the backticks are messing up the code! ?? Please replace the * with backticks.

    Let me know ??
    Peter

    Thread Starter davitabile

    (@davitabile)

    Hi Perter thanks a lot,
    problem solved but I needed to switch to a different web host.
    Thanks again
    Daniele

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Your welcome Daniele! ??

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Parent/child’ is closed to new replies.