Nextlevel-Icon

    Helfen Sie uns ein Level weiter. Nehmen Sie an unserer Umfrage teil.

    NextTables URL Parameters

    At some points the NextTables URL can be modified to achieve different results, like enabling a fullscreen mode for tables or adding filters via the URL. 

    URL changes for fullscreen display 

    Available from NextTables version 8

    With small changes to the URL, it is possible to create a fullscreen table view. In this view, the menu is disabled and the user can’t navigate to a different table. This feature comes in handy, if NextTables should be integrated into different applications, like a dashboard. 

    URL structure 

    https://{yourdomain}/#/{table_display_type}/{table}/{table_type}/

    Possible table display types

    The menu entry can be configured as a table or import view in the wizard. Both of these views can be changed into a full screen view.

    Table Display Type

    Result

    tables

    Standard option with visible table and side menu

    table

    The table is visible, but the menu is hidden. The user can't navigate to a different table.

    imports

    Only the upload dialogue is shown. The user can’t see the underlying table. The side menu is visible.

    import

    Only the upload dialog is shown. The user can’t see the underlying table, nor the side menu. The user can’t navigate to a different table.



    Add filters to URL 

    Available from NextTables version 9

    Filters can be added to the NextTables URL to open a specific table with a preset of global filters.This feature creates the opportunity to jump from external applications (like a dashboard) with chosen filters, directly to the table without re-adjusting the filters. 

    General rules

    • It is possible to add multiple filters to one NextTables URL
    • If the NextTables URL contains a template, the filters will be added on top and will not be overwritten
    • If the NextTables URL contains a template with a variable and a filter value for the same field, the variable will be overwritten
    • All existing and added filters are shown in the global filter and can be changed

     

    URL Structure with filters

    https://{yourdomain}/#/{table_display_type}/{table}/{table_type}/{template_id?}?filter={filter_expression};{filter_expression};....

    • Parameter to add Filters: ?filter= 
    • The fieldname is always the technical name
    • The URL can be created with blank characters (space) within the filter expression, the browser will convert the “space” into “%20”



    Filter expression

    Operator

    {fieldName} {operator} '{value}'

    eq, ne, gt, lt, cp, np

    {fieldName} {operator} ('{value1},{value2}')

    bt, nb

    {fieldName} {operator}

    null, notnull

    {fieldName} {operator} ('{value1}','{value2}')

    in, nin

     

    Operators

    Operator

    Description

    eq

    equal

    ne

    not equal

    gt

    greater than

    lt

    lower than

    cp

    contains pattern

    np

    does not contain pattern

    bt

    between

    nb

    not between

    in

    equal (multiple values)

    nin

    not equal (multiple values)

    null

    is null

    notnull

    is not null

     

    Examples:

    • Add 2 filter values for one field

    https://{yourdomain}/#/tables/MY_ADSO/DSO/?filter=CALYEAR eq '2020';CALYEAR eq '2021'

    • Add 2 filter values for different fields

    https://{yourdomain}/#/tables/MY_ADSO/DSO/?filter=CALYEAR eq '2020';/BIC/PROD_ID eq '9001'

    • Add filter for between

    https://{yourdomain}/#/tables/MY_ADSO/DSO/?filter=CALMONTH2 bt (‘4’,’9’)

    • Add filter for notnull

    https://{yourdomain}/#/tables/MY_ADSO/DSO/MYTEMPLATE001/?filter=/BIC/ACT_FLAG notnull

    • Add filter for in

    https://{yourdomain}/#/tables/MY_ADSO/DSO/MYTEMPLATE001/?filter=CALYEAR in '2018,2019'




    Which License is needed for this feature Professional  | Enterprise


    NextTables Technical Documentation

    Do you have a question regarding NextTables?
    Already a customer? Please click here for Support.