• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Retrieve data in select

Retrieve data in select 4 years 4 months ago #39649

Hello,

I need to retrieve in a selector a published article list with displayed next to the title of the article the value of the associated joomla custom field calendar.

In front something like this :

Select your courses :
Title of the article - 25/12/2019 (date from the custom field)

I see this article but i don't know how combile with the custom field www.rsjoomla.com/support/documentation/r...st-from-a-table.html

With that code i am able to retrieve article title from specifics categories
//<code>
// Prepare the empty array
$items = array();
// Prepare the database connection
$db = JFactory::getDbo();
// Keep this if you'd like a "Please select" option, otherwise comment or remove it
$items[] = "|Please Select[c]";
 
// Run the SQL query and store it in $results
$db->setQuery("SELECT title, title FROM jos0x_content WHERE catid = 13 or catid = 14");
$results = $db->loadObjectList();
 
// Now, we need to convert the results into a readable RSForm! Pro format.
// The Items field will accept values in this format:
// value-to-be-stored|value-to-be-shown
// Eg. m|M-sized T-shirt
foreach ($results as $result) {
  $value = $result->title;
  $label = $result->title;
  $items[] = $value.'|'.$label;
}
 
// Multiple values are separated by new lines, so we need to do this now
$items = implode("\n", $items);
 
// Now we need to return the value to the field
return $items;
//</code>

But i need to retrieve the associated value of the custom calendar field and i don't know how do this ?

Thanks for your help.
The administrator has disabled public write access.

Retrieve data in select 3 years 11 months ago #40186

  • matt.hankosky
  • matt.hankosky's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 1
The custom fields are stored in another table. You would have to do a 2nd lookup or a JOIN request.
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!