Accessing notes from the tagvalue

[SalimMulla]

Hello All,

I have multiple TagValues for an element. Now I want to generate notes for each TagValue in the document.
I have created a fragment template and written script as :

SELECT * FROM t_objectproperties
LEFT join t_object
ON t_objectproperties.Object_ID = t_object.Object_ID
WHERE t_objectproperties.Property = 'Test Case Type'

Here 'Test Case Type' is one of the TagValue for the element. This code prints the all the tag properties for 'Test Case Type' is one of the TagValue.
Now I want to extract the "Notes" from this 'Test Case Type' TagValue. Please let me know how to proceed further after "WHERE  t_objectproperties.Property = 'Test Case Type'".
I have attached the image for the same also.

Waiting for your reply.

Regards,
Salim Mulla

[qwerty]

Where is your problem? The notes are in the Notes column.

q.

[Geert Bellekens]

I don't see any image.

Geert

[SalimMulla]

Hello,

I forgot to attach the image.

I know that notes are in the notes column. I want take the notes value in the local variable.
How can I do this?

Regards,
Salim Mulla

[Geert Bellekens]

Salim,

I'm not following.
Sadly enough we cannot read your mind, so you'll have to explain in a bit more detail what you are trying to achieve, and where exactly you have a problem.

Geert

[SalimMulla]

Hi,

SELECT * FROM t_objectproperties
LEFT join t_object
ON t_objectproperties.Object_ID = t_object.Object_ID
WHERE t_objectproperties.Property = 'Test Case Type'

After this I will get all the object properties for 'Test Case Type'. From these properties I want to extract the Notes column into a local variable so that I will use that variable in template generation.
The problem is with extraction of the notes column into local variable. How can I do this?

Regards,
Salim Mulla

[Paolo F Cantoni]

Hi Salim,

One problem we have in answering your question is that you haven't indicated the context of the SQL query.   For example, if you are working directly in SQL (via, for example, SQL Management Studio or MS Access) then there is one answer.  If you are using the query as part of an EA internal search then there is another answer.  If you are using it as part of some add-in code (such as in C#), then there will be yet another answer.

Can you please clarify the surrounding context so we can help.

Paolo

[Geert Bellekens]

I'm still not clear on what you are trying to do.

Are you working on RTF Templates?
In that case; are you using a query fragment or a script fragment?
If you are using a query fragment then you have to explicitly set the aliases of each result field and use that in your template.

So your query should be something like

Code: [Select]

SELECT tv.Property AS Tag, tv.Value AS TagValue, tv.Notes AS TagNotes
FROM t_objectproperties tv
INNER JOIN t_object o ON o.Object_ID = tv.Object_ID
WHERE tv.Property = 'Test Case Type'
Then in the template use custom fields as {Tag}, {TagValue} and  {TagNotes }

Geert