XF 2.2 Fetch all items from relation

[emiya]

Hello!

First of all, I'll show you my current situation.

I have 2 tables which kinda looks like:

Transactions

payment_id	user_id	username	date
1	1	admin	timestamp

Codes

code_id	payment_id	code	amount
1	1	83674538954	10.00
2	1	09574098574	10.00
3	1	89498365439	10.00

Now I have created 2 entities for the above tables and for the "Transactions" entity I have created a relation to the "Codes" table.
My problem is if I want to get all items from "Transactions" I also want every code related to each transaction. Currently I only receive one item from "Codes".

This is my relationship from "Transactions"

 $structure->relations = [
            'Codes' => [
                'entity' => 'foo\foo:Codes',
                'type' => self::TO_ONE,
                'conditions' => 'payment_id'
            ]
        ];
        $structure->defaultWith = ['Codes'];

and here is a snippet of the foreach loop

 <xf:foreach loop="$codeList" value="$test" key="$key">
                        <tr>
                            <td>{$test.username}</td>
                            <td>{$test.title}</td>
                            <td></td> <!-- This should be all items from "[B]Codes[/B]" that belong to the Payment_id, but I only get one item
                            <td>{$test.Codes.amount}</td>
                            <td>{$test.created}</td>
                            <td>{$test.complete}</td>
                            <td></td>
                        </tr>
                    </xf:foreach>

The dump of $test.Codes

Codes {#333 ▼
  #_getterCache: []
  #_valueCache: []
  #_structure: Structure {#336 ▶}
  #_em: Manager {#236 ▶}
  -_uniqueEntityId: 6
  #rootClass: "Foo\Foo\Entity\Codes"
  #_useReplaceInto: false
  #_newValues: []
  #_values: array:5 [▼
    "code_id" => 1
    "payment_id" => 3
    "code" => "83674538954"
    "amount" => "10.00"
  ]
  #_relations: []
  #_previousValues: []
  #_options: []
  #_deleted: false
  #_readOnly: false
  #_writePending: false
  #_writeRunning: false
  #_errors: []
  #_whenSaveable: []
  #_cascadeSave: []
  #_behaviors: null
}

I hope you understand my situation and are willing to help me.

 

[mjda]

I encountered a similar issue about a year ago. I think you're going to have to run a separate query to get those. You can't use a relation to grab multiple rows. Check the following thread for more info and a better explanation.

XF 2.2 - fetch() not returning full results

I've hit an issue here that really has me scratching my head. I'm setting a variable like this: $myList = $myRepo->getMyListForIndex()->fetch(); Here's what that function looks like: public function getMyListForIndex() { $finder = $this->finder('Vendor\Addon:Class')...

xenforo.com

 

[asprin]

I could be misinterpreting your issue but can't you simply use a TO_MANY relationship?

'type' => self::TO_MANY

 

[emiya]

I could be misinterpreting your issue but can't you simply use a TO_MANY relationship?

'type' => self::TO_MANY

That was my thought too, but unfortunately taht doesn't work as expected.

 

[asprin]

That was my thought too, but unfortunately taht doesn't work as expected.

I don't know, the following should work if one is using TO_MANY relationship.

<xf:foreach loop="$codeList" value="$test" key="$key">
    <tr>
        <td>{$test.username}</td>
        <td>{$test.title}</td>
        <td>
            <xf:foreach loop="$test.Codes" value="$singleCode" i="$i">
                ({$i}) {$singleCode.amount}<br />
            </xf:foreach>
        </td>        
        <td>{$test.created}</td>
        <td>{$test.complete}</td>
    </tr>
</xf:foreach>