#

# LogiView

## Selection (Using Virtual Widgets)

| Like with interactive working, it may be comfortable to be able to select records from list masks of an entity, relationship, or type without any knowledge of the underlying tables or their links. In order to allow this processing method, virtual widgets have been integrated into DataView. LogiView provides functions and commands that operate based on this method. When selecting records, you need to differentiate between records of a Master List, Aggregate Relation List, Refined Relation List, or Type List.
| In order to select data from a master list the following functions and commands are used: command 'select_ent' command 'var' command 'where' integer function 'execute'
| ### Example:
T | Ln | Cond/Act | R 01
A | 10 | select_ent("ORDER") | yes
A | 20 | var(PRICE[1],USER[1]) | yes
A | 30 | where("ORDER.ORD_NO"=ORDER) | yes
A | 40 | RC = execute(3) | yes
| In order to select data from an aggregate relation list the following functions and commands are used: command 'select_agg' command 'var' command 'where_ent' command 'where' integer function 'execute'
| ### Example:
T | Ln | Cond/Act | R 01
A | 10 | select_agg("ORDER ITEM SUPPLIER") | yes
A | 20 | var(I_NO) | yes
A | 30 | where_ent("ORDER.ORD_NR"=ORDER) | yes
A | 40 | where("ORD_ITM.QUANTITY">100) | yes
A | 50 | RC = execute(0) | yes
| In order to select data from an refine relation list the following functions and commands are used: command 'select_ref' command 'var' command 'where_ent' command 'where' integer function 'execute'
| ### Example:
T | Ln | Cond/Act | R 01
A | 10 | select_ref("ITEM ORDER CUSTOMER") | yes
A | 20 | var(S_PRICE,QUANTITY) | yes
A | 30 | where_ent("ITEM.ITM_NO"= "4711") | yes
A | 40 | where("ORDER.ORD_NO"=ORDER) | yes
A | 50 | RC = execute(1) | yes
| In order to select data from a type list the following functions and commands are used: command 'select_typ' command 'var' command 'where' integer function 'execute'
| ### Example:
T | Ln | Cond/Act | R 01
A | 10 | select_typ("ITEM DRAWING") | yes
A | 20 | var(FORMAT) | yes
A | 30 | where("ITEM.ITM_NO"="4711") | yes
A | 40 | RC = execute(1) | yes