I’m trying to add a filter on the requirement for a user to be able to filter offers by requirements
<code>$requirementUuid = $request->query->get('requirement_uuid');
if ($requirementUuid) {
$qb->leftJoin('o.requirement', 'r')
->andWhere('r.uuid = :requirementUuid')
->setParameter('requirementUuid', $requirementUuid);
}
$offers = $qb->getQuery()->getResult();
</code>
<code>$requirementUuid = $request->query->get('requirement_uuid');
if ($requirementUuid) {
$qb->leftJoin('o.requirement', 'r')
->andWhere('r.uuid = :requirementUuid')
->setParameter('requirementUuid', $requirementUuid);
}
$offers = $qb->getQuery()->getResult();
</code>
$requirementUuid = $request->query->get('requirement_uuid');
if ($requirementUuid) {
$qb->leftJoin('o.requirement', 'r')
->andWhere('r.uuid = :requirementUuid')
->setParameter('requirementUuid', $requirementUuid);
}
$offers = $qb->getQuery()->getResult();
But i have an empty array as result when the offers exit for the requirement I’m trying to access
<code>Code Details
200
Response body
{
"message": "List of offers",
"data": [],
"page": 1,
"total": 0,
"perpage": 10
}
</code>
<code>Code Details
200
Response body
{
"message": "List of offers",
"data": [],
"page": 1,
"total": 0,
"perpage": 10
}
</code>
Code Details
200
Response body
{
"message": "List of offers",
"data": [],
"page": 1,
"total": 0,
"perpage": 10
}
A list for offers should be returned but its not
I tried to check in the DB the uuid of requirement is stored in DC2Type uuid. Please anyone has an idea on how i can convert the normal uuid I pass in the request to that uuid format?
1