Interface TableSQL

technical object description

interface TableSQL {
    contextObj: string;
    filterTo?: string;
    module: string;
    relations?: iobjRelation[];
    table?: string;
    userRelations?: iobjUserRelations[];
}

Properties

contextObj filterTo? module relations? table? userRelations?

Properties

contextObj

contextObj: string

Optional select used to load context object for views that requires the object and does not have it from parent Used by views that expect contex but are called contextless - without sufficient information

Example

view opened from clip without neccessary data

Optional filterTo

filterTo?: string

Definition of object search string used in the tables that has relation to field using the link type if defined it is used for filtering the field in the forem in ( ) if not defined filer field should be defined for field in the relatef object definition

Important note: Field values are loaded for all object during login. They are exstracted from the json. In case of change module should be reloaded to the system.

Recommendations:

  • test the selection in the filter field before changing default settings
  • do not forget that it could be used from another module as welllll
  • do not forget on the collation problems. See sysUser json for examples how to make it safe for external databases

module

module: string

Optional relations

relations?: iobjRelation[]

Optional table

table?: string

Optional userRelations

userRelations?: iobjUserRelations[]

Settings

Member Visibility

Theme

On This Page

contextObjfilterTomodulerelationstableuserRelations