Just moved from v8.20 to v9sr4 and so using set analysis for the first time.
A very odd thing is occuring. When using a client to reload my document I get one result, but then when I view the same document (and its not a caching issue) through the server via plugin I get a different result.
My data model is that sales employees ('Name') are linked to a despatch file on a unique key (so one employee to many despatches). The despatch file has an associated depot number and what I am trying to do is return the number of despatches for the selected (only one) sales employee and for the depot as a whole, so I can show 'raised x of total y'. Heres the thing though, some despatches will have been created by the system automatically and so not match to any employee (but still associated with a depot). I thought the '{1...' below would cope with that.
With the client I get the number returned in a chart as that for the whole depot (including those created by the system) but with the plugin I get the number for just those for the depot but where there is a link to the employee table (ie automatically created despatches are not counted).
The code is designed to get the 'Ordering Depot' for the currently selected employee and use that value as a filter on ALL the data, then count 'Date Created' (which is a column unique to the despatches table).
My issue was actually caused by poor design where 'section access' when being applied (in other words when going back into the document using the windows client or by accessing the document through server/plugin).
If you use 'section access' try commenting it all out (and turning off reduction in the deocument properties), reload the document and try again.
