Queries | 4D Docs

📄️ DESCRIBE QUERY EXECUTION

DESCRIBE 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 or or <N}{; *} )

ORDER BY ATTRIBUTE ( {aTable ;} objectField ; attributePath ; > or or or <N} {; *} )

ORDER BY FORMULA ( aTable ; formula {; > or or or <N} )

QUERY ( {aTable }{;}{ queryArgument {; *}} )

QUERY BY ATTRIBUTE ( {;}{conjOp ;} objectField ; attributePath ; queryOp ; value {; *} )

QUERY BY EXAMPLE ( {;}{*} )

QUERY BY FORMULA ( aTable {; queryFormula} )

QUERY SELECTION ( {aTable }{;}{ queryArgument {; *}} )

QUERY SELECTION BY ATTRIBUTE ( {;}{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 )