Queries | 4D Docs

📄️ DESCRIBE QUERY EXECUTION

DESCRIBE QUERY EXECUTION ( statut )

Find in field ( champCible ; valeur ) : Integer

GET QUERY DESTINATION ( destinationType ; destinationObjet ; destinationPtr )

Get query limit : Integer

Last query path ( formatDesc ) : Text

Last query plan ( formatDesc ) : Text

ORDER BY ( {laTable ;}{ leChamp }{; > ou ou ou <N}{; *} )

ORDER BY ATTRIBUTE ( {laTable ;} champObjet ; cheminAttribut ; > ou ou ou <N} {; *} )

ORDER BY FORMULA ( laTable ; formule {; > ou ou ou <N} )

QUERY ( {laTable }{;}{ critère {; *}} )

QUERY BY ATTRIBUTE ( {;}{opConj ;} champObjet ; cheminAttribut ; opRech ; valeur {; *} )

QUERY BY EXAMPLE ( {;}{*} )

QUERY BY FORMULA ( laTable {; formule} )

QUERY SELECTION ( {laTable }{;}{ critère {; *}} )

QUERY SELECTION BY ATTRIBUTE ( {;}{opConj ;} champObjet ; cheminAttribut ; opRecherche ; valeur {; *} )

QUERY SELECTION BY FORMULA ( laTable {; formule} )

QUERY SELECTION WITH ARRAY ( champCible ; tableau )

QUERY WITH ARRAY ( champCible ; tableau )

SET QUERY AND LOCK ( verrou )

SET QUERY DESTINATION ( destinationType {; destinationObjet {; destinationPtr}} )

SET QUERY LIMIT ( limite )