SQL Search w model documents - only first element?

[Hurra]

Hello!

I use a SQL search to find my elements that I want in a table in my report.

I made it easy for me and put the desired elements in a diagram and my search has diagram name as input and lists all the elements on the diagram which was found:

Code: [Select]

SELECT o.ea_guid AS CLASSGUID, o.Object_Type AS CLASSTYPE, o.name AS Name, o.Note AS description
FROM (( t_object o
INNER JOIN t_diagramobjects do ON do.Object_ID = o.Object_ID)
INNER JOIN t_diagram d ON d.Diagram_ID = do.Diagram_ID)
WHERE d.name LIKE '#WC#<Search Term>#WC#'
ORDER BY o.Name ASC

The result is correct according to the SQL search/output window, however in the report, only the first element of that list is generated.

What am I missing?

Thanks!

[Geert Bellekens]

What does the template look like?

Geert

[Hurra]

package>
element>

table with Element.Name and Element.Notes

<element
<package

[Geert Bellekens]

And you are using a model document with the search and this template?

Geert

[Hurra]

And you are using a model document with the search and this template?

Geert

Yes. The search is selected through tagged values, and also search string specified.

[Geert Bellekens]

Weird. I'm not sure why it doesn't work.
I've used similar constructions in the past without issues.

Nothing in the template filters that is blocking some content?

Geert

[Hurra]

Weird. I'm not sure why it doesn't work.
I've used similar constructions in the past without issues.

Nothing in the template filters that is blocking some content?

Geert

Before I implemented the new diagram and SQL search I tried to get my elements of interest with filters... Ofc I forgot about that.

Thank you!

As an extra I can ask if this approach is considered "good". We have structured a stereotype with the dependency relation, depends on/needed by. If I only want the TOP element, can I create an SQL search to find all these elements but filter out the elements which only acts as source? The TOP element is never target I guess?

Thanks again Geert!