CODEWITHSUNDEEP
postgresqlcakephpcakephp-3.3
Clarice Pereira
Clarice Pereira

Reputation: 11

cakePHP find() returns field name instead of just the column values

I'm trying to retrieve data from my database using the find() method.

But when I use find('all') it returns the column value and column name together, like this: { "date_1": "2015-25-12"}, of course, I want only the values from the column.

If I use find('list'), it comes back empty.

This is how I'm trying to retrieve my data:

$date1 = $this->Stocks->find('all', ['fields' => ['Stocks.date_1'], 'conditions' => ['Stocks.families_id' => $id]]);

This is my table:

CREATE TABLE stocks
(
  families_id integer,
  date_1 date NOT NULL,
  date_2 date,
  created timestamp without time zone,
  modified timestamp without time zone,
  id serial NOT NULL,
  CONSTRAINT stocks_pkey PRIMARY KEY (id)
)

Everything else is working fine, but this one part. I'm using PostgreSQL.

Upvotes: 1

Views: 631

Answers (1)

Anuj TBE
Anuj TBE

Reputation: 9790

Although you problem was related to displayField.

To select a single column or a set of columns you can do like this

$date1 = $this->Stocks->find()
         ->select(['date_1'])
         ->where(['families_id' => $id]);

Upvotes: 1

Related Questions