Documentation Fragment Template - separated list

[Zdenek]

Hello,
I would like to create Fragment Template which inserts comma separated list of names of child elements filtered by stereotype.

I created Fragment Template based on following SQL query:
SELECT Name
FROM t_object
WHERE Stereotype = 'somestereotype' and ParentID = #OBJECTID#

and content is
[highlight]custom>[/highlight]
{Name}[highlight]<custom[/highlight]


it's working but...

I would like to get output in following form (problematic pieces of text is [highlight]highlighted[/highlight]):

[highlight]Label: [/highlight]Name1[highlight], [/highlight]Name2[highlight], [/highlight]Name3[highlight], [/highlight]...

And I don't know how to say in template engine language that "Label: " should be placed before first item (and if there is no items, there must be there no label) and ", " between two items.

Does anybody know how to change content of my Fragment Template to achieve required output?

Thanks,
Zdenek

[danbosscher]

Try

Label: [highlight]custom>[/highlight]{Name}, [highlight]<custom[/highlight]

Anything within a section (such as custom) should be repeated for each item. If it is the name of a recognized field enclosed in brackets {}, it will be replaced the current value for that field, otherwise it is treated as a literal.

I don't know what happens if there are no items, but placing Label before the beginning of the section will keep it from being generated more than once.

[Eve]

You can do it by inserting bookmarks. (In my example below a bookmark called LIKETHIS would be shown as {LIKETHIS})

[highlight]custom>[/highlight]{CustomSQL_TITLE_Begin}Label: {CustomSQL_TITLE_End}{CustomSQL_LIST_Begin}, {CustomSQL_LIST_End}{Name}[highlight]<custom[/highlight]

[Zdenek]

I am sorry, but I was not able to find how to correctly insert bookmarks into my template.

I found in context menu option Insert/Bookmark... with following items: CustomSQL_Begin, CustomSQL_Begin_Inner, CustomSQL_End, CustomSQL_End_Inner

But didn't found way how to insert it into text.

When I select one of bookmarks and click Insert button, dialog is closed but nothing else happens. I of course tried all other buttons and double click.

I tried to copy & paste bookmark name and put it into {} but then it was just placed to output document.

I am using EA version 11.1.1110

Thanks for your help :-)

[Zdenek]

Ok, after deeper investigation and RTF source analyzing I understand how it works.

So, my problem is solved   although working with RTF bookmarks is not user friendly (or I am missing some option how to make them visible in EA editor).

Thanks for help

[Eve]

You're right. It's not at all user friendly. Unfortunately there's a lot to be desired about the use of bookmarks, and so far I have been unable to push for improvements.

[AndyJ]

I made quite a bit of headway with the RTF editor, and then tried Ian Mitchell's tool.

I wonder if I can invoke him by uttering the magic word:

[size=16]eaDocX[/size]