I made via SQLReport "resent news" with fields:
assetData.title
assetData.url
assetData.synopsis
Post.dateSubmitted

All work well, but I need else Thumbnails from posts attachments. I find only "Post.storageId" field.

Can anyone to say - how to get any information about attachments of post? At what fields I need looking for?

I agree about my English, but I have not absolutely understood sense of your message. You have tried to answer a question or have tried to prove yourself?

I shall try to describe a question in other words:
I use SQLReport and I need to take URL of Thumbnails of attachment of Post. There is a field Post.storageId. Is there others fields, which contain informaition about attachments of Post?

Or, probably, it is necessary for me to receive the information about URL of attachment only processing value of this field external additional a macro?

OK, I agree. The message, probably, too short also does not give full representation about what there is a massage.

Very much widespread situation when Collaboration System it is used for the publication of news.

Thread is a news, Post is a discussion about news (if allow). In the Collaboration properties I can set "Attachments Per Post".
I need "thumbnail" - If this Post has attachments, the URL for the thumbnail of the first image attachment (As is in the WebGUI help).

There is "storageId" - The Asset ID of the storage node for the Post, where the attachments are kept. (As I understand: field "storageId" of table "Post")

I can not find any assetId like my Post.storageId (from SQL)

My SQL:

SELECT
assetData.url,
assetData.title,
assetData.assetId,
assetData.groupIdView,
assetData.synopsis,
Post.storageId,
Post.dateSubmitted,
assetData.status,
Post.assetId,
assetData.revisionDate,
asset.state,
asset.parentId,
p.title AS parent
FROM assetData
LEFT JOIN
Post ON assetData.assetId=Post.assetId
LEFT JOIN
asset ON assetData.assetId=asset.assetId
LEFT JOIN
assetData as p ON p.assetId = asset.parentId
WHERE assetData.status = 'approved'
AND asset.state = 'published'
AND asset.className = 'WebGUI::Asset::Post::Thread'
AND assetData.url LIKE 'news/%'
AND !(assetData.url LIKE 'photos/%')
AND assetData.groupIdView = 7
AND assetData.revisionDate=(SELECT MAX(assetData.revisionDate) FROM assetData WHERE assetData.assetId=asset.assetId)
GROUP BY assetData.assetId
ORDER BY Post.dateSubmitted DESC
LIMIT 3

Template:

<a name="<tmpl_var assetId>"></a>
<tmpl_if session.var.adminOn>
 <p><tmpl_var controls></p>
</tmpl_if> 
  <tmpl_if displayTitle>
    <h1><tmpl_var title></h1>
</tmpl_if>

<tmpl_if description>
    <tmpl_var description><p />
</tmpl_if>

<tmpl_if debugMode>
 <ul>
 <tmpl_loop debug_loop>
  <li><tmpl_var debug.output></li>
 </tmpl_loop>
 </ul>
</tmpl_if>

<table width="95%" cellpadding=2 cellspacing=1 border=0>

<tmpl_loop rows_loop>
<tr><td>

<a href="/<tmpl_var row.field.url.value>#<tmpl_var row.field.assetId.value>"><div class="tableHeader"><tmpl_var row.field.title.value></div></a>
 <tmpl_if row.field.storageId.value>
    <a href="/<tmpl_var row.field.url.value>#<tmpl_var row.field.assetId.value>"><img class="thumbnail" vspace="5" hspace="15"
 src="/uploads/<tmpl_var row.field.some_what_I_do_not_know.value>" align="left"/></a>

   </tmpl_if>
<div align="justify">
<font size=-1><tmpl_var row.field.synopsis.value></font>
</div><br>

<div align="left">
^D("%D.%m.%y %j:%m",<tmpl_var row.field.dateSubmitted.value>);</div>
(<b>Раздел:</b> <tmpl_var row.field.parent.value>)
<div align="right">  ( <a href="/<tmpl_var row.field.url.value>#<tmpl_var row.field.assetId.value>">Подробнее</a>
         )</div><p />
</td></tr>
</tmpl_loop>
</table>
<tmpl_if pagination.pageCount.isMultiple>
  <div class="pagination">
    <tmpl_var pagination.previousPage>   <tmpl_var pagination.pageList.upTo20>  <tmpl_var pagination.nextPage>
  </div>
</tmpl_if>

I did it in 6.2.11 and try to do it in 6.8.7...

> 24 messages 14 - OK, but in eight messages

what's about rest of two? 24-14-8=2 

Now all works. Probably, it is useful to somebody else except for me.
It collects the latest news from several Collaboration and displays:

Title,
Synopsis,
Thumbnail,
Chapter name,
Date&Time,
Link to news body,

Marked by a bold font change by the necessity:

S Q L:

SELECT
assetData.url,
assetData.title,
assetData.assetId,
assetData.groupIdView,
assetData.synopsis,
Post.storageId,
Post.dateSubmitted,
assetData.status,
Post.assetId,
assetData.revisionDate,
asset.state,
asset.parentId,
p.title AS parent
FROM assetData
LEFT JOIN
Post ON assetData.assetId=Post.assetId
LEFT JOIN
asset ON assetData.assetId=asset.assetId
LEFT JOIN
assetData as p ON p.assetId = asset.parentId
WHERE assetData.status = 'approved'
AND asset.state = 'published'
AND asset.className = 'WebGUI::Asset::Post::Thread'
AND (assetData.url LIKE 'news/%'
OR assetData.url LIKE 'photos/%')
AND assetData.groupIdView = 7
AND assetData.revisionDate=(SELECT MAX(assetData.revisionDate) FROM assetData WHERE assetData.assetId=asset.assetId)
AND Post.revisionDate=assetData.revisionDate
GROUP BY assetData.assetId
ORDER BY Post.dateSubmitted DESC
LIMIT 5

T E M P L A T E:

<a name="<tmpl_var assetId>"></a>
<tmpl_if session.var.adminOn>
 <p><tmpl_var controls></p>
</tmpl_if> 
  <tmpl_if displayTitle>
    <h1><tmpl_var title></h1>
</tmpl_if>

<tmpl_if description>
    <tmpl_var description><p />
</tmpl_if>

<tmpl_if debugMode>
 <ul>
 <tmpl_loop debug_loop>
  <li><tmpl_var debug.output></li>
 </tmpl_loop>
 </ul>
</tmpl_if>

<table width="95%" cellpadding=2 cellspacing=1 border=0>

<tmpl_loop rows_loop>
<tr><td>
<a href="/<tmpl_var row.field.url.value>#<tmpl_var row.field.assetId.value>"><div class="tableHeader"><tmpl_var row.field.title.value></div></a>
<a href="/<tmpl_var row.field.url.value>#<tmpl_var row.field.assetId.value>"><img class="thumbnail" src="^ThumbURL(<tmpl_var row.field.storageId.value>);" border="0" align="left"/></a>
<div class="synopsis">
<tmpl_var row.field.synopsis.value>
</div><br>

<div align="left">
^D("%D.%m.%y %j:%m",<tmpl_var row.field.dateSubmitted.value>);</div>
(<b>Chapter:</b> <i><tmpl_var row.field.parent.value></i>)
<div align="right">  ( <a href="/<tmpl_var row.field.url.value>#<tmpl_var row.field.assetId.value>">More...</a>)</div><p />
</td></tr>
</tmpl_loop>
</table>
<tmpl_if pagination.pageCount.isMultiple>
  <div class="pagination">
    <tmpl_var pagination.previousPage>   <tmpl_var pagination.pageList.upTo20>  <tmpl_var pagination.nextPage>
  </div>
</tmpl_if>

M A C R O:

package WebGUI::Macro::ThumbURL;

#-------------------------------------------------------------------

use strict;
use WebGUI::Session;
use WebGUI::Storage;
use WebGUI::Storage::Image;

#-------------------------------------------------------------------
sub process {
 my $storageId = shift;

 my $storage = WebGUI::Storage::Image->get($storageId);

 my $url;
 foreach my $filename (@{$storage->getFiles}) {
  if ($storage->isImage($filename)) {
   $url = $storage->getThumbnailUrl($filename);
   last;
  }
 }
  if ($url eq '')  {$url = '/extras/spacer.gif';}
 return  $url;
}
1;