How to set Default ordering in list api using @ordering decorator ??

[Elixir-MeetThoriya]

i has created_at field, i need to set default ordering = -created_at (latest first)
if I set ordering in quaryset , can't work (ninja-extra change the order)

 @http_get(
        path="",
        response={
            HTTPStatus.OK: PaginatedResponseSchema[CampaignSchema],
            HTTPStatus.INTERNAL_SERVER_ERROR: error_schema
        },
        summary="Campaign List",
        description="This endpoint retrieves a list of campaigns.",
        url_name="campaign_list"
    )
    @paginate()
    @ordering(Ordering, ordering_fields=['name'])
    @searching(Searching, search_fields=['name'])
    def list(self):
            records = self.model.objects.all().order_by("-created_at")
        return records

[eadwinCode]

@Elixir-MeetThoriya I will look into this

[eadwinCode]

@Elixir-MeetThoriya, the ordering fields are particularly in this ['-created_at', 'name']. Ordering by name happened first and ordering by name followed. So the result you see is actually correct

[ryanovas]

Is there a way to not have setting these fields apply an order to the results? I would just want them to be options to order by from the URL, not something that overrides my model ordering every time?

edit: I have a workaround for now:

Create this override Ordering class somewhere you prefer:

from ninja import Field
from ninja_extra.ordering import Ordering


class PreserveModelOrdering(Ordering):
	"""
	A custom Ordering class that does NOT apply any ordering
	if the 'ordering' query parameter is not provided, thus
	preserving the model's default Meta.ordering.
	"""

	def create_input(self, ordering_fields: list[str] | None) -> type[Ordering.Input]:
		# The only purpose of this override is to remove the P(default=...)
		# from the input schema field, making it truly optional.
		class DynamicInput(Ordering.Input):
			ordering: str | None = Field(None)

		return DynamicInput

then adjust settings.py:

NINJA_EXTRA = {
	'ORDERING_CLASS': 'core.base_api.PreserveModelOrdering',
}

Now you can specify orderable fields, but not override the model settings:

@route.get('/posts/', response=PaginatedResponseSchema[PostListSchema])
	@paginate
	@ordering(ordering_fields=['created', 'updated', 'title'])
	async def list_posts(self, filters: PostSearchSchema = Query(...)):
		posts = Post.objects.all()
		filtered_posts = filters.filter(posts).distinct()
		return filtered_posts