Quite strange, indeed. The last method gets information directly from db by querying it. So, the problem doesn't seem to be PS-specific.
This is a query that the said method utilizes. I couldn't imagine that something is wrong with it:
- Code: Select all
SELECT oijs.* FROM [dbo].[ObjectsInJobsView] oijs WHERE oijs.[job_id] = @row_job_id ORDER BY order_no ASC;
You can run it yourself or preferably let support team do that, check the results of its execution, and investigate why there is a discrepancy between two values, if the given query also returns wrong data.