Hi

I got this report, that i want to run on evry year at first of december, how can i modify the code?:

SELECT ASSET.NAME AS ASSET_NAME, A39.NAME AS FIELD_39, ASSET_DATA_10.FIELD_33 AS FIELD_33, ASSET_DATA_10.FIELD_32 AS FIELD_32, ASSET_DATA_10.FIELD_31 AS FIELD_31, ASSET_DATA_10.FIELD_36 AS FIELD_36  FROM ASSET_DATA_10  LEFT JOIN ASSET ON ASSET_DATA_10.ID = ASSET.ASSET_DATA_ID AND ASSET.ASSET_TYPE_ID=10 LEFT JOIN ASSET_ASSOCIATION J39 ON J39.ASSET_ID = ASSET.ID AND J39.ASSET_FIELD_ID=39
                             LEFT JOIN ASSET A39 ON A39.ID = J39.ASSOCIATED_ASSET_ID
                             LEFT JOIN ASSET_DATA_2 AD39 ON AD39.ID = A39.ASSET_DATA_ID 
                                ORDER BY ASSET_NAME
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

1

1. Create a new SQL report using your query

2. Use the Schedule reports tab to schedule the report to run on the 1st of December.

 

Answered 11/04/2013 by: chucksteel
Red Belt

Please log in to comment

Answers

0

Assuming your query is correct, create a new Report by going to Reporting-Add New Report (SQL) and create a new one, pasting your SQL code in there. Once you have the report on the K1000 go to Reporting-Scheduled Reports-Create A New Schedule. From there select your report and go to the Scheduling options at the bottom and select "Run on the" to pick the first of every December. 

Answered 11/04/2013 by: rockhead44
Tenth Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity