Custom Query (73 matches)

The current advanced inventory search is good for getting very specific but is too complicated for general searching. A quick search with one or two input fields is badly needed.

The input text should be used to search:

• Part name
• Description
• Comment
• Location
• Asset
• AssetSubItem

Test thoroughly and upgrade.

Grails-1.3.5 has a bug where the dev war is not generated correctly, this is a blocker for us and we must wait for Grails-1.3.6 to be released.

Grails-1.3.7 now available so going to that.

Checking versions and bug reports in plugins:

• ​http://jira.grails.org/browse/GPFILTERPANE-5 confirmed as mostly solved in gnuMims (between 2nd date still not).
• ​http://jira.grails.org/browse/GPACEGI-41 work around applied r887. A Geb regression test might be smart.

Functionality:

• List paginate, sort and max results per page working.
• Reports all working in grails runApp.
• All tests passing.

Issues:

• Reports JasperController class not found exception for commons-digester (deployed war), fixed in r903
• Need to check all dependencies, fixed in r902 - r906.
• Export plugin is having some issues, fixed in r911.

Schema upgrade:

• alter table image add constraint UN_pictureid_size unique (picture_id, size);

All the manufacturer*, averageDeliveryTime and alternateItems fields are hardly used and can be removed. The alternateItems may be removed as the inventory text search is now very good.

Data and fields can simply be dropped.

The spareFor will be retained for now.