General | |
---|
Category | DAW Forums |
Group | Forums |
Name | DAW Forums: Trending Last 7 Days |
Type | Full List |
| List |
Graph Template | (0) |
ID: | 2126 |
Version: | 15 |
Status | Production |
Modified: | 10/9/2015 12:08:08 AM |
Share with | DAW Forums Public |
Original author: | RCergol |
Ownership | DAW Forums |
|
Rights - Data & Design: | |
---|
| User(s) can navigate data (Using <<, <, >, >> buttons) |
| Ownership required to change conditions |
|
Appearance & list styling: | |
---|
Show Top | 10 |
| Hide report from Navigation |
| Enable relate to from other reports |
Type | Report |
Style | (4) DAW | no selector frame |
|
Filters | |
---|
Filter Preference scope | Local |
|
Groups | |
---|
Groups | COLUMN | TYPE | FORMAT |
---|
0.. SUBJECT (thrd_Title) | GROUP | | 0.. Forum Title Concat('<',concat(frum_title,'>')) | CAPTION to thrd_Title | |
|
|
Totals | |
---|
Totals | COLUMN | TYPE | FORMAT |
---|
Views | CALCULATE SUM IN REVERSE | | Replies (thrd_ReplyCount) | CALCULATE SUM | |
|
|
Calculated Columns: | |
---|
Extra column and key-figure calculations | COLUMN | FORMULAR | FORMAT |
---|
EXTRA - ThreadDate | DATE(THRD_DATESTAMP) | | EXTRA - Forum Name | CONCAT(FORUMSEQ,FRUM_TITLE) | | EXTRA - Subject | CONCAT('',CONCAT(THRD_TITLE,'')) | | EXTRA - Forum Title | CONCAT('<',CONCAT(FRUM_TITLE,'>')) | | EXTRA - T1 | ' | | EXTRA - T2 | (CONCAT(CAST(THREADID AS CHAR(6)),'''TARGET=''_DAW''>OPEN THREAD')) | | EXTRA - Open DAW Thread | CONCAT(D_T1_D,D_T2_D) | |
|
|
Detail level columns: | |
---|
Details | COLUMN | TYPE | FORMAT |
---|
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: | |
---|
Connection | Forum |
Database: | ForumMySQL |
| |
Type of data-source | MYSQL |
Cursor | Keyset |
Database Time out (in seconds) | 60 |
Table / View | (2119) vForumHierarchy,Threads |
SQL | SELECT *, 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 | FIELD | X,Y,W,H | SELECT |
---|
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 |
Ownership | DAW 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).
|
URL | http://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. |
|