Welcome, Guest
Username: Password: Remember me

TOPIC: Article Lookup Data Type

Article Lookup Data Type 27 Nov 2012 09:28 #5654

  • blue-canoe
  • blue-canoe's Avatar
  • Offline
  • Senior Member
  • Posts: 57
  • Thank you received: 16
  • Karma: 7
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
The administrator has disabled public write access.
The following user(s) said Thank You: JoomGuy

Re: Article Lookup Data Type 04 Dec 2012 11:44 #5813

  • JoomGuy
  • JoomGuy's Avatar
  • Offline
  • Moderator
  • Joomla Enthusiast, Lover of Cooking
  • Posts: 1115
  • Thank you received: 195
  • Karma: 64
Nice suggestion!
Need help with your Cook/Joomla Project? . PM me to find out what I can help with. NO time wasters please!!!
The administrator has disabled public write access.

connecting to joomla table 12 Dec 2012 21:37 #6034

  • aria
  • aria's Avatar
  • Offline
  • New Member
  • Posts: 16
  • Thank you received: 3
  • Karma: 2
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?
The administrator has disabled public write access.

Re: connecting to joomla table 13 Dec 2012 11:07 #6044

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 987
  • Karma: 140
What type of connection do you want ? SQL JOIN ?

Able to modify the article, or only reading it ?

prepareQuery() :

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

Simple
Coding is now a piece of cake
The administrator has disabled public write access.

Re: connecting to joomla table 13 Dec 2012 11:57 #6048

  • aria
  • aria's Avatar
  • Offline
  • New Member
  • Posts: 16
  • Thank you received: 3
  • Karma: 2
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?
The administrator has disabled public write access.

Re: connecting to joomla table 13 Dec 2012 12:00 #6049

  • JoomGuy
  • JoomGuy's Avatar
  • Offline
  • Moderator
  • Joomla Enthusiast, Lover of Cooking
  • Posts: 1115
  • Thank you received: 195
  • Karma: 64
//
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
Need help with your Cook/Joomla Project? . PM me to find out what I can help with. NO time wasters please!!!
Last Edit: 13 Dec 2012 12:03 by JoomGuy. Reason: MOVED
The administrator has disabled public write access.
The following user(s) said Thank You: admin
Time to create page: 0.103 seconds

Get Started