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

Reply via email to