Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.
We used the example db RealEstateand used XQuery followinghttp://localhost/tamino/welcome3_1_1_4/RealEstate?_xql=count(/Property[Address/State=‘CA’])the last doc of the results has <ino:cursor ino:count=“8”>then we usedhttp://localhost/tamino/welcome3_1_1_4/RealEstate?_xql(1,2)=/Property[Address/State=‘CA’]the last doc of the results has <ino:cursor ino:count=“15”>then we usedhttp://localhost/tamino/welcome3_1_1_4/RealEstate?_xql(5,2)=/Property[Address/State=‘CA’]the last doc of the results has <ino:cursor ino:count=“10”>then we usedhttp://localhost/tamino/welcome3_1_1_4/RealEstate?_xql(1,2)=/Property sortby(Address/State)the results were all the docs in the dbwhy the number of the results is different?please help us,best regards,Michael
Hi]http://localhost/tamino/welcome3_1_1_4/RealEstate?_xql=count(/Property[Address/State=‘CA’])Here you got what you wanted. 8 is precise number of documents with Address/State=‘CA’]http://localhost/tamino/welcome3_1_1_4/RealEstate?_xql(5,2)=/Property[Address/State=‘CA’]ino:count attribute doesn’t always give precise results. To make it work in your example define index on Address/State element and you’ll get 8 again.This problem has already been discussed in this forum. Checkhttp://tamino.forums.softwareag.com/viewtopic.php?p=7333for more information]http://localhost/tamino/welcome3_1_1_4/RealEstate?_xql(5,2)=/Property[Address/State=‘CA’]the same answer herehttp://localhost/tamino/welcome3_1_1_4/RealEstate?_xql(1,2)=/Property sortby(Address/State)this seems to be fine