10:00 – 5:00

• Demo for Pat
• Deployed
• Things to do:
  • Changes search from ‘==’ to ‘contains’ – done
  • Clear checks on new table selected – done
  • Add documentation button back
  • see how to do combinations of “and” and “or” in googleSQL
• Timesheet!

7:30 – 4:00

• Deployed
• Working on QueryBuilder. Also need to stop sending the full response over from the server and only send the discrete response
• Finished QueryBuilder- now QueryBuilderBase. AdvancedQueryBuilder extends base. So QueryBuilder and AdvQueryBuilder should be deleted. Going to do that after the demo on Monday.
• Set up a demo at S2F for Monday at 11:30

8:00 – 4:30

• Deployed. Uploaded and ingested a spreadsheet for Anne. It had some problems (duplicate columns and multiple worksheets) that had to be resolved. Also had a conversation with Mike C about HRMS data
• Talked to Dong about making more instructive error messages for ingest
• Email with Mike K. He’s going to be working on the layout manager
• Going to get the check marks to autopopulate  today. Maybe depricate QueryWidget
• Meeting with Anne – 2:00 – 4:00

7:30 – 4:00

• Deployed. There was a note from Anne about a slow query. After looking at the logs, it looked like it could have been a query that used columns that were no longer in the data. She’s going to try to rebuild the query and see if that affects performance.
• Talked to Dong about checking to see that columns exist before running the query. If they don’t then run the query in a degraded mode
• Talked to Dong about role management admin screen
• Working on putting column name checkboxes in AdvancedQueryBuilder – done
• Need to add a rollover to search – done
• Added Google Query Language Reference documentation to AdvancedQueryWidget

7:30 – 3:30

• Deployed data
• Working on search in AdvancedQueryWidget. Also did QueryWidget. Took a while to figure out how to set selected in a chart. Turns out you set the selected index of the series.
• Need to add column checkbox to ADG

7:30 – 4:00

• Deployed VIS1 & 2
• Talked to Mike C about putting “Current”, “stale” and “Obsolete” tags in a “Data Freshness” column in his data sources
• Sent a note of To Mike K about making a Pat display
• Talked to Dong about roles
• Caught up with Brian and Clift.
• AdvancedQueryWidget
  • Put new where clauses immediately after “where” – done
  • Add implicit “select”? – still thinking about this
  • Added the ability to set the query in the builder from an AdvancedQueryWidget
  • Getting loading and saving working
  • Need to have “setQueryBuilder” also set the table name. This requires adding table to QueryStringEvent – done

7:30 – 4:00

• No meeting today – put off until next week sometime
• Showed Anne the new stuff – her suggestions:
  • Have an indication in the chart as to what columns is being displayed
  • Populate the QueryBuilder from the loaded chart so that additional queries, based on the current query can be performed
• Back to AdvancedQueryWidget.
  • Got the date grid part working
  • Need to match up data types from the google types->primType->ColumnInfoObject
  • Integrating charts – things are displaying properly.
  • Need to get AdvancedQueryWidget to save and load properly
  • Need to change AdvancedQueryWidget so that the “and” clauses are inserted immediately after the where. See line 119 for details.

8:00 – 4:00

• Prepping for 10:00 meeting
  • There will be some kind of follow up meeting where I bring in a laptop to evaluate responses
  • Add search box for Inez. Done, but not wired to the datagrid/dataprovider highlighting yet
  • Didn’t get to AdvancedQueryWidget at all today. Try again tomorrow
• Stuff for Mike
  • Need a layout that has the query builder open with the appropriate boxes checked
  • Cascade layout should put panes back in their saved xy positions in addition to size
  • Column ordering is not saved (does not load in saved order)
  • Vertical scroll layout should adjust so that QueryBuilder does not obscure

7:30 – 5:30

• Deployed at the fort. Told Kathy W. and John W. that we’d have a better interface in about two weeks. Meeting tomorrow at 10:00
• Helped Dong fix his project
• Added user info to all remote object queries
• Back to advanced query widget
• Got most of the pieces put together. Need to extend QueryWidgetBase to AdvancedQueryWidget, and deal with columns and saving/loading

out sick

8:00 – 4:00

• Clear fluids today! Wheee!
• Deployed at the fort. Combined now ingests in a few seconds. Talked to Mike C about various issues. Tuns out that there was a bug in Mike’s code that generated spurious entries in the xml table.  The upshot is that we’ll wait to see how Anne likes the new data
• Talked to John W. He’s like a not from Brian about our burn rate and how it gets us through to October
• Working on Advanced Queries. Just realized that there is no equivalent for mySQL “discrete”. Goint to have to figure out a workaround. Not only that, but advanced queries can’t be the same as “normal” if this is the case. Hmmmm. Fixed by putting rows in a HashMap with their string values as the key

• Working on QueryInfoObject – finished the java side, mostly done on the flex side
• Started advanced tab in querybuilder – got to the point that A query is sent and the results come back and are visible in the debugger. For Monday, start transitioning over queryWidgets to use the google format and replace the whereClause code
• Talked to Anne for a while about the source for the combined.xml file. She’s going to talk to Mike C.

• Deployed data at the fort
• Started getting classification working. Managed to break the server (the jblocks jar is needed) so we punted for a while
• Lunch for Mike
• Working on getting the google API integrated
• Select Al button in Query builder is broken

• Deployed data at the fort
• There was a problem with the spreadsheet that we had uploaded. Fixed
• Got the google Visualzation data API working
• Walked Ines through how Vis2 works