Summary
dvd means Dynamic View Dependencies, This topic will show all the method to use this function and all the oob exist examples.
Question
Syntax select(return_field, file_name, select_field, select_field_value, select_field_2, select_field_value_2)
Descption of online help:
This function works against many records to grab a scalar value from each one to make a list.
You can use it to select just one record and use an array from within that record (for example, the cap.exec array field of the operator table) to make a display list.
This function returns the value of a field (return_filed) of a record that is from a table (file_name) and has a field (select_field) value equal to a specified value (select_field_value).
The select_field_value can be a variable or a wildcard character (an asterisk). Both select_field_2 and select_field_value_2 are optional.
Answer
image text
Examples；
• select( "cap.exec", "operator", "name", [$operator] )
search in operator table with query: name=$operator, and return the vaule of operator`s cap.exec field value.
• select( "contract.id", "servicecontract", "provider", [customer] )
search in servicecontract table with query: provider=customer in $L.file
• select( "device.name", "devtype","active" ,true )
search in devtpe table with query: active=true
• select( "name", "assignment", "name", "*" )
show all the assignment table record's name value.
• select("name","dbdict",true,true)
show all dbdict recors
• Complex query:select("company","company","company.full.name","[print.open.format]","show.company","N")
select company.full.name=print.open.format and show.company="N" from company table, then show record's company field value.
All the OOB DVD select expressions:
SM ALL DVD Queris