#

# LogiView

## Command 'where_ent2'

| For catenated Insert instructions ('insert_ref', 'where_ent', 'where_ent2', 'execute') this command specifies the record of the second entity for the relational list. For this purpose a virtual widget is generated for the second entity of the relational list and the corresponding record is selected by means of the forwarded Where clause.
| This command must not be called with a conditional instruction. In contrast to the syntax for the 'where' command, the logical operator '|' (OR) must only be used in order to link Where clauses within a single field! If the command is not forwarded a parameter, - where_ent2() - no record is selected in the second entity. In this case also a new record is created in the second entity in addition to the record in the relational list!
| ### Syntax:
| where_ent2({WHERE| } )
| ### I/O parameters:
| {WHERE} | Where clause followed by the selection of the record in the list mask for the second entity.
| - |
| ### Return value:
| - |
| ### Example:
| Declaration of Variables
     10 insert_ref("GROUP USER ASSIGNMENT")
     20 var(EP_GRP_USR_ACC,EP_GRP_USR_DEF)
     30 where_ent("T_GROUP.C_NAME" = EP_GROUP_NAME)
     40 where_ent2("T_USER.C_NAME" = EP_USER_NAME)
     50 DOCU_INT_1 = execute(1)
| Functions and commands: DB/Mask Interface