User Tools
Writing /app/www/public/data/meta/databaseandnetworkmanagement/database_views.meta failed
databaseandnetworkmanagement:database_views
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| databaseandnetworkmanagement:database_views [2018/01/05 16:36] – mmcc | databaseandnetworkmanagement:database_views [2021/06/25 10:09] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== Database Views ====== | ||
| + | Author: Michelle McCausland | ||
| + | |||
| + | Views are static tables created, for example, on Crown Castle' | ||
| + | |||
| + | Views are static and will only be accurate to the values present at the time of the view creation. | ||
| + | |||
| + | This means that any modifications to the table fields will not propagate to the view unless the view is manually updated. | ||
| + | |||
| + | See [[https:// | ||
| + | |||
| + | In order to manually update the views for CCSUPPORT-2400 it was necessary to run the following queries on the production master db: | ||
| + | |||
| + | < | ||
| + | create or replace view v_tc_f_field_tech_site_visit as | ||
| + | select * | ||
| + | from ticketer.ticket_change tc, ticketer.f_field_tech_site_visit ftsv | ||
| + | where | ||
| + | tc.id = ftsv.change_id; | ||
| + | |||
| + | create or replace view ticketer.v_tc_f_crown_das_noc as | ||
| + | select * | ||
| + | from ticketer.ticket_change tc, ticketer.f_crown_das_noc cdn | ||
| + | where | ||
| + | tc.id = cdn.change_id; | ||
| + | </ | ||
| + | |||
| + | A project was created to manually refresh the views: https:// | ||
| + | |||
| + | Via a jenkins build: | ||
| + | http:// | ||
| + | |||
| + | But it is not known (need to review) why this was only implemented on QA and not production. | ||
Page Tools
