Infodrom Oldenburg

— OpenRico —

11.9.2008: Column specific filters OpenRico 2.0rc2

The LiveGrid class allows to specify text and select filters for each column so that the displayed rows of the grid can be limited to several conditions that have to match at the same time. For checkboxes (i.e. the Rico.TableColumn.checkbox control) this does not exactly apply.

However, the space could be used for special controls that operate as "check all" and "uncheck all" for the visible checkboxes in that particular column. This patch adds a possibility to create custom filter controls for columns, e.g. plus and minus signs for checkbox columns.

Download: Patch
20.9.2008: Improved LiveGrid resizing OpenRico 2.0rc2
This patch allows adjusting the width of the element surrounding the LiveGrid if it permits this via the special attribute 'autoresize="1"'. This is especially useful when the surrounding element is a table column (<td>) and there's another element next to the LiveGrid. Without this patch, the grid won't be able to use the entire space it should.
Download: Patch
28.9.2008: Rico.TabbedPanel with Memory OpenRico 2.0rc2
This class implements the same functionality as Rico.TabbedPanel plus a cookie based memory so that the tab always selects the same tab upon page load.
Download: Patch
17.2.2009: Support for complex filters OpenRico 2.0rc2

This patch allows developers to specify more complex filters than simple equality or LIKE filters. This opens room for filters that make utilise set relations such as "fieldvalue IN (?)". The question mark is replaced in the backend ricoXmlResponse.php by the filter value supplied by the Rico.Buffer.AjaxSQL.

Download: Patch
21.9.2009: Multiple edit popups OpenRico 2.0rc2
This patch allows the use of edit popups for more than one ricoLiveGrid on the same page
Download: Patch
2.8.2010: Sort dropdown filter boxes OpenRico 2.1
This patch sorts the results of the SELECT callback for select filters of LiveGrid tables. This helps find relevant filter entries.
Download: patch
2.8.2010: Support for PostgreSQL OpenRico 2.1
This patch adds support to PostgreSQL as backend SQL server
Download: Patch, Patch 2
27.8.2010: Filter with lookup table OpenRico 2.1
Use converted value if column uses a lookup table (Rico.TableColumn.lookup)
Download: patch
5.4.2013: Support sorting lookup columns OpenRico 2.1
This patch allows the programmer to specify a special query for distinct column queries such as used by TableColumn.lookup controls.
Download: Patch
19.4.2013: Workaround against Firefox 20.x XML parser problem OpenRico 2.1

This patch adds back the possibility to display HTML code in LiveGrid columns that broke in Firefox 20.x. Before this one could return HTML code such as <img src="...something"> that was parsed as proper image tag.

The behaviour of the XML parser in XmlHttpRequest has changed. This breaks display of HTML elements returned by AJAX/SQL backends.

The behaviour differs from other browsers and older versions of the same browser. It is possible that it'll be changed back in Firefox 21.x and higher.

This breaks Icons and other HTML code in Rico.LiveGrid cells

This patch has been rejected upstream - since the fix should be applied to Firefox instead.

Download: Patch
13.3.2014: Remove unresolvable filter OpenRico 2.1

This patch fixes a problem with with regards to select filters.

When the filter value is stored in a cookie the filter is automatically reapplied on page reload. If table values have changed in the meantime so that the original filter value is not available anymore the LiveGrid will display 0 rows and the select filter element will display __ALL__ (since the value it is set to is not available).

The problem could be resolved by filtering for a different value and then resetting the filter select element back to __ALL__. However, since the filter already displays __ALL__ most users won't notice that the grid is already filtered.

Download: Patch, Patch for rico3
1.9.2014: Honor horizontal scroll for position calculation OpenRico 2.1
When a control is positioned over an icon the vertical position honors vertical scrolling, but the horizontal position does not honor horizontal scrolling. This is fixed now.
Download: Patch, Patch for rico3
20.9.2015: Examine text filter on change OpenRico 2.1
This patch lets Rico update the grid content if a filter value changes, e.g. by pasting into it with a mouse.
Download: Patch, Patch for rico3
21.9.2015: Correct Caret in filter specs OpenRico 2.1
ccording to the documentation t^20 will search for a substring only at the beginning of a string. Unfortunately, however, support for this got lost in the JavaScript frontend. The attached patch adds it back. Additionally it allows to specify t$20 for substring searches at the end of a string, only for completeness.
Download: Patch, Patch for rico3
21.9.2015: Convert filter value for type date OpenRico 2.1
When the date format differs from iso format, filters will fail. This patch converts German date specified in filter to iso date so the filter can work.
Download: Patch, Patch for rico3
21.9.2015: Fix week number calculation OpenRico 2.1
The rule is that week 1 is the week that has at least 4 days, i.e. that contains the first Thursday. var offset represents the day-of-month for the first Thursday. The week number is printed for each Thursday as well.
Download: Patch
30.9.2015: Fix wheel scrolling on LiveGrid content OpenRico 3.0
In Rico3 this.tabs contains 3 elements, not 2 as in Rico2. Wheel scroll delta defaults to 0 but is not adjusted for Gecko, thus use 1 as default value. The attached patch fixes this.
Download: Patch