I have a form and on that form is repeat group. I'm trying to return the id of the records it the repeat group to use in an sql query.
In a calculated field I have something like this:
=================================================
$getRowId= '{rowid}'; //xoms_mgls___id
$subGroupRowId= '{Child Row Id}'; <--- how to return the child group ID
//xoms_order_basins___mgl_getid[] <-- child element
$db = JFactory::getDbo();
$options = array();
$query = $db->getQuery(true);
$query
->select(array('a.id', 'a.order_id', 'b.id', 'b.order_id'))
->from($db->quoteName('xoms_order_basins', 'a'))
->join('INNER', $db->quoteName('xoms_order_basins', 'b') . ' ON (' . $db->quoteName('b.id') . ' = ' . $db->quoteName('a.id') . ')')
->where('a.id = ' . (int) $subGroupRowId);
$db->setQuery($query);
$rows = $db -> loadObjectList();
foreach ($rows as $orderid) {
$getorderid= $orderid->order_id;
}
return $getorderid ;
=================================================
Thanks!
In a calculated field I have something like this:
=================================================
$getRowId= '{rowid}'; //xoms_mgls___id
$subGroupRowId= '{Child Row Id}'; <--- how to return the child group ID
//xoms_order_basins___mgl_getid[] <-- child element
$db = JFactory::getDbo();
$options = array();
$query = $db->getQuery(true);
$query
->select(array('a.id', 'a.order_id', 'b.id', 'b.order_id'))
->from($db->quoteName('xoms_order_basins', 'a'))
->join('INNER', $db->quoteName('xoms_order_basins', 'b') . ' ON (' . $db->quoteName('b.id') . ' = ' . $db->quoteName('a.id') . ')')
->where('a.id = ' . (int) $subGroupRowId);
$db->setQuery($query);
$rows = $db -> loadObjectList();
foreach ($rows as $orderid) {
$getorderid= $orderid->order_id;
}
return $getorderid ;
=================================================
Thanks!