FPSADMIN.DASH_E_SPOTLIGHT_QUERY

>

> FPSADMIN.WIP_WAFER_HIST_LOOP

View FPSAPP.DASH_E_SPOTLIGHT_QUERY

This is a copy of the complex spotlight query used in the C# function in 3.9. Please note this view is not used by the dashboard or anything else but is saved in this query for reference and in case we want to make this a function in the future. Variables are filled in so the view compiles. Search for colon or curly brackets. Some advantages to make this an Oracle function rather than a C# function include: 1) We can easily see and update the complex query in the database rather than the website. 2) Database experts (i.e. Cabe) can maintain the function in addition to programmers. 3) We can change the basic spotlight hover messages without a web site release. Disadvantages include: 1) It's a bit complicated how we have to make a type to return the values. 2) There are more complex inputs in the web function than are included here. Cabe and Tyler agreed not to do this now mostly because of #2. But if we did this, the inputs would be: 1) i_facility (i.e. RRCWF2) 2) i_category (must match DASH_C_SPOTLIGHTS value i.e. MODULE) 3) i_category_filter (i.e. and wip_module = 'THIN FILM') - could be null for facility - always appended to i_facility filter so needs to start with and - currently :moduleId is a parameter but we could move to i_category_filter 4) i_data_filter (i.e. and wafer_size = '6') - will often be null if no filters selected then set to 1=1 - always appended to i_facility filter and i_category_filter so needs to start with and 5) i_only_movable_turns (boolean) - would need to be changed since web uses True/False and datbase uses Y/N The select query in the web code for the example would be: select * from table(dash_p_spotlights('MFN', 'MODULE', 'wip_module = ''DIFF''', 'wafer_size = ''6''', 'N') order by shift_index desc, sort_order;