I have a work orders table that has a field called “user_id” which is an integer. Work orders can be assigned to a user, but at points in time may not be assigned yet. I was trying to make a count to display how many unassigned work orders were in the system.
I created a global int variable and set the default value to " = null " in the global.js. I created the relationship from the global to work_orders → user_id so that it would show all records that user id was null. I setup a related tabpanel but no records show. I went and checked the database and it should have had 3 records. I removed an user from a work order and went back and the tab panel showed 4 records. I then reloaded the solution and once again it showed nothing. Removing a user again from another work order made 5 records show up.
Before I submitted a case I wanted to make sure that my logic was right. Would this be the right way to go about this?
Thanks!