Just get where

[codeboy]

I want to get only the WHERE part of the SQL output. Because I will add "where" as to pure php.

for example; WHERE assigned_status = 'Okay'
like this

$sql = $this->getEntityManager()->getQuery()->createSelectQuery('Meeting', $selectParams);
$sth = $pdo->prepare($sql);
$sth->execute();

[tanya]

https://github.com/espocrm/espocrm/blob/master/application/Espo/ORM/DB/Query/Base.php#L134

[codeboy]

Yes, I see, I use it. But I do not want it to be "SELECT * FROM meeting". This function creates them. Because it wants an entity. I just need "WHERE".

[tanya]

If you spend 2 minutes for reading the code, you will see, how is built each part of select query, wherePart as well.

[codeboy]

I could not. Would you show me a little sample, please?

[tanya]

$whereClause = $params['whereClause'];
if (empty($whereClause)) {
$whereClause = array();
}
if (!$deleted) {
$whereClause = $whereClause + array('deleted' => 0);
}
if (empty($params['joins'])) {
$params['joins'] = array();
}
if (empty($params['leftJoins'])) {
$params['leftJoins'] = array();
}
if (empty($params['customJoin'])) {
$params['customJoin'] = '';
}
$wherePart = $this->getEntityManager()->getQuery()->getWhere($entity, $whereClause, 'AND', $params);
$where = "WHERE " . $wherePart;


copied from the the shared file....

[codeboy]

Very big thanks
Argument 1 passed to Espo\\ORM\\DB\\Query\\Base::getWhere() must implement interface Espo\\ORM\\IEntity, string given, called

because I use string

$this->getEntityManager()->getQuery()->getWhere('Meeting' ,$whereClause, 'AND', $params);

What does this mean tanya ?

[tanya]

means, the method waits for an object (of Meeting Entity)

[codeboy]

Yeah, I check the codes you sent. I tried to do this. But it gives me a mistake. I'm on the custom report page.

[codeboy]

Thanks, I solved tanya.