FieldError when sorting VMs list by primary IP

[jakubkrysl]

Environment

• Nautobot version (Docker tag too if applicable): 1.5.7
• Python version: 3.7.16
• Database platform, version:
• Middleware(s):

Steps to Reproduce

1. Sort VirtualMachines by primary IP column
   https://demo.nautobot.com/virtualization/virtual-machines/?sort=primary_ip

Expected Behavior

VMs sorted by primary IP

Observed Behavior

[david-kn]

It works for other model(s) e.g. devices though: https://demo.nautobot.com/dcim/devices/?sort=primary_ip
So it's some funny inner bug in relationships probably...

[glennmatthews]

Thanks for the report and for the context!

DeviceTable has primary_ip = tables.Column(linkify=True, order_by=("primary_ip6", "primary_ip4"), verbose_name="IP Address") while VirtualMachineDetailTable has just primary_ip = tables.Column(linkify=True, verbose_name="IP Address"). Probably adding the missing order_by to the latter would be sufficient to fix this.