summaryrefslogtreecommitdiff
path: root/docs/topics/db/queries.txt
AgeCommit message (Collapse)Author
2025-11-21Fixed #36718 -- Added JSONField support for negative array indexing on ↵Clifford Gama
Oracle 21c+.
2025-11-17Fixed #26379 -- Doc'd that the first filter() on a many-to-many relation is ↵Annabelle Wiegart
sticky.
2025-10-29Refs #35381 -- Deprecated using None in JSONExact rhs to mean JSON null.Clifford Gama
Key and index lookups are exempt from the deprecation. Co-authored-by: Jacob Walls <jacobtylerwalls@gmail.com>
2025-10-29Fixed #35381 -- Added JSONNull() expression.Clifford Gama
Thanks Jacob Walls for the review.
2025-10-29Fixed #36329 -- Removed non-code custom link text when cross-referencing ↵Clifford Gama
Python objects. Thanks Bruno Alla, Sarah Boyce, and Jacob Walls for reviews. Co-authored-by: Sarah Boyce <42296566+sarahboyce@users.noreply.github.com>
2025-10-16Fixed #28586 -- Added model field fetch modes.Adam Johnson
May your database queries be much reduced with minimal effort. co-authored-by: Andreas Pelme <andreas@pelme.se> co-authored-by: Simon Charette <charette.s@gmail.com> co-authored-by: Jacob Walls <jacobtylerwalls@gmail.com>
2025-10-16Refs #28586 -- Edited related objects documentation.Adam Johnson
This change aims to make this section clearer and ready to add a description of fetch modes.
2025-08-28Fixed #36570 -- Removed unnecessary :py domain from documentation roles.SaJH
Signed-off-by: SaJH <wogur981208@gmail.com>
2025-08-25Refs #36485 -- Rewrapped docs to 79 columns line length.David Smith
Lines in the docs files were manually adjusted to conform to the 79 columns limit per line (plus newline), improving readability and consistency across the content.
2025-08-25Refs #36485 -- Removed double spaces after periods in sentences.Natalia
2025-08-25Refs #36485 -- Removed unnecessary parentheses in :meth: and :func: roles in ↵David Smith
docs.
2025-06-13Corrected jsonfield fieldlookup references.Sarah Boyce
2025-05-16Fixed #33312 -- Raised explicit exception when copying deferred model instances.Simon Charette
Previously save() would crash with an attempted forced update message, and both save(force_insert=True) and bulk_create() would crash with DoesNotExist errors trying to retrieve rows with an empty primary key (id IS NULL). Implementing deferred field model instance copying might be doable in certain cases (e.g. when all the deferred fields are db generated) but that's not trivial to implement in a backward compatible way. Thanks Adam Sołtysik for the report and test and Clifford for the review.
2025-05-14Fixed #36085 -- Added JSONField support for negative array indexing on SQLite.savanto
2025-03-18Fixed #36202 -- Added examples of JSONField __contains and __contained_by ↵Clifford Gama
lookups with nested arrays to docs.
2025-03-13Fixed incorrect formatting for inline pluralized code references in docs.Clifford Gama
2025-03-12Fixed #36249 -- Fixed typo in docs/topics/db/queries.txt.hesham hatem
2024-10-09Refs #35502 -- Clarified models.py file path in docs/topics/db/queries.txt.Natalia
2023-10-25Added missing pycon directives in various docs.Mariusz Felisiak
2023-09-18Refs #33308 -- Removed support for passing encoded JSON string literals to ↵Mariusz Felisiak
JSONField & co. Per deprecation timeline.
2023-09-18Removed versionadded/changed annotations for 4.2.Mariusz Felisiak
This also removes remaining versionadded/changed annotations for older versions.
2023-06-07Fixed #30355 -- Doc'd interaction between custom managers and ↵Akash Kumar Sen
prefetch_related().
2023-04-06Fixed #34463 -- Corrected code-block directives in docs.Yahya Ali
Thanks ExTexan for the report.
2023-03-01Fixed #34140 -- Reformatted code blocks in docs with blacken-docs.django-bot
2023-02-28Refs #34140 -- Corrected rst code-block and various formatting issues in docs.Joseph Victor Zammit
2023-02-10Refs #34140 -- Applied rst code-block to non-Python examples.Carlton Gibson
Thanks to J.V. Zammit, Paolo Melchiorre, and Mariusz Felisiak for reviews.
2023-01-17Removed versionadded/changed annotations for 4.1.Mariusz Felisiak
2022-12-01Refs #33308 -- Deprecated support for passing encoded JSON string literals ↵Simon Charette
to JSONField & co. JSON should be provided as literal Python objects an not in their encoded string literal forms.
2022-09-16Fixed #33966 -- Added support for using KeyTextTransform from lookup.Allen Jonathan David
2022-08-30Fixed #33958 -- Added imports to examples in "Expressions can reference ↵Iván Camilo Triviño López
transforms" section.
2022-07-26Fixed #33820 -- Doc'd "true"/"false"/"null" caveat for JSONField key ↵Mariusz Felisiak
transforms on SQLite. Thanks Johnny Metz for the report. Regression in 71ec102b01fcc85acae3819426a4e02ef423b0fa.
2022-05-18Refs #33646 -- Fixed link markup in queries topic doc.Simon Willison
2022-04-28Removed hyphen from pre-/re- prefixes.David
"prepopulate", "preload", and "preprocessing" are already in the spelling_wordlist. This also removes hyphen from double "e" combinations with "pre" and "re", e.g. preexisting, preempt, reestablish, or reenter. See also: - https://ahdictionary.com/word/search.html?q=rerun - https://ahdictionary.com/word/search.html?q=recreate - https://ahdictionary.com/word/search.html?q=predetermined - https://ahdictionary.com/word/search.html?q=reuse - https://ahdictionary.com/word/search.html?q=reopening
2022-04-26Fixed #33646 -- Added async-compatible interface to QuerySet.Andrew Godwin
Thanks Simon Charette for reviews. Co-authored-by: Carlton Gibson <carlton.gibson@noumenal.es> Co-authored-by: Mariusz Felisiak <felisiak.mariusz@gmail.com>
2022-03-04Fixed #29865 -- Added logical XOR support for Q() and querysets.Ryan Heard
2022-02-22Removed redundant QuerySet.all() calls in docs and tests.Nick Pope
Most QuerySet methods are mapped onto the Manager and, in general, it isn't necessary to call .all() on the manager.
2021-12-30Fixed #27936 -- Rewrote spanning multi-valued relationships docs.Jacob Walls
2021-12-30Added default values to Entry's fields in making queries docs.Mariusz Felisiak
This makes it easier to create a data in examples.
2021-12-15Fixed #16063 -- Adjusted admin changelist searches spanning multi-valued ↵Jacob Walls
relationships. This reduces the likelihood of admin searches issuing queries with excessive joins.
2021-09-20Removed versionadded/changed annotations for 3.2.Mariusz Felisiak
2021-07-29Fixed 32956 -- Lowercased spelling of "web" and "web framework" where ↵David Smith
appropriate.
2021-02-22Refs #4027 -- Added Model._state.adding to docs about copying model instances.Johannes Wilm
2021-01-19Corrected versionadded annotations.Mariusz Felisiak
2021-01-14Removed versionadded/changed annotations for 3.1.Mariusz Felisiak
2020-12-15Added backticks to code literals in various docs.Jon Dufresne
2020-11-27Fixed #25534, Fixed #31639 -- Added support for transform references in ↵Ian Foote
expressions. Thanks Mariusz Felisiak and Simon Charette for reviews.
2020-11-12Fixed #32187 -- Removed unnecessary select_related in queries doc.Hasan Ramezani
2020-09-04Fixed #31894 -- Added note about using JSONField key lookups with ↵jpribyl
QuerySet.exclude() in docs.
2020-07-28Fixed #31829 -- Used JSONField __contains lookup on key transforms.sage
2020-07-28Fixed #31836 -- Dropped support for JSONField __contains and __contained_by ↵Mariusz Felisiak
lookups on SQLite. The current implementation works only for basic examples without supporting nested structures and doesn't follow "the general principle that the contained object must match the containing object as to structure and data contents, possibly after discarding some non-matching array elements or object key/value pairs from the containing object".
generated by cgit v1.3 (git 2.53.0) at 2026-07-05 10:20:17 +0000