XF 2.2 Attempt to assign property "shortName" on null

[Robert9]

I have a finder; when i use:

$topicFinder = $this->finder('XFRM:Category');
$topicFinder
            ->where('resource_category_id', '1')
            ->fetch();

I get a result.

Now I do the same with mya table:

$topicFinder = $this->finder('Xencafe\News:News');
$topicFinder
            ->where('news_id', '1')
            ->fetch();

I get the error message:

Attempt to assign property "shortName" on null

I have checked everything ten and more times.
I have a table, I have an entity, I have a content type.

What else do I miss? Any Idea how to find it, please?

 

[Robert9]

Hallejulia!

Missing return $structure;

 

[Robert9]

But ... when I use my relations I have always JOINS,
but sometimes i just dont need them.

Is there a way to do a query without the relations, please?

can I say finder->please go on->without_relation(User)

 

[Jeremy P]

Joins are only performed automatically if you're setting a clause on a relation or have some defaultWith relations set on the structure. If it's the latter, you can opt out when grabbing the finder:

$finder = $this->em()->getFinder('Some:Entity', false);

 

[Robert9]

Thank you;
you may, can explain to me why this here will show me the whole universe, please?

 $topicFinder
            ->where('topic_state', 'visible')
            ->whereOr(
                [
                    ['language_id', '=', $languageId],
                    ['language_id', '=', 0],
                ]
            )
            ->order('display_order', 'ASC')
            ->fetch();

        return $topicFinder;

I just want to have some rows of a table, but I get soooooooooooooo much other stuff.
How can I have just my rows, please?

 

[Jeremy P]

You'd have to post more code, including the topic entity in question (or at least its structure) and what unexpected stuff you're getting and how you know you're getting it.

 

[Robert9]

Solved it.
I have to use $result = $finder->fetch();
else I get the whole finder-universe.