4D Language Commands QueriesVersion: 20 R9 QueriesDESCRIBE QUERY EXECUTION ( status ) Find in field ( targetField ; value ) : Integer GET QUERY DESTINATION ( destinationType ; destinationObject ; destinationPtr ) Get query limit : Integer Last query path ( descFormat ) : Text Last query plan ( descFormat ) : Text ORDER BY ( {aTable ;}{ aField }{;> or < }{; aField2 ;> or <2 ; ... ; aFieldN ;> or <N}{; *} ) ORDER BY ATTRIBUTE ( {aTable ;} objectField ; attributePath ;> or < {; objectField2 ; attributePath2 ;> or <2 ; ... ; objectFieldN ; attributePathN ;> or <N} {; *} ) ORDER BY FORMULA ( aTable ; formula {;> or <}{; formula2 ;> or <2 ; ... ; formulaN ;> or <N} ) QUERY ( {aTable }{;}{ queryArgument {; *}} ) QUERY BY ATTRIBUTE ( {aTable}{;}{conjOp ;} objectField ; attributePath ; queryOp ; value {; *} ) QUERY BY EXAMPLE ( {aTable}{;}{*} ) QUERY BY FORMULA ( aTable {; queryFormula} ) QUERY SELECTION ( {aTable }{;}{ queryArgument {; *}} ) QUERY SELECTION BY ATTRIBUTE ( {aTable}{;}{conjOp ;} objectField ; attributePath ; queryOp ; value {; *} ) QUERY SELECTION BY FORMULA ( aTable {; queryFormula} ) QUERY SELECTION WITH ARRAY ( targetField ; array ) QUERY WITH ARRAY ( targetField ; array ) SET QUERY AND LOCK ( lock ) SET QUERY DESTINATION ( destinationType {; destinationObject {; destinationPtr}} ) SET QUERY LIMIT ( limit )