sql server - Database views and models being called in my controller

Question

I am a little new to cakephp 3 and i am trying to figure out how you call this simple model/table in my index controller so that i can get the values to show up on my webpage.

this is my view vCalcTranscriptUpdateTerms in sql management

then this is my code for the model/table

due to it being a very very basic table of just 1 i only put 1 statemnt just to load the view.

<?php

namespace AppModelTable;

use CakeORMTable;

class UpdatedTranscriptsTable extends Table
{
public function initialize(array $config)
    {
        $this->setTable('preload.vCalcTranscriptUpdateTerms');
    }
}

now that i have a table set to that view how the heck do i call that table in my controller and get all of the information out of it?

Answer 1

at the top of controller include the below code for accessing the models

use CakeORMTableRegistry;

and you add the in before filter function or in initialize function or you can use it inside any function where you have indeed

$this->loadModel('UpdatedTranscripts');