• Log In

Home > Web > Front-end > Javascript

Category: Javascript

Q: Javascript extract rows with conditions from a JSON

I have a json that generated from a cakephp api, like:

[
  {
    "_id": "57fcaf7173e3f772d54e991f",
    "isActive": true,
    "balance": "2,095.68",
    "name": "**",
    "email": "**"
  },
  {
    "_id": "57fcaf71862f790be6b77779",
    "isActive": true,
    "balance": "1,740.58",
    "name": "**",
    "email": "**"
  },
  {
    "_id": "57fcaf710b2de8d441493d7e",
    "isActive": true,
    "balance": "1,089.43",
    "name": "**",
    "email": "**"
  },
  {
    "_id": "57fcaf71c61614eef67cf695",
    "isActive": true,
    "balance": "2,593.69",
    "name": "**",
    "email": "**"
  },
  {
    "_id": "57fcaf717bd76378041dbfc6",
    "isActive": false,
    "balance": "1,035.51",
    "name": "**",
    "email": "**"
  },
  {
    "_id": "57fcaf719b950431be9548a4",
    "isActive": true,
    "balance": "2,223.25",
    "name": "**",
    "email": "**"
  }
]

And I want to extract data rows with conditions "isActive:true" and "balance > 1000" from this json, and I do not like to call another api to do this. Is there a "javascript" way to extract users? many thanks to you guys.

json extract
0 Answers
1140 edited   
...loading comments

No answers yet!

The community needs your help!

Post your Answer

Created: 11 Oct '16

Last Reply: None

Replies: 0

Views: 1140

Votes: 0

Further Reading

Q: How to implement the built-in mobile detect in Cakephp 3?

Q: Using cakephp/elastic-search with pagination

Q: Cakephp use query builder in component

Q: Cakephp generating mongodb-liked objectId (based on time, machine, pid, and counter)?

Q: Table::get($name)->hasAny(['key' => 'value'] is not working in cakephp 3

Q: CakePHP and Phantom.js

Q: In CakePHP 3, identify and remove duplicate records of customers

Q: Can't get query strings from URL

Q: cakephp-queue having DB connection error with migrations migrate

Q: In CakePHP 3, Nginx 500 internal server error

Welcome to Aero Coding!

Aero Coding is a CakePHP-focused Q&A community for professional and enthusiast cake bakers. It's built and run by you as part of the community.


Join Now Tour

Download Cakephp

Start baking your own CakePHP application!


Cakephp All Versions
PHP  CakePHP   General Discussion   Installation   Configuration   Routing   Middleware   Controllers   Models & ORM   Views   Authentication   Bake Console   Caching   Shells, Tasks & Console Tools   Debugging   Deployment   Email   Error & Exception Handling   Events System   Localization   Logging   Modelless Forms   Pagination   Plugins   REST   Security   Sessions   Testing   Validation   Utility Classes   Other Web  Front-end   HTML   CSS   Javascript  Architecture   Server Aero Coding  All Topics   Site Feedback