-
New Commercial Services Section
We have now opened a commercial services section here on the forum for registered users. If you have a Fabrik project that you wish to have someone work on for you, post it under Help Wanted. If you are an application developer and wish to earn some money helping others, post your details under Fabrik Application Developers.
Both of these are unmoderated. It will be up to both parties to work out the details and come to an agreement.
-
Joomla 5.1
For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Search results
-
W
databasejoin plugin - issue with additional sql
Well i just checked the recent github version. Modifications have been done like 3 days ago: "Fixed issue in join's dataConsideredEmpty(), for multi select joins." but the fix i posted 20 days ago to fix the join issue has not made his way into github. This means that anyone who wants to use... -
W
Tooltip on List Header instead of List data?
Hello, is it possible to set the tooltips on the list header rather than on the list elements? I haven't found any backend setting to get this running. Only tooltips when hovering over the data. Using forms however, tooltips are proper shown when hovering over the label. -
W
databasejoin plugin - issue with additional sql
friendly bump ;-) @cheesegrits: did you have the time to review the proposed changes? -
W
Custom CSS Classes for Forms and Lists?
This is related to joomla 2.5 and fabrik 3.0. Unfortunatly the hosting does not provide the right php version for joomla 3.0. -
W
Custom CSS Classes for Forms and Lists?
Hello, is it possible to define custom css classes for forms and lists? Looking to the layout section for both (forms and list) i can select a template but not set a css class. Looking to the generated code using on of the default templates ( i chose bootstrap because my joomla template... -
W
Github
The "mysterious " ${createdate} as it had been asked a few times on the forum, comes from the predefined xml files from each module/plugin/component of fabrik in github. My guess is ( but i haven't looked into it in detail), that it is a placeholder that will be used to patch in the final... -
W
databasejoin plugin - issue with additional sql
ok its done and working: in buildQueryJoin() around #700 add regex for a simple join. $re = "(JOIN)" . "|" . "(LEFT\s+JOIN)" . "|" . around line #762 fix the regex to remove JOIN. Note the change of s+ to s*, because if teh line starts with JOIN, there is no whitspace or... -
W
databasejoin plugin - issue with additional sql
Well i found where the problem coms from. ;-) the new function buildQueryJoin() fails to dectect the type and condition part. so what happens is: teh entire expression is treated as the "type" and "condition" remains empty. So when calling query->join($type, $condition), the joomla query class... -
W
databasejoin plugin - issue with additional sql
Thank you very much for your work. Well i tried the new stuff after doing a _full_ github update. i put this in the new join field: JOIN wa_contenttype_to_category AS a ON a.contenttype_id = 1 and this in the where field: WHERE joomla_content.catid = a.category_id and got the... -
W
databasejoin plugin - issue with additional sql
Thank you for taking the time reading this stuff. I would have gone the easy route forcing buildQueryWhere() to return a string and then add the string to the select part created in buildQuery(). Or - i would have created the entire sql as a string and handed over to an empty query object... -
W
databasejoin plugin - issue with additional sql
As i explained before - its used to automatically get only the articles which belong to a "cck" category. Quoing myself: -
W
databasejoin plugin - issue with additional sql
Looking to the code, i think i can fix this. Would need to change: arround line 597 protected function buildQuery($data = array(), $incWhere = true, $opts = array()) and arround line 698 protected function buildQueryWhere($data = array(), $incWhere = true, $thisTableAlias = null, $opts =... -
W
databasejoin plugin - issue with additional sql
Thank you for your reply. But sorry to say, the concat field cannot be used in this way. It wraps the code (as it says) in a CONCAT statement. Example from test: SELECT SQL_CALC_FOUND_ROWS DISTINCT `wa_content_switch`.`id` AS `wa_content_switch___id`, `wa_content_switch`.`id` AS... -
W
databasejoin plugin - issue with additional sql
Hmm - this seems to be a bigger one than i initially thought. The current databasejoin plugin makes use of the joomla query object to prepare the custom sql. (see protected function _buildQueryWhere around line 709) It uses joomlas $query->where wich prepends "WHERE". So basically the... -
W
databasejoin plugin - issue with additional sql
I use the database join plugin with additional sql in the field "Joins where and/or order by statement (SQL)". Here my add. sql: JOIN wa_contenttype_to_category AS a ON a.contenttype_id = 1 WHERE joomla_content.catid = a.category_id This leads to the following sql created by fabrik, which is...