Run a report at a specific date with the K1000
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
Answers (2)
Please log in to answer
Posted by:
chucksteel
11 years ago
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.
Posted by:
rockhead44
11 years ago
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.
