Data Tables are available with onsite installs of ESdat Server and are managed by admin users. They allow users to access, filter and export data in a tabular format and are available under the Data View menu together with the Chemistry Results and Reports. Data Tables provide data in an unformatted manner, as distinct from Reports, which can provide data in a report ready layout and format (such as PDF).
Details for a Data Table can be managed by clicking on the name link.
The Database View Name is the name of a database view that returns the data that is to be shown in the Data Table. This should not be edited for standard Data Tables.
Data Tables can be enabled/disabled (or Published) and an icon set. Data Tables of a similar nature can be grouped together to make navigation easy.
The Logged in User Filter Column is the name of column that returns the name of the logged in user. Data is automatically filtered by the logged in user on the table according to security settings. Not setting this correctly will mean data is not returned as expected.
Any changes made to default views that come with ESdat should be documented and stored along with other information about the setup or configuration of your ESdat System.
The Areas tab allows a Data Table to be made available in other areas such as the Locations Portal.
The Columns tab allows the columns of the data table to be managed; the label used for the column in the interface, the display order, visibility and whether it is included in the export to Excel.
The Filters tab allows the filtering options for the Data Table to be configured; including the type of Filter, if it is required and whether the search is applied on the client or at the server. Applying it on the client dataset generally gives more optimal performance as all processing is done locally without re-loading data from the server. However for larger datasets this may require more memory usage, which can affect performance.
New Data Tables can be added that reference an existing database view for outputting to Data Tables (ie the list of views shown on the top screen shot), or new data views can be created by your database admin, or support (on a consulting basis). If your database admin wishes to create new database views for use through this functionality they should be skilled in creating views in SQL Server, and have received an online introductory training session on the specific requirements of these views from support.