Hi Everyone,
I’ve applied sorting on PartNum and Part Description in the Customer Tracker. It works perfectly when using the Default Grid Filter, but as soon as I change the filter to All or any other option, the system throws an error.
Could anyone please help me understand what might be causing this?
I’ve attached screenshots for better clarity.
Thank you in advance for your support! 
Hi Abeer,
I was able to recreate your issue. I tested in both 2024.2 and 2025.2.
The issue is caused by the PartNum sort adding an invaild where clause on the OrderHed table.
The server will throw an exception because the PartNum field does not exist as a column in the OrderHed table.
Sadly, there’s nothing you can do, other than to avoid sorting on this column and reporting your issue to support.
FYI @bconner
Thanks @mbayley, I believe replacing the built-in grid with a custom one using a BAQ DataView would be a better approach in this case now.
