2 weeks ago - PA shared the list of files and data regarding particular files
Joseph pulled up his screen to illustrate where it stands today. Background:
There is a table now with stat data
1 column for each code on the stat record
Around 100 records
Just working with a small sample for the purposes of development.
Wrt SDMA: they have added the ability to search and filter on columns.
Some issues have arisen from trying to filter more than one column at a time. On this note: Peter verified that it is indeed a requirement. Those present: yes, it is.
On this note Peter's team will find a way to make this happen.
Clarification of which criteria are used to filter. Joseph: some data types may be different. Current components:
Contains
Equals
Starts with
Ends with
Is Empty
Is Not Empty
Is Any of
Should be sufficient for string values. Clarification among attendees: criteria need to be more specific - e.g., filtering against x error code for y amount, for z dollar range. Noted in meeting that the drop-downs can be used for this purpose. Currently set up per: Column/Operator/Value.
Noted that it isn't possible to filter out multiple column headings per excel. However it is possible to keep adding additional filters.
Peter does intend to add numerical filters however to provide broader capability.
Decision: for now they will start with "And" and then add sublines. "Or" will probably not be needed. Many will be = or greater than or lesser than, or contains (to search for something in the middle of the string. Nulls and blanks as well, and ranges (combinations of less than and greater than). Operators can be easily built as general purpose selectors.
AAIS is trying very hard to make the application free. Most of the out of box grid components tables such as this give everything away for free except for the components used for enterprise settings.