I am creating reports in my MySQL backend. I have created a database view that only displays the fields I need: id, Position, Fault_Count. Postion and Fault_Count are modified field names from the Select statement. Django isn't liking this too much and keeps throwing an Operational Error (1054). Unknown Columns.
How do I need to set up my model to display the modified fields: Fault_count doesn't exist in the original table because it's calculated and Position is a modified name of another field that also has some parameters set to it to find a character position.
Any ideas of what Django is expecting?
Thanks!