One-to-many relationship on "bay_mb_relationships" - Support Fourms

This topic has 5 replies, 4 voices, and was last updated 3 months, 1 week ago by Long Nguyen.

Creator

Topic
January 29, 2020 at 5:27 PM #18052

Resolved Berg Informatik
Participant

I try to realize a database structure like this.

https://i.stack.imgur.com/MeCoj.png

I have 3 post types:
* Workout
* Exercise
* Set

Thanks to the many-to-many plugin i can connect the Workout and Exercise with ease. But how can i connect the Set’s with one-to-many relation to the “bay_mb_relationships” junction table.
Creator

Topic

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

Author

Replies
January 31, 2020 at 11:33 AM #18072
Anh Tran
Keymaster
Hi,

If you want to force only one connection from one side of a relationship, please set 'max_clone' => 1 to the field on that side, like this:
```
add_action( 'mb_relationships_init', function () {
    MB_Relationships_API::register(
        array(
            'id'   => 'workout_to_workout_exercises',
            'from' => array(
                'object_type' => 'post',
                'post_type' => 'workout',
                'field' => array(
                    'max_clone' => 1, // Limit to 1 connection only.
                ),
            ),
            'to'   => array(
                'object_type' => 'post',
                'post_type' => 'workout_exercises',
            ),
        )
    );
} );
```
January 31, 2020 at 2:01 PM #18074

Berg Informatik
Participant

Thanks for the tip. I just got to know the plugin. This plugin is very helpful for creating web applications with WordPress. A small minus is the missing attribute “Required” for some file types like “Map”, “Autocomplete”, “Color Picker” and “Advanced Image”. Anyway, i think i will love the plugin more and more the deeper i dive into programming.

January 31, 2020 at 3:05 PM #18076

Anh Tran
Keymaster

Thank you for your kind words and your feedback. We keep improving the plugin and will try our best to make it more useful for you!

April 22, 2020 at 1:38 AM #19200

Robert Wilson
Participant

Using the example above, I’m wondering how one would go about ensuring that a workout_exercise is only created if a workout has been selected (assigned to it). Essentially, don’t allow an exercise to be created without selecting a workout that it is related to. I hope that makes sense.

Thanks you for creating such a fantastic set of plugins. I would love to see more examples using “Twig”.

April 22, 2020 at 10:39 AM #19213

Long Nguyen
Moderator

Hi Robert,

The extension only helps you to create the relation between the posts, but thanks for the idea, I will discuss with the developer team to support the property 'required' => 1 to check this box not empty like the required fields.
Author

Replies

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

You must be logged in to reply to this topic.

One-to-many relationship on “bay_mb_relationships”