Advertisement
fahrul11

Update Jasper Datasource

Aug 13th, 2014
239
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.30 KB | None | 0 0
  1. -- find datasource id
  2. select * from JIJdbcDatasource
  3.  
  4. -- Update Datasource
  5. update JIReportUnit set reportDataSource = [data_source_id]
  6. where id in
  7. (
  8.       select id from JIResource where parent_folder in
  9.       (
  10.             select id FROM JIResourceFolder where uri = [new_folder_name]
  11.       )
  12. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement