In the File name pattern field, enter a filename for the report you are running.If you would like to know more about why you could not find One Drive, please contact CUL Desktop Services. The Directory field should populate with this path. If you do not have a One Drive - Cornell University folder, choose your Desktop folder instead, and continue to follow the set of instructions below for using the Share feature to send yourself the file. On Output Settings, click the orange folder icon and navigate to your C:\Users\\OneDrive - Cornell University\Desktop folder.Right-click on any part of the results set shown in the bottom right side of the window and choose Export data.You can export your query results to CSV if you would like to use them in Excel. sql extension, such as "loans_and_renewals_counts_olin.sql" Right-click on the name of the default script (here, the name is "Script-1"), then choose Rename File.To show results for just the Olin library location, go to the SELECT statement under WITH and enter Olin in the single quote marks next to items_effective_location_filter.To show results for the period of 6/1/21 through 6/15/21, go to the SELECT statement under WITH and enter those start and end dates within the single quote marks.In the SELECT statement under WITH, look for the start and end date parameters to set the date.Return to the query in your Virtual DBeaver window.Follow steps above to Select the Report Query to Run, and choose the CR100 query.Here is an example of setting date and location filters in the CR100 loans_and_renewals_counts query. Just above your query, make sure the ldp_cornell data source has been selected. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |