https://wiki.stilit.se/ 2026-05-02T18:59:29+0000 https://wiki.stilit.se/ https://wiki.stilit.se/lib/tpl/dokuwiki/images/favicon.ico text/html 2019-06-28T06:58:07+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.stilit.se/doku.php?id=vortex:api:filter&rev=1561705087&do=diff Filter The Filter class is used to filter the data that is fetched from a table. Filters are used in the GUI to filter rows shown in the ShowList. Filters created in the GUI can be used in the API by supplying the Filter class constructor with the ID of the specific Filter. text/html 2019-06-28T06:58:31+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.stilit.se/doku.php?id=vortex:api:filterdata&rev=1561705111&do=diff FilterData The FilterData class provides a quick and simple way to create a Filter instance while scripting the Vortex. Constants F_AND - Methods Code Examples This example creates a new Filter searching for all posts in MyTable having show=1 and fetches the first 100 rows matching the criteria. text/html 2019-06-28T06:58:45+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.stilit.se/doku.php?id=vortex:api:import&rev=1561705125&do=diff Import The Import class handles importing data into the Vortex. Data can be imported from a variety of file formats as documented in the link here. Since version 1.1.1029 it is possible to invoke an import from the API to automate import processes for integrations. text/html 2019-06-28T06:59:15+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.stilit.se/doku.php?id=vortex:api:mailattachment&rev=1561705155&do=diff MailAttachment The MailAttachment class handles attachments in MailMessage instances. This class automatically encodes/decodes attachment content before/after sending/receiving messages. It also handles loading/saving attachments from/to files and keeps track of the mimetype of the attachment. text/html 2019-06-28T06:58:58+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.stilit.se/doku.php?id=vortex:api:mailer&rev=1561705138&do=diff Mailer The Mailer class handles incoming and outoing E-mail messages. It can connect to a mailserver using the IMAP or POP3 protocols to customizable server ports. Sending mail is currently done using the PHP mail() function which by default uses the local sendmail daemon to send mail. text/html 2019-06-28T06:59:28+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.stilit.se/doku.php?id=vortex:api:mailmessage&rev=1561705168&do=diff MailMessage The MailMessage class keeps track of a single mail message with one or multiple bodies and attachments and header information. Extends Implements Constants TEXTMessage part typeMULTIPARTMessage part typeMESSAGEMessage part typeAPPLICATION text/html 2019-06-28T06:59:44+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.stilit.se/doku.php?id=vortex:api:optimizer&rev=1561705184&do=diff Optimizer Added in version 1.2.1242 The Optimizer collects statistical information about the internal class and method usage in a database table. To let us optimize the Vortex engine for future performance upgrades there is also a method to post the statistical information periodically to our servers. text/html 2019-06-28T06:59:59+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.stilit.se/doku.php?id=vortex:api:relationfactory&rev=1561705199&do=diff RelationFactory The RelationFactory is a factory cacheing all Relations loaded by Vortex. All instances of Relation have to be instanciated through the RelationFactory. The factory keeps a cache of the Relation instances which will be returned. If no chache exists a new instance of Relation class is created, put into cache and returned. text/html 2019-06-28T07:00:16+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.stilit.se/doku.php?id=vortex:api:table&rev=1561705216&do=diff Table Fetch records There are a couple of methods to fetch TableRecords from a Table. Which method to use depends on which information is available and the quantity of records to fetch. To fetch one TableRecord from a Table when having the UUID for the wanted TableRecord, simply use text/html 2019-06-28T07:00:35+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.stilit.se/doku.php?id=vortex:api:tablefactory&rev=1561705235&do=diff TableFactory The TableFactory is a factory cacheing all Tables loaded by Vortex. All instances of Table have to be instanciated through the TableFactory. The factory keeps a cache of the Table instances which will be returned. If no chache exists a new instance of Table class is created, put into cache and returned. text/html 2019-06-28T07:00:54+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.stilit.se/doku.php?id=vortex:api:tablerecord&rev=1561705254&do=diff TableRecord The TableRecord class describes one record from a Table. Extends TableStub Implements Initializable Constants Methods Code Examples Connect the 1-side of a Relation to another record $thisTableRecord = TableRecordFactory::getTableRecord( 'myTable', $idTableRecord1 ); $otherTableRecord = TableRecordFactory::getTableRecord( 'myOtherTable', $idTableRecord2 ); $thisTableRecord->set( 'theRelationField', $otherTableRecord->getUUID() ); text/html 2019-06-28T07:01:13+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.stilit.se/doku.php?id=vortex:api:tablerecordfactory&rev=1561705273&do=diff TableFactory The TableRecordFactory is a factory cacheing all TableRecords loaded by Vortex. All instances of TableRecord have to be instanciated through the TableRecordFactory. The factory keeps a cache of the TableRecord instances which will be returned. If no chache exists a new instance of TableRecord class is created, put into cache and returned. text/html 2019-06-28T07:01:27+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.stilit.se/doku.php?id=vortex:api:view&rev=1561705287&do=diff View The viwes in Vortex keeps track of which fields and relations to load and show. Views are used and can be created in the GUI, but can also be a powerful tool to speed up data access in the API. When loading data through a view only one query is run to fetch data from the database.