- continue working on FA/RA
- change column selections in order by selected
- hide column details in Basic, set unselected in Advanced
- Set query button not working properly when editing a query in the Advanced
- Set query should just submit/run the query, remove the Submit button
- add html documentation for SQL reference
- working on date calculation queries
Author Archives: gvr4wd
Dong Shin 07.17.2013
Dong Shin 07.15.2013
- unable to duplicate the COGNOS import problem (incorrect($0) values) at office, need to run the query on site.
- continue working on FA
- working on date calculations
Dong Shin 07.13.2013
- working through the list action items from yesterday’s meeting
- removed queryTextArea, replaced with _queryText to keep track
- rearranged the buttons in Funding Status panel
- removed Submit query – runs on Query Set or Load
- changed order of the items selected in Advanced Query – now in order of selection
Dong Shin 07.13.2013
- deployed new FA and RA with some bug fixes
- VizTool meeting – also in Requirements page
- add date calculations to Funding Status
- change column selections in order by selected
- hide column details in Basic, set unselected in Advanced
- add export to Visibility
- Set query button not working properly when editing a query in the Advanced
- remove query text display in Funding Status
- ToolTips be to added (Lenny has the action item to get the list)
- Labels need to be match throughout – TBD on pit crews
- move Totals to the top of the grid due to the screen sizing(?)
- Set query should just submit/run the query, remove the Submit button
- add html documentation for SQL reference
- continue working on FA
Dong Shin 07.10.2013
- Somehow the COGNOS ingest problem doubling (or tripling) of amounts disappeared? Possible bug in the client code….
- Continue working on FA/RA
- fixed Total Allocated showing random numbers in Project Mgmt when there is no Req data
- fixed Req ID not showing in RA
- changed the Req data labels to match FA
- added Fiscal Year to RA
Dong Shin 06.09.2013
- continue working on FA
- added Search/Filter columns in Query Builder
- working on eliminating duplicate data on COGNOS data ingest
Dong Shin 07.08.2013
- continue working on FA
- added Copy Req to the Project Editor
- fixed Type not showing/saving properly in Project Editor
Dong Shin 07.01.2013
- continue working on FA
- Query Builder
Dong Shin 06.28.2013
- continue working on FA
- added detailed column info for the columns in Query Builder’s filter list
- added CheckBox to switch between detailed view and name view
Dong Shin 06.27.2013
- VizTool meeting
- deployed new FA, XML config for Query Builder not loading. adding more debugging info
- continue working on FA
- moved queryBuilderXML to a separate file
- fixed sorting problem on Currency(Number) fields in Funding Status
- ITAR training/review (InfoTek) @ 4
Dong Shin 06.26.2013
- continue working on FA
- added Search Filter in Advanced Filter for Funding Status
- reworked the Query Save to overwrite existing
- added Filter Data in LoadSavedQuery
- found Footer DataGrid component
- added Footer DataGrid for the totals row in Funding Status
Dong Shin 06.25.2013
- deployed new FA – COGNOS ingest works.
bug on Total Available – off by a penny? fixed- continue working on FA’s Query Builder
Dong Shin 06.24.2013
- continue working on FA
- rearranged Type
- working on mapping of COGNOS data -done!
- fixed Total Budget in Project Mgmt panel
- working on Query Builder
Dong Shin 06.20.2013
- VizTool meeting – in Requirement’s Bugs, Stuffs page
incorrect Total in Project Mgmt panelEA mappings to contracts disappearing on Data Uploadmove Type field from Project Info to Req in Project Editor- rework Add New ComboBox
- set it to blank on new
- update Sub Budget Center Names in the database
- auto-fill from COGNOS data upload
- Reported FACTS Obligated
- Outlay $ (Reported in FACTS)
- continue working on FA
- working down the list from today’s meeting
- working on fixing EA mapping to contracts
- moved Type field to Req
- query to update budget_center tables from projects table
- UPDATE budget_centers c1 INNER JOIN ( SELECT p.type as p_type, c.uid as budget_center_id FROM projects p, budget_centers c WHERE p.uid = c.project_id) T ON c1.uid = t.budget_center_id SET type = T.p_type

You must be logged in to post a comment.