How to Extract values from bin


#1

Hi,

I have a properties bin in my Aerospike DB and on doing a select, i get the following output - aql> select properties from dsclocal.TPASystem ±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | properties | ±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | LIST(’[{“name”:“Sy OCS Realm”, “value”:"", “attribute”:1}, {“name”:“Non-Managed Delivery Retry Frequency (secs)”, “application”:“Notification Server”, “value”:“10”, “attribute”:1}, {“name”:“Managed Delivery Retry Count”, “application”:"Notification Serve | ±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.072 secs)

Is there a way to fetch the value(10) of “Non-Managed Delivery Retry Frequency (secs)” record present in the properties bin?

Something like - select from properties where name=“Non-Managed Delivery Retry Frequency (secs)” ??

~Mayank