Don't load all relationship results

[emptynick]

In a belongs to many relationship all related items were loaded here:
https://github.com/the-control-group/voyager/blob/eb83ecb0f10192eed83dd8d2a3975dc3c8b32252/resources/views/formfields/relationship.blade.php#L174

Although we use ajax to load related items.
Another problem was that enabling tagging disabled ajax which does not make sense at all.

Possibilities tested:

• Adding
• Editing
• Editing with failing validation (selected relationships stay)
• Tagging
• No tagging (yes, this needed to be considered)

[codecov-commenter]

Codecov Report

Merging #5465 (ef087f7) into 1.5 (eb83ecb) will not change coverage.
The diff coverage is n/a.

@@            Coverage Diff            @@
##                1.5    #5465   +/-   ##
=========================================
  Coverage     63.50%   63.50%           
  Complexity     1401     1401           
=========================================
  Files           195      195           
  Lines          4137     4137           
=========================================
  Hits           2627     2627           
  Misses         1510     1510           

---

Continue to review full report at Codecov.

Legend - Click here to learn more
Δ = absolute <relative> (impact), ø = not affected, ? = missing data
Powered by Codecov. Last update eb83ecb...ef087f7. Read the comment docs.

[vitormicillo]

Works perfect

[FromSi]

belongsToMany in BREAD

Error when entering the edit page in BREAD

[33Piter]

belongsToMany in BREAD

Error when entering the edit page in BREAD

Same problem here.

[emptynick]

That's not really a lot information to reproduce.
Can you guys figure out which query causes this?

Edit: Seems like this happens when you have an ID field in the pivot table - is there a reason to have this?

Edit 2: Fixed in 8c3c1dd

[33Piter]

That's not really a lot information to reproduce. Can you guys figure out which query causes this?

Edit: Seems like this happens when you have an ID field in the pivot table - is there a reason to have this?

Edit 2: Fixed in 8c3c1dd

Hello, @emptynick, thanks for the quick fix.

Came here to give more info, but you already found it.

That's exactly the scenario that causes the problem: I'm working on a project that have a pivot table with id column.