Database Table "hyp_Advanced Search Wizard"
Table Description
The Advanced Search Wizard of Hyper is used for creating and defining filters for customized searching, according to the users needs.Normal Storage |
Archive Storage |
Deleted Storage(Recycle) |
| Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
|---|---|---|---|---|---|---|
| Filter ID | Integer | 0 | Edit | Hidden Read Only Key Field |
FilterId | |
| Filter Name | String | 40 | Edit | Mandatory | FilterName | |
| Icon | String | 30 | PopupList | Icon | ||
| Main Table | String | 50 | Select | Read Only | MainTable | |
| Authorized Groups | String | 500 | PopupList | AuthorizedGroups | ||
| Authorized Users | String | 500 | PopupList | AuthorizedUsers | ||
| Sorting Level | Values List: 0 = 01 = 1 2 = 2 3 = 3 4 = 4 5 = 5 6 = Create Button 7 = Create Button & Execute Dialog |
Status | 0 | Select | SortingLevel | |
| Notes | String | 500 | Memo | Notes | ||
| Last Update | FixDT | 0 | Edit | Read Only | LastUpdate | |
| Updated By | String | 40 | Edit | Read Only | UpdatedBy | |
| Last Node ID | Integer | 0 | Edit | Hidden Read Only |
LastNodeId | |
| Enable Data Export for Groups | String | 500 | GroupSelect | EnableDataExportForGroups |
Database Table "hyp_Report Title"
Table Description
The report definition and general information.Normal Storage |
Archive Storage |
Deleted Storage(Recycle) |
| Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
|---|---|---|---|---|---|---|
| Report ID | Integer | 0 | Edit | Hidden Read Only Key Field |
ReportId | |
| Report Name | String | 50 | Edit | Mandatory | ReportName | |
| Notes for the Final User | String | 120 | Edit | NotesForTheFinalUser | ||
| Report Type | Values List: 0 = Records List by a Primary Table1 = Periodical Report |
Status | 0 | Select | ReportType | |
| Periodical Report Division | Values List: 0 = Daily1 = Weekly 2 = Monthly 3 = Bimonthly 4 = Quarterly 5 = Tertiary 6 = Yearly 7 = Without Division |
Status | 0 | Select | PeriodicalReportDivision | |
| Authorized Groups | String | 500 | PopupList | AuthorizedGroups | ||
| Authorized Users | String | 500 | PopupList | AuthorizedUsers | ||
| Last Update | FixDT | 0 | Edit | Read Only | LastUpdate | |
| Updated By | String | 40 | Edit | Read Only | UpdatedBy | |
| Paper Format | Values List: 0 = A4 Portrait (197mm)1 = A4 Landscape (284mm) 2 = Centered Envelope (Landscape) |
Status | 0 | Select | PaperFormat | |
| Print with Logos | Bool | 0 | Select | PrintWithLogos | ||
| Periodical Report Auto Dates Function | Values List: 0 = null, Empty1 = Today 2 = Start of the Week 3 = Start of the Month 4 = Start of the Year 5 = Start of Last Month 6 = Start of Last Dual-Month 7 = Start of Last Quarter |
Status | 0 | Select | PeriodicalReportAutoDatesFunction | |
| Envelope Left Margin | Integer | 0 | Edit | EnvelopeLeftMargin | ||
| Envelope Top Margin | Integer | 0 | Edit | EnvelopeTopMargin | ||
| Envelope Right Margin | Integer | 0 | Edit | EnvelopeRightMargin | ||
| Envelope Bottom Margin | Integer | 0 | Edit | EnvelopeBottomMargin | ||
| Icon | String | 30 | PopupList | Icon | ||
| Switch to Translation File | String | 60 | Select | SwitchToTranslationFile |