Queries | 4D Docs

📄️ DESCRIBE QUERY EXECUTION

DESCRIBE QUERY EXECUTION ( estado )

Find in field ( campoObjetivo ; valor ) : Integer

GET QUERY DESTINATION ( destinoTipo ; destinoObjeto ; destinoPunt )

Get query limit : Integer

Last query path ( formatDesc ) : Text

Last query plan ( formatDesc ) : Text

ORDER BY ( {tabla ;}{ unCampo }{; > o o o <N}{; *} )

ORDER BY ATTRIBUTE ( {tabla ;} campoObjeto ; rutaAtrib ; > o o o <N} {; *} )

ORDER BY FORMULA ( tabla ; formula {; > o o o <N} )

QUERY ( {tabla }{;}{ criterioBusqueda {; *}} )

QUERY BY ATTRIBUTE ( {;}{opConj ;} campoObjeto ; rutaAtributo ; opBusq ; valor {; *} )

QUERY BY EXAMPLE ( {;}{*} )

QUERY BY FORMULA ( tabla {; formula} )

QUERY SELECTION ( {tabla }{;}{ criterioBusqueda {; *}} )

QUERY SELECTION BY ATTRIBUTE ( {;}{conjOp ;} campoObjeto ; rutaAtributo ; opBusq ; valor {; *} )

QUERY SELECTION BY FORMULA ( tabla {; formula} )

QUERY SELECTION WITH ARRAY ( campoObjetivo ; array )

QUERY WITH ARRAY ( campoObjetivo ; array )

SET QUERY AND LOCK ( bloq )

SET QUERY DESTINATION ( destinoTipo {; destinoObjeto {; destPunt}} )

SET QUERY LIMIT ( limite )