[ashkufaraz]

Hi
I want change getAll function in class.applications.php.
I want join app_cahec_view with my pm table like this

Code: Select all

$Criteria->addAlias( 'IC', 'PMT_MYTABLE' );
$Criteria->addJoin( AppCacheViewPeer::APP_UID, 'IC.APP_UID', Criteria::LEFT_JOIN );

when i add where condtion say error

Code: Select all

$Criteria->add("IC.ID",  11 , Criteria::EQUAL);

But this code say error

Code: Select all

 wrapped: Cannot fetch TableMap for undefined table: PMT_MYTABLE

I think, i must update proper model and add my pmt table...

pleas help me

[programerboy]

Hi,

I tested it and it worked properly and I didn't change model.

my code is:

Code: Select all

$Criteria->addAlias( 'TEST', 'PMT_TEST' );
$Criteria->addJoin( AppCacheViewPeer::USR_UID, 'TEST.NAME', Criteria::LEFT_JOIN );

Please check your database that table exist or not and check your table name for case sensitive characters.

Thanks

[ashkufaraz]

thanks programerboy

When add where condition i get error

Code: Select all

$Criteria->add("IC.ID",  11 , Criteria::EQUAL);

Code: Select all

 wrapped: Cannot fetch TableMap for undefined table: PMT_MYTABLE

[amosbatto]

You need to edit the database schema located at workflow/engine/config/schema.xml and add your table there.

Then you need to use these commands to update the database schema in ProcessMaker:
cd /opt/processmaker [change to where ProcessMaker is installed]
php processmaker database-upgrade
See: http://wiki.processmaker.com/processmak ... se-upgrade

The problem is that your new schema might interfere with your existing Report Table. I haven't tried it. See if it still exports cases correctly to the Report Table when you run cases.

[ashkufaraz]

thanks amosbatto

I run database-upgrade command but say nothing to change in data base

I think this command does not check pmt table

[amosbatto]

You are right. You have to also add all the model information in the code. Sorry, I don't know how to do that, but it probably isn't necessary. Read the code for Report Tables and you can figure out how to access them.

[ashkufaraz]

I do it...

add model file to
\htdocs\workflow\engine\classes\model

with this code

Code: Select all

$Criteria->addJoin( AppCacheViewPeer::APP_UID, MyTablePeer::APP_UID, Criteria::LEFT_JOIN );
$Criteria->add(MyTablePeer::ID, 1, Criteria::EQUAL);