Compare commits
5
Commits
| Author | SHA1 | Date | |
|---|---|---|---|
|
|
7721bf4c15 | ||
|
|
428e8e7fa1 | ||
|
|
c7bbdee3c6 | ||
|
|
86eab571c0 | ||
|
|
bd736bc91c |
No files matched your search
@@ -49,7 +49,9 @@ The Download button gives several options for obtaining the current view of data
|
||||
|
||||
Note - if the table is registered in Data Controller as being TXTEMPORAL (SCD2) then the download option will prefilter for the _current_ records and removes the valid from / valid to variables. This makes the CSV suitable for DC file upload, if desired.
|
||||
|
||||
Note that all the above items are exported from backend. There is also a _frontend_ context menu that can be used in the VIEW screen (right click menu) for quick export into CSV or Excel formats.
|
||||
Note that all the above items are exported from backend. There is also a _frontend_ context menu that can be used in the VIEW screen (right click menu) for quick export into CSV, Excel and PDF formats. These frontend exports are "what you see": they cover the grid as it is displayed (the current selection if you have one, otherwise the whole table, with hidden columns omitted), so they honour your on-screen filters and labels but are not a substitute for the backend download when you need the full table.
|
||||
|
||||
The PDF option produces a paginated A4 landscape document with the column headers repeated on every page. It is limited to the first 5,000 rows, uses a monospace font, and covers Western European characters only - anything outside that character set is shown as `?`. For a typeset report with your company branding, use the backend download instead.
|
||||
|
||||
### Web Query URL
|
||||
|
||||
|
||||
Binary file not shown.
|
Before Width: | Height: | Size: 151 KiB After Width: | Height: | Size: 184 KiB |
Binary file not shown.
|
Before Width: | Height: | Size: 81 KiB After Width: | Height: | Size: 163 KiB |
Binary file not shown.
|
Before Width: | Height: | Size: 74 KiB |
@@ -73,7 +73,7 @@ Repeat the parameter to add mappings. A report with two tabs, each holding its
|
||||
| Tab 1 | `...?embed=va&va_parmap=REGION_TAB1-REGION` |
|
||||
| Tab 2 | `...?embed=va&va_parmap=REGION_TAB2-REGION` |
|
||||
|
||||
The applied filter is visible in the editor, above the grid - here the parameter `DROPDOWN_TAB1` filtering `SOME_DROPDOWN`, which is not its name:
|
||||
The applied filter is visible in the editor, above the grid - here the parameter `DROPDOWN_TAB1` filtering `SOME_DROPDOWN`, which is not its name (the date parameter beside it is name-matched, which is the default):
|
||||
|
||||

|
||||
|
||||
@@ -120,11 +120,7 @@ A mapping can resolve the parameter value through a **named date anchor** before
|
||||
https://yourserver/DC/#/editor/<library>/<table>?embed=va&va_parmap=SELECTED_DATE-D_DATE:ADD(QUARTER_START,-1)
|
||||
```
|
||||
|
||||
A report that sends `SELECTED_DATE = 27FEB1961` then filters `D_DATE` on 1961-02-27 **and** 1960-10-01 - the selected date, plus the same point one quarter earlier:
|
||||
|
||||
In the screenshot below the mapping is `SELECTED_DATE-SOME_DATE:ADD(QUARTER_START,-1)` against the demo table, and the parameter sends 27FEB1961:
|
||||
|
||||

|
||||
A report that sends `SELECTED_DATE = 27FEB1961` then filters `D_DATE` on 1961-02-27 **and** 1960-10-01 - the selected date, plus the same point one quarter earlier.
|
||||
|
||||
The clause carries both values, so the row for the selected date and the row for the previous quarter are both included.
|
||||
|
||||
|
||||
Reference in new issue
Block a user