Fabrik User Manual 0

Prefilters
The prefilter options can be found by editing a table, and selecting the 'data' tab. Their
general use is described in the
table's section of this document
.
A more advanced example of what can be achieved is these date examplez:
Get the records stored in the last 2 months:
WHERE: datefield
GREATER THAN: DATE_SUB(CURDATE(),INTERVAL 2 MONTH)
TYPE: QUERY
Get the records for the upcoming week:
WHERE: datefield
GREATER THAN: DATE_ADD(CURDATE(),INTERVAL 1 WEEK)
TYPE: QUERY
Display only the logged in users records:
WHERE: userfield
EQUALS: {$my->id}
TYPE: STRING
Element Filters
For each element you have the option to add a filter to the table view, allowing your
users to filter the table data. These are applied in addition to any pre-filters. For
information about the individual element filter settings see
here
.
Clearing filters
You can clear the filters by pressing the 'clear' button at the top of the filter table. This
will remove all the users filters from their session, but will still apply the table's prefilters
In addition you can pass in variables via the querystring to clear and/or reset filters
clearfilters=1 : will clear the prvious filters and not apply any other filters except
prefilters (has the same behaviour as the 'clear' button
resetfilters=1 : will clear previous filters and apply any curent querystring filters and
prefilters
95

---

Table plug-ins
Table plug-in's allow you to add additional functionality to your Fabrik table.
To add a plug-in to your table select the "Plugins" tab and press the "Add" button. Then
select the plug-in from the "Action" drop down. Currently we only distribute as default
the copy plug-in.Create link to table
Copy plug-in
The copy plug-in will add an additional button to your table as per the image below:
Select the rows you wish to copy and then press the copy button.The row will be copied
and the page refreshed showing the newly created rows.
96

---

Create a link to you table
To create a Joomla menu link to your table:
• Select "Menu->main menu" from the top administration menu.
• Then press the new button
• Next select "Fabrik->table"
• Give your link a name and on the right hand side of the form select the table you
want to link to.
You have some additional options you can edit if so desired:
• Reload calculations - By default Fabrik only runs element calculations (sum,
average etc) upon form submission. Select 'yes' here if you want those values to
be recalculated each time the menu link is clicked on.
• Template - overrides the table's template when viewing the table from this
menu link
Connections
Connections allow you to connect Fabrik to other MySQL databases in addition to the
database that Joomla uses. Note that the user credentials you enter here must have
access to the database in question.
Each connection can be selected with the check box to the left of its name. Once
selected it can be altered by clicking on the buttons in the top right hand corner:
• Default - Set the connection to be the default connection. This means that this
connection is selected as default when creating new Fabrik tables.
• Published - sets the state of the connection to published
• Unpublish - sets the connection's state to unpublished
• Copy - copy's the connection
• Delete - deletes the connection
• Edit - connection the form, note that you can also edit the connection by
clicking on its name
In the top right menu there is also the "New" button which allows you to create a new
connection.
For each form in the list you have a couple of links:
• Published - toggles the form's published state
• Test connection- Test if the connection is able to connect to the database.
97

---

Add / Edit a Connection
On this page you can add or edit a connection
• Description - The label used to describe the connection
• Host - the databases host this is most likely 'localhost' but may also be an IP
address
• Database - the database name
• User - the user that has access rights to the database
• Password - The users password
• Confirm password - Confirmation of the password is required so that you don't
enter a misspelt password. (Note that if editing a connection these fields will be
blank, leave them as such to retain the original password)
• Published - Is the connection published?
98

---

Plug-ins
Fabrik contains several types of plug-ins, each of which is dealt with in more detail in
their corresponding sections. The types of plug-ins Fabrik users are:
• Elements
• Forms
• Validations
• Tables
• Visualizations
You can view your installed plug-ins by selecting components->fabrik->plug-ins.
You can filter the list of plug-in from the Type drop down
Plug-ins listed as greyed out are the core plug-ins installed by fabrik and these are not
uninstallable
To unistall a non-core plug-in click on the radio button next to its name and press the
"uninstall" button on the top right of the page.
More plug-ins can be found on the Fabrikar.com web sites download section.
To install a plug-in:
• Press the browse button
• Locate the plug-in zip file on your hard drive
• Press the "upload file and install" button.
99

---