Table Handling Record List Edit Menu Estimated reading: 9 minutes Record List – Edit Menu The Record List displays data records of a table. The Menu Bar and Toolbar provide all the commands to select data records, customize the view, add new data records, edit , delete, ‘version’ or archive data records. You can also create reports or export the data. File Save Modification will be saved. Create New Create a new data record. 2 variations are possible. The ADMIN defines per table which variation is used. Variation 1: After selecting File -> Create New , a window appears with the question :’ Do you want to create a new record?’ When confirmed with OK, a Data record ID will be assigned and an empty data record is created. This data record can now be edited. It is not recommended to create empty data records. Variation 2: After selecting File -> Create New, a window appears with the question:’ Do you want to create a new record?’ When confirmed with OK, an input mask appears to enter the data. The data records will only be created after you choose ‘Save’. Copy Selected data records are copied, but only the data fields defined by the ADMIN will be copied. Print The print function of your browser will be activated. The screen contents will be printed or saved to a file. Lock Selected data records can be locked for a certain period. The period can be specified in minutes, hours or days. Locked data records are listed in Reports or in the Record List, but cannot be edited. To get an overview about locked data records, click on the User Function Profile Locked Data. There you can also easily unlock these data records. Versioning This command is only available, when this functionality is enabled for a table. Versioning means, that a data record exists various times and can have different versions. This can be used eg. for different prices of an article. Version 1 contains the original price, version 2 the new price. Archive Selected data records will be archived. Archived data records are not listed in Reports or in the Record List. To edit (change, version or delete) an archived data record you have to recover it. Delete Selected data records will be deleted. They are physically deleted and cannot be restored. Edit Search (or double click in a search field) (Example of the search for details) Search within the current table for one or more search terms, in one or more fields. In the ‘Detail Search’ window you can select the field you want to search in. You can search with a specific search term. You have also the possibility to restrict the search for part of the data field, e. g the beginning. CScase sensitive to be considered (CS = case sensitive)Negationnegates the query A field can be searched by multiple search terms. The operator AND / OR controls whether all terms have to be true or just one of them. ANDAll search criteria for this field have to be fulfilledOROnly one of the search criteria for this field have to be fulfilled To start the search click on the Search button. You will see your search term also in the search field above the column header. You can select more than one field for your search. You can expand a list of these search criteria. With Global AND / OR you define the Boolean operator between the search results of fields. ANDAll search conditions of all fields have to be fulfilledOROnly search conditions of one of the fields have to be fulfilled This setting is relevant for all fields! Example: Invoice date, invoice value, payment due date, payment received, payment value Search one field search invoice date: 1.5.2012 All invoices with invoice date 1.5.2012 are displayedSearch one field with a search term (invoice date) and search criteria (greater than or equal to) Invoices with invoice date: ⩾ 1.5.2012 All invoices with invoice date starting 1.5.2012 are displayedSearch 1 field 2 search criteria Search invoices with invoice date: ⩾ 1.5.2012 and ⩽ 15.5.2012 All invoices with invoice date in the range of 1.5.2012 to 15.5.2012 are displayedSearch several fields Invoices with payment due date: ⩾ 1.5.2012 Payment received: not empty Global AND both search conditions have to be fulfilled! All invoices with invoice date starting 1.5.2012 and payment received are displayed. Reset Selection and Filter Reset of selected data records, resets all data records, including the search queries and sort criteria, to default settings. Select All Select all displayed data records. Edit List Editing of data records in the Record List. Certain data fields can be edited in the Record List. (links and long fields can’t be edited). This function enables you to quickly update several data records. Don’t forget to save the modifications. Return to’ view only mode’ by clicking again on Edit -> Edit List. Stack Processing Simultaneously modify multiple records. The command appears only in the Edit Menu, when this function is enabled for this table. When Stack Processing is enabled by the ADMIN, he also defines for which table fields this functionality can be used. After choosing ‘Stack Processing’ only the relevant fields are displayed. Make sure you have selected the data records you want to modify. If no data records are selected, the changes will take effect in ALL DATA RECORDS! You can select individual data records, or use the search function. View The commands shown in the Menu ‘View’ can vary from table to table. Where a data record cannot be versioned, the command ‘Show Versioned’ will not appear. If the command ‘Show Versioned’ is chosen, the text ‘Show Versioned’ will appear in grey with a tick to its right. Toolbar Hide or unhide toolbar. Default Width Reset column width to default values. Show Archived Show archived data records or hide them (hide = default) Show Locked Data Displays only locked data records. Hide Locked Data Locked data records will not be displayed. Show Versioned Displays all versions of versioned data records. In order to show the versioned records you must be in the record list. Go to the menue view and click “show versioned”. The table now shows all records, versioned or not. All versions of one item are shown after each other. There is now a new column in the table which shows the version number of the record. If you have a versioned record this record is red. Show Sum Shows sum of value fields. The sum is taken only from the values of the records displayed. Extras Reports Creating reports. Depending on your application various reports can be available for a table. After selecting the required report, the format of the output file has to be specified. The following formats are available: .pdf .odt .xml The report can be saved (archived) or a preview can be first displayed and then be saved.A report that, for example, creates a list of customers from the customers table, will contain all displayed customers (number of hits in the footer). A report that creates invoices will create invoices only for selected data records. Please note that all invoices will be in one file. The Print button allows you to print the report directly to the selected printer after it has been created. Snapshot A snapshot is a search query that is saved and can be used again. Extensive or complicated search queries or frequently used one’s, needed to be created only once and can be reused. A snapshot can be shared with other users. When a snap shot is published it is available in the Navigation Menu. User specific search queries can be: Saved Published Edited Administrated To save a snap shot go to Extras ->Snapshot -> Save As and choose a name for the snapshot. You will now find this name in your Workplace to start the search query direct. Go to Extras -> Snapshot -> Administrate to edit, publish or delete a snap shot. A published snap shot can be used by other users. These can be defined individually or via user groups. The user or user group can get the right to: Use a snapshot Edit a snapshot Delete a snapshot A snapshot can also be administered in My Profil / Snapshot. There you will also find a detailed description Snapshot. (A deleted snapshot will only disappear in the Navigation Menu after a reset is performed) Export Export datarecordsChoose format Exel XML Select datarecords for exportShown – only the data records displayed on the screen will be exportedalle – all data records will be exported (number of hits in the footer) A window then appears (content depends on the browser used). Select if the result is saved as a file opens with a program to select Setting the path Formulate the browser’s DOWNLOAD DIRECTORY. User Rights If the rights to a specific table or line have been assigned by the admin, you can assign different rights to selected users: (Extras → User rights): read edit delete Special Features ! Disable Limitation Caution: The limit of data records (max. number of hits) is defined by the admin. Disabling this limit can cause system overload and poor response time. Before disabling the limit, check how many data records the table contains (click on number of hits) and if you need to select all of them. Contact the ADMIN if you have any doubts. Force Delete This command is only available to a small group of users. Example: Data record ‘customer’ is linked to a data record ‘contact’. Data record customer will be deleted. With Force Delete, also the data record ‘contact’ can be deleted (providing ‘contact’ has no further links) Toolbar Record List Save Changes Create Record Copy Record Delete Record Archive Record Search Record Edit List Show archived Records Reports Delete Search and Filter Criteria Global Search Global Search Other than the the field-specific search fields, where only the respective field is searched, in the global search all fields of the table are searched.