Django 管理：搜索外键对象而不是

发布于 2024-11-30 17:38:40 字数 517 浏览 1 评论 0原文

我的模型如下所示：

class Asset(models.Model):
    serial_number = models.CharField(max_length=100, unique=True)
    asset_tag = models.CharField(max_length=100, unique=True)

class WorkOrder(models.Model):
    asset = models.ForeignKey(Asset)

本质上，提交工作订单，然后管理员将资产分配给工作订单。 asset_tag 字段是我们可以扫描的条形码。在 Django 后台编辑工单时，默认情况下 asset 字段显示为 选择>小部件。我们想要做的是拥有一个搜索字段，以便我们可以扫描资产标签，然后在数据库中搜索正确的资产以与工作订单关联。

我知道您可以将 Django 管理外键自定义为硬编码查询，但我不知道如何获取它，因此它根据管理页面上的字段进行搜索。

原文

My model looks like this:

class Asset(models.Model):
    serial_number = models.CharField(max_length=100, unique=True)
    asset_tag = models.CharField(max_length=100, unique=True)

class WorkOrder(models.Model):
    asset = models.ForeignKey(Asset)

Essentially, a work order is submitted and then an admin assigns an asset to the work order. The asset_tag field is a barcode that we can scan in. When editing the work order in the Django admin, by default the asset field is displayed as a <select> widget. What we want to be able to do is have a search field so that we can scan the asset tag and then search for the right asset in the DB to associate with the work order.

I know you can customize the Django admin foreign key to a hard coded query, but I can't figure out how to get it so it does a search based on a field on the admin page.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

烟雨凡馨 2024-12-07 17:38:41

如果您使用 Django >= 2.0，您可以利用名为 autocomplete_fields。您必须在相关对象的 ModelAdmin 上定义 search_fields，因为自动完成搜索会使用它。

由于您与 WorkOrder 中的 Asset 存在 ForeignKey 关系，因此在应用的 admin.py 中添加以下内容：

from django.contrib import admin

@admin.register(Asset)
class AssetAdmin(admin.ModelAdmin):
    search_fields = ["serial_number", "asset_tag"]


@admin.register(WorkOrder)
class WorkOrderAdmin(admin.ModelAdmin):
    autocomplete_fields = ["asset"]

将要用于搜索的字段添加到 search_fields 中，并添加定义 autocomplete_fields 如上面的代码所示。

If you are using Django >= 2.0, you can take advantage of a feature called autocomplete_fields. You must define search_fields on the related object’s ModelAdmin because the autocomplete search uses it.

Since you have a ForeignKey relationship to Asset in WorkOrder, in the admin.py of your app add the following:

from django.contrib import admin

@admin.register(Asset)
class AssetAdmin(admin.ModelAdmin):
    search_fields = ["serial_number", "asset_tag"]


@admin.register(WorkOrder)
class WorkOrderAdmin(admin.ModelAdmin):
    autocomplete_fields = ["asset"]

Add the fields you want to use for searching to search_fields, and add define autocomplete_fields as shown in the code above.

回复收藏 0 原文