I’m trying to create a baq where it shows the status icons of the parts on a job. When I run the baq it only returns some of the data from the fields. Not sure what the problem is with the baq, need some help coming to a solution.
That field doesn’t always have a value it it. It’s returning a null, which is what’s in the database.
On the job this specific part says complete, but null within the baq. Do I need to add another field in order to see this within the baq?
I would bet that this field is calculated on the fly. It doesn’t look like what’s showing there, and what’s in the database is kept in sync. My guess is that someone thought it would be a good idea to have that in the database, but then when it has to do with availability, there are too many factors in place to be able to keep it in sync reliably. So they just calculate it when the job is loaded.
I have personally never tried to use that particular field. Instead, I normally have calculated my own status based on several factors… the Issued Complete field, the due date of the material, whether we have over/under issued the quantity… it seems like there are many ways to define “status” that are different people want to see.
Okay that makes sense. Thank you for the help 