如何从django orm获取字段值

Question

我正在试图得到一个联合表的字段值。这是ORM查询生成的sql。

SELECTsubnets_subnetoption.id, subnets_subnetoption.subnet_id,subnets_subnetoption.value_id, subnets_subnet.id,subnets_subnet.parent_id, subnets_subnet.base_address,subnets_subnet.bits, subnets_subnet.bcast_address,subnets_subnet.is_physical, subnets_subnet.name,subnets_subnet.responsible, subnets_subnet.building_floor,subnets_subnet.comments, subnets_subnet.vlan_common_name,subnets_subnet.creation_date, subnets_subnet.modification_date,subnets_subnet.sec_level, subnets_subnet.confid,subnets_subnet.access_type, subnets_subnet.zone_type,options_value.id, options_value.content,options_value.comment, options_value.option_id,options_option.id, options_option.name,options_option.required, options_option.scope_id,options_scope.id, options_scope.nameFROMsubnets_subnetoptionINNER JOIN subnets_subnetON (subnets_subnetoption.subnet_id= subnets_subnet.id) INNER JOINoptions_valueON (subnets_subnetoption.value_id=options_value.id) INNER JOIN options_optionON (options_value.option_id= options_option.id) INNER JOINoptions_scopeON (options_option.scope_id=options_scope.id) WHERE subnets_subnetoption.subnet_id` =1

   SubnetOption.objects.select_related().filter(subnet_id=subnet['id']).query

我只需要options_value.content和options_option.name，但是查询集我只提供子网选项表值。如何获得连接的表值。我是新来的django

Answer 1

 SubnetOption.objects.filter(subnet_id=subnet['id']).select_related().values('options_value__content')

或

SubnetOption.objects.filter(subnet_id=subnet['id']).select_related('modelname_in_wholelowercase')

试一次

Answer 2

您可以使用django的原始查询(这意味着您可以按原样放置SQL查询)作为参考。

Raw sql queries in Django views