Hello,

I just thought that it also would be nice to have another standard data type in the data types options. Similar as the Joomla User lookup, it would be nice to have a article lookup (ideally by category) to link to an article in the Joomla CMS.

For the moment I can code it myself, but it will be a useful feature in the future I think.

Kind regards,

Misha

Nice suggestion!

I want to connect a table to the article table of joomla.

So: in my table a foreign key that point to the joomla table with articles

Is that possible?

What type of connection do you want ? SQL JOIN ?

Able to modify the article, or only reading it ?

prepareQuery() :

addWhere(...)
addJoin(...)
addSelect(...)

Simple

Yes, thanks, that is possible by adding source to the genereted code, i knew.

But i ment : is it possible whitin cook, so cook generates the code, something like joomla user. Cook generates an id in the table and can create a dropdown in the views

Is that possible with tables that are not in the project? Is that possible with joomla tables?

//

---

MOVED TO NEW FUNCTIONALITIES

---

//
I think this has already been suggested as a feature request in the New Functionalities section. Moving this to that thread.

Gez