Hey Simon!
Thank you for trying to solve this.
But I still have the same multiple results when that record has been assigned to another records.
What strikes me is that I have the same result changing the alt_module for calling_module so I wonder... is the query that responds to that request?
Besides, if I change to true private $debug = false; in the Model, It doesn't show me the query.
It is a mistery I've been trying to resolve for months
Thanks again!

I've solved this taking out Order by from all queries!
Thank you Simon
Cheers!

Hi Claudia,

Glad you have solved the problem :)

Yes, you are right about not being able to see the SQL if you set debug to True on 'Model.php', but you can if you use David's 'Postperson' module from the Module Marketplace or Postman if you prefer bloated commercial apps.

Goto http://localhost/blog/blog_notices/show/2 to view your page and hit control+u to show the source code of the page. Scroll down to where the JavaScript is:


Open Postperson in another tab and set request type to 'POST'. Then target URL to
Grab the token from above and paste it into 'Trongate Token' (if you get an invalid token, remove the token and try again), you can also comment out 'api_auth(); in fetch_available_options() of 'Module_relations.php' if all else fails.


For 'Parameters' use this:

then scroll down to 'public function query($sql, $return_type = false)' in 'Model.php' and insert a die($sql); as shown below:

Hit submit in Postperson and you should see the SQL in the popup modal


You can also remove the die() statement to see the returned dropdown options too


cheers,
Si