Report Documentation       
Saved versionCurrent
General 
Category DAW Forums
Group Forums
NameDAW Forums: Trending Last 7 Days
TypeFull List
List
Graph Template(0)
ID:2126
Version:15
StatusProduction
Modified: 10/9/2015 12:08:08 AM
Share with DAW Forums Public
Original author: RCergol
OwnershipDAW Forums

 
Rights - Data & Design: 
 User(s) can navigate data (Using <<, <, >, >> buttons)
 Ownership required to change conditions

 
Appearance & list styling: 
Show Top10
 Hide report from Navigation
 Enable relate to from other reports
TypeReport
Style(4) DAW | no selector frame

 
Filters 
Filter Preference scopeLocal

 
Groups 
Groups
COLUMNTYPEFORMAT
0.. SUBJECT (thrd_Title)GROUP
0.. Forum Title
Concat('<',concat(frum_title,'>'))
CAPTION to thrd_Title

 
Totals 
Totals
COLUMNTYPEFORMAT
ViewsCALCULATE SUM IN REVERSE
Replies (thrd_ReplyCount)CALCULATE SUM

 
Calculated Columns: 
Extra column and key-figure calculations
COLUMNFORMULARFORMAT
EXTRA - ThreadDateDATE(THRD_DATESTAMP)
EXTRA - Forum NameCONCAT(FORUMSEQ,FRUM_TITLE)
EXTRA - SubjectCONCAT('',CONCAT(THRD_TITLE,''))
EXTRA - Forum TitleCONCAT('<',CONCAT(FRUM_TITLE,'>'))
EXTRA - T1'
EXTRA - T2(CONCAT(CAST(THREADID AS CHAR(6)),'''TARGET=''_DAW''>OPEN THREAD'))
EXTRA - Open DAW ThreadCONCAT(D_T1_D,D_T2_D)

 
Detail level columns: 
Details
COLUMNTYPEFORMAT
1.. Posted y-m-d-h:m (DATE_FORMAT(thrd_DateStamp,'%Y-%m-%d %H:%i')) 
1.. Subject
    (Concat('',Concat(thrd_Title,'')))
 
1.. Posted by User (PostUserName) 
1.. Attachments 
1.. Forum Title
    (Concat('<',concat(frum_title,'>')))
 
1.. Open DAW Thread
    (Concat(d_T1_d,d_T2_d))
 

 
Conditions 
Free SQL Conditions:DAI_.thrd_DateStamp >= CURDATE() - INTERVAL 7 DAY

 
Data Source: 
ConnectionForum
Database:ForumMySQL
Type of data-sourceMYSQL
CursorKeyset
Database Time out (in seconds)60
Table / View(2119) vForumHierarchy,Threads
SQLSELECT *, cast( (prnt_DispOrd * 100 + ParentID) as char(4) ) TitleSeq, cast( (DisplayOrder * 100 + frum_ForumID) as char(4) ) ForumSeq
FROM (SELECT frum.ForumId frum_ForumID, frum.title frum_Title, If(frum.ForumID = 23, 60, frum.DisplayOrder) DisplayOrder, frum.ThreadCount, frum.ReplyCount frum_Reply_Count, frum.LastPoster frum_LastPoster, (
FROM_unixtime(frum.lastpost)) frum_LastPostDate, frum.Description frum_Description, If(frum.ForumID = 23, 22, frum.ParentID) ParentID
FROM vb_Forum frum) frum
LEFT JOIN ( SELECT prnt.ForumId prnt_ForumID, prnt.title prnt_Title, prnt.DisplayOrder prnt_DispOrd
FROM vb_Forum prnt union SELECT (-1.) ForumId, 'DataFlex!' frum_Title, 0 DisplayOrder ) prnt ON frum.ParentID = prnt.prnt_ForumID
LEFT JOIN ( SELECT thrd.ThreadID, thrd.ForumID thrd_ForumId, Replace(thrd.title,'--','-') as thrd_Title, thrd.Open, thrd.ReplyCount thrd_ReplyCount, thrd.PostUserId, thrd.PostUserName, -- thrd.LastPosterId, thrd.LastPoster thrd_LastPoster, thrd.Attach Attachments, thrd.DateLine thrd_DateLine, (
FROM_unixtime(thrd.dateline)) as thrd_DateStamp, thrd.Views, thrd.Visible
FROM vb_thread thrd ) thrd ON thrd.thrd_forumid = frum.frum_forumid
WHERE (frum.ParentID > 0 OR (frum.ParentID <0 and frum.ThreadCount > 0) ) and frum.frum_ForumID not between 45 and 49 and frum.frum_ForumID not between 61 and 100 and frum.frum_ForumID not IN (21, 27, 32, 34, 38, 39, 42, 44, 51, 56 ) and thrd.visible = 1 and thrd.thrd_dateline > 1100000000 and thrd.open < 10

 
Form: 
Drill-down to(2121) Posts by Thread  Relation: ThreadID
Form style:(7112) Standard Blue
Form
FIELDX,Y,W,HSELECT
Display Order (INTEGER/DisplayOrder) [3](,,90,)
Forum (TEXT/frum_Title) [2](,,227,)
Parent ID (INTEGER/ParentID) [4](,,90,)
prnt Disp Ord (INTEGER/prnt_DispOrd) [7](,,90,)
prnt Forum ID (NUMBER/prnt_ForumID) [5](,,90,)
prnt Title (TEXT/prnt_Title) [6](,,227,)

 
About: 
¤DAI¤¤DAI¤¤DAI¤¤DAI¤¤DAI¤<b>Drill down on day to detail threads and click on row number to view full message thread.</b>¤DAI¤¤DAI¤¤DAI¤

 
User account information: 
User ID (Administrator)DAI Administrator   E-mail:bob.cergol@dataaccess.com
Share with DAW Forums Public   Member: True
OwnershipDAW Forums   Member: True
Server:AIServer1 - demo.dataaccess.com
Browser:Safari
Format:Decimal: Default   Date: Default
Design rights:Design Database based Reports,
Save Ad-hoc Reports, Change type,
Export Rights:Export Fixed, Export XML, Export CSV, Export PDF, Export to Outfolder

 
Report elements:44
System attributes:00000000001100010110110100000100
Server:Started: 8/9/2016 2:33:31 PM CCU:1 / 1   OS:  Type: 1  DAI vers: 6.5.12
Design Stamp:44b13de28b36e621bbf6a3c6863d6778

 
Integrate information: 
Use below information to integrate this report into external content. Reports and forms can either be accessed using the URL syntax (which however will expose the variables into the address field of the browser, or by using the FORM POST method (example below).

URLhttp://demo.dataaccess.com/VDF_DAI/ai.asp?UID=userid&PW=password&DAI_R=2126

Report ID (DAI_R)2126

Filters

Sample URL with filters

(Note: A valid UserID (UID) and password (PW) must be included in the URL before it is functional!)

http://demo.dataaccess.com/VDF_DAI/ai.asp?UID=&PW=&DAI_R=2126
Sample Autoload Form

(Note: A valid UserID (UID) and password (PW) must be included on the saved form!)

Use the FORM alternative (saved to a HTML document) to avoid that parameters will be visible in the URL at execution.
<HTML>
<BODY onload='BB.submit();'>
<FORM NAME=BB METHOD=POST ACTION="http://demo.dataaccess.com/VDF_DAI/ai.asp">
<INPUT TYPE=HIDDEN NAME="UID" VALUE="">
<INPUT TYPE=HIDDEN NAME="PW" VALUE="">
<INPUT TYPE=HIDDEN NAME="DAI_R" VALUE="2126">
</FORM>
</BODY>
</HTML>

 
Optional
Use single Frame only
include: &SFRAME=Y in URL or
include: <INPUT TYPE=HIDDEN NAME="SFRAME" VALUE="Y"> on form.

Return Dynamic AI Reports in a single framed version. I.e. drilldown will be within the same frame. SFRAME=N (default, if no SFRAME parameter is specified) Will return the Report in a framework allowing drilldown in a 2nd frame and Form presentation in a 3rd frame.
Optional
Overwrite LIST style
include: &LISTSTYLE=1234567 in URL or
include: <INPUT TYPE=HIDDEN NAME="LISTSTYLE" VALUE="1234567"> on form.

Will overwrite the defined List style. Use this option to uniform Dynamic AI Reports to styles used in the external applications. The style number must be a valid style number within Dynamic AI.
Optional
Overwrite FORM style
include: &FORMSTYLE=1234567 in URL or
include: <INPUT TYPE=HIDDEN NAME="FORMSTYLE" VALUE="1234567"> on form.

Will overwrite the defined Form style. Use this option to uniform Dynamic AI Forms to styles used in the external applications. The style number must be a valid style number within Dynamic AI.
Optional
Outputformat
CSV
&DEVICE=CSV

The Report is returned in CSV format – as a "stream" to the requesting client browser or service.
Optional
Outputformat
XML
&DEVICE=XML

The Report is returned in XML format – as a "stream" to the requesting client browser or service.
Optional
Outputformat
FIXED
&DEVICE=FIXED

The Report is returned in FIXED format – as a "stream" to the requesting client browser or service.
Optional
Outputformat
PDF
&DEVICE=PDF

The Report is returned as a PDF file – as a "stream" to the requesting client browser or service.