Search results

  1. S

    Using 'Group By' on a List based on a Remote Connection

    This issue seems to be my own stupidity. I had applied a custom template (which I subsequently took off the list but I think it remained on the menu item) which I copied from the other server. It had a query in default.php that occurs in the <tr> group heading so I guess it was only triggering...
  2. S

    Using 'Group By' on a List based on a Remote Connection

    I have a remote connection to a database and it tests successfully. The database user has read only permissions to a few selected tables. I created a list based on one of these remote table, and then went into phpMyAdmin and set it to "isview":"1" because it was throwing errors when saving...
  3. S

    Updatecol and Date Filter Range

    Appreciate that Hugh, I've updated that in about 6 places and made a note so I don't use it again.
  4. S

    Updatecol and Date Filter Range

    Yes I do need them at the same time and it's quite critical to have the functionality. I think I found a complicated path forward. I determined I couldn't drop the range filter because I'm doing things that depend on the range like this for other processes: //Capture the Filter Array (Date...
  5. S

    Updatecol and Date Filter Range

    I understand the updatecol plugin cant function when a date has a range filter: http://fabrikar.com/forums/index.php?threads/updatecol-list-plugin.49127/ What about as a workaround, setting the date field to 'field' so updatecol functions correctly, then modifying a custom lists template...
  6. S

    List Template - Add PHP to Grouped Row

    Thanks for the response Hugh, I actually got it working, I think the errors I was getting were related to not encapsulating my datetime in the query. Here is the working code: <!-- Steve added to display the last edit of the day --> <span class="lastModified"> <?php...
  7. S

    List Template - Add PHP to Grouped Row

    Actually it looks like what I needed is just echo $groupedBy; Now the question becomes, am I able to run a query on the database inside this default.php file? I'm receiving errors when I follow the PHP Common Tasks.
  8. S

    List Template - Add PHP to Grouped Row

    I'm grouping a list on a Date field. The 'group by' has access set to 'Nobody' so it never changes. I'm modifying the default.php of a template and what I want to do is get the first record of the group and run a query to add related info to the group line. Getting the id of the first record in...
  9. S

    Cascadingdropdown with no Foreign Key

    WOW that worked great! Many thanks troester :) Performance is good too. I see it helps to know what you're doing! The only problem I had after your suggestion was that the ordering was doing strange things on the form, and ignoring my sql order by (I'm guessing it builds dynamically after the...
  10. S

    Cascadingdropdown with no Foreign Key

    Hello, I have a list which has 7 Cascading Drop Downs. Multi select wont work for a number of reasons. I'm trying to accomplish 7 similar CDD's but between two tables with no direct connection (no foreign key). The tables are related through several joins. I ended up creating a table (based on...
  11. S

    php list plugin, JS confirmation

    Referencing the thread from 2012 "confirmation window php plugin list" it looks like the functionality was added to abort the list plugin code execution if the user clicks cancel on the JS confirmation popup. I'm getting the popup but regardless of whether I hit OK or Cancel, the php code still...
  12. S

    PHP list plugin, show results of Query in status message

    I was able to finally accomplish this after giving up several times. This is the working code I came up with: // This will find all the email addresses of the students in the selected course $db = FabrikWorker::getDbo(); $ids = JRequest::getVar( 'ids', array(), 'method', 'array' ); foreach...
  13. S

    Duplicate a table on remote server

    I'm trying to use a scheduled task (once daily) to duplicate a table on a remote server. Basically I want to use a INSERT, ON DUPLICATE KEY UPDATE query to keep the remote table identical to the local. I found this thread which was somewhat helpful but it is the reverse and doesn't update on...
  14. S

    PHP list plugin, show results of Query in status message

    So I'm trying to use a PHP list plugin to run a select query which returns a single column (of email addresses). I want to somehow display the results of the select query to the user. I thought I would be able to put the results into the status message but I'm likely doing something wrong. Is...
  15. S

    Best practice for two types of users

    I'm in the planning phase still. I just meant students will have 50 elements unique to students, and teachers will have 50 elements unique to teachers. For sure I will need to assign different J! groups based on student or teacher. I haven't explored the juser plugin, and I dont have any user...
  16. S

    Best practice for two types of users

    I'm looking to create 2 (or more) identities, namely students and teachers. I would like to retain the possibility for each type of identity to login to the J! site. The problem is each identity has totally different elements (and lots of them): student elements = username, pass, email, a, b...
  17. S

    Fullcalendar, remove element can't fire events of plugin

    Hugh, I'm interested in this functionality (fullcalendar & cron). Is this still in development? If so I wouldn't mind testing it, if it would help. Also, I do have a G Suite account.
  18. S

    FilterValue and URL parameter lost when ordering

    Hi Hugh, did you ever have a chance to look at this? Is it something specific to my config or can you replicate it?
  19. S

    FilterValue and URL parameter lost when ordering

    Any thoughts on this one? I added that one line to the 'Annual' list footer so you can login and see the error (when the Annual list is ordered). If I Ajaxify the Annual list it doesn't error when ordering but that wont work for me because in the end I need the details views rowid to match the...
  20. S

    update_col pops up blank window on page load

    Seems I was somehow missing the layouts folder entirely. I took the entire 'update_col' folder you referenced from github and extracted it onto my site. It's working now, much appreciated.

Useful links

  • Create a Fabrik Account (Downloads)
  • Create a Forum Account
  • Fabrik Wiki
  • Fabrik 4 Changelog /Install /Upgrade
    • We are in need of some funding.
    More details.

    Thank you.

    Members online

    Total: 106 (members: 3, guests: 103)
    Back
    Top