Hi all (again)… to follow on from this… I’ve got the FK tables all set, working and I’ve created al

U02P7B6K2LC

Hi all (again)… to follow on from this…

I’ve got the FK tables all set, working and I’ve created all the transfers required.

I’m now at the point where I’m trying to pull all the data together to place in the “search” table for elastic search.

So I have a RecipeSearchWriter.php file and I’ve got those rows populating.

So to pull in the Ingredients data from the linked table, I’m using this code:

$ingredients = PyzIngredientQuery::create()->findByFkRecipeId($recipeTransfer->getIdRecipe());
$recipeTransfer->setIngredients($ingredients);

But I’m not able to retrieve any ingredients via the PyzIngredientQuery. I’ve tried:

$ingredientEntities = PyzIngredientQuery::create()->findByFkRecipeId($recipeTransfer->getIdRecipe());

and:

$ingredientEntities = PyzIngredientQuery::create()->filterByFkRecipeId($recipeTransfer->getIdRecipe())->find();

…neither of which are pulling any ingredient data.

When I hardcode the data:

$recipeTransfer->setIngredients('HELLO!');

“HELLO!” does get placed in the Search table - so I’m sure that “setIngredients” works.

UKEP86J66

Running

$ingredientEntities = PyzIngredientQuery::create()->filterByFkRecipeId($recipeTransfer->getIdRecipe())->find();

will return a propel collection, which could look empty depending on what you are doing with it. Usually these collections are iterated using foreach and then each entity is converted to a transfer or scalars and then used.
To see what is happening you could do something like

$ingredientEntities = PyzIngredientQuery::create()->filterByFkRecipeId($recipeTransfer->getIdRecipe())->find();

foreach ($ingredientEntities as $ingredientEntity) {
  dump($ingredientEntity->toArray();
}

U02P7B6K2LC

Yes that’s got it! 🙂

U02P7B6K2LC

Thank you!

UKEP86J66

Nice, glad it’s working 🙂