Hi, we came across a question on RIAK's querying ability thru JAVA client. For example, I have the below JSON record in a RIAK bucket. I need the individual counts of 'tasks' across different 'statuses'. Like for the below JSON record, it would be...
- Completed Tasks - 3, InProgress Tasks - 2 and OnHold Tasks -1 What is best way to retrieve this information in Java from RIAK ? { "csOutageID" : "110022", "outageType" : "Value Pack", "equipmentSerialNumber" : "297912", "siteName" : "Zhejiang Fuel Gas Power Gen Ltd.", "technicalCode" : "HD Gas", "contractNumber" : "CS21753", "taskCategory" : [{ "taskCategoryId" : "1", "taskCategoryName" : "TIL", "taskList" : [{ "taskTaskID" : "1000", "taskTitle" : "ML 0434 HYDRAULIC SYSTEM SETTING OF THE ACCUMULATOR REFILL RATE", "taskStatus" : "Complete", }, { "taskTaskID" : "1001", "taskTitle" : "MLI 0104 - HOSE, CHARGING, ACCUMULATOR", "taskStatus" : "OnHold", }] }, { "taskCategoryId" : "2", "taskCategoryName" : "HOTLIST", "taskList" : [{ "taskTaskID" : "1002", "taskTitle" : "TEMPERATURE REGULATION VALVES CONTAINING METHYLENE CHLORIDE", "taskStatus" : "InProgress", }, { "taskTaskID" : "1003", "taskTitle" : "MSDS Methylene Chloride to be added in O&M", "taskStatus" : "Complete", }] }, { "taskCategoryId" : "2", "taskCategoryName" : "HOTLIST", "taskList" : [{ "taskTaskID" : "1004", "taskTitle" : "MIXING RECOMMENDATIONS FOR SERIES CELLS IN LS2100 AND INNOVATION SERIES STATIC STARTERS", "taskStatus" : "InProgress", }, { "taskTaskID" : "1005", "taskTitle" : "BUCKET LOCKWIRE REDESIGN AND DOWEL PIN ASSEMBLY AND INSPECTION PROCEDURES", "taskStatus" : "Complete", }] }] } Thanks & regards, Prem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Disclaimer~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Information contained and transmitted by this e-mail is confidential and proprietary to iGATE and its affiliates and is intended for use only by the recipient. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, copying or use of this e-mail is strictly prohibited and you are requested to delete this e-mail immediately and notify the originator or mailad...@igate.com <mailto:mailad...@igate.com>. iGATE does not enter into any agreement with any party by e-mail. Any views expressed by an individual do not necessarily reflect the view of iGATE. iGATE is not responsible for the consequences of any actions taken on the basis of information provided, through this email. The contents of an attachment to this e-mail may contain software viruses, which could damage your own computer system. While iGATE has taken every reasonable precaution to minimise this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should carry out your own virus checks before opening an attachment. To know more about iGATE please visit www.igate.com <http://www.igate.com>. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
_______________________________________________ riak-users mailing list riak-users@lists.basho.com http://lists.basho.com/mailman/listinfo/riak-users_lists.basho.com