Hi everyone,
I’m trying to work out why queries with same conditions are returning different results depending on selected columns:
select sys_contentid from rx:generalpage shows as a result all the existing items no matter what the item states are (draft,public…) but returning only once each item (the last revision).
On the other hand the query select sys_contentid,rx:body from rx:generalpage shows as a result all the revisions of the item with different values in the field body.
Looks like JSR is including only the versions in the results if the searched fields are containing different values (because items with same value on the body field are being returned only once).
Thanks in advance, Javier.