The following steps assume the following components are ready to roll:
Properties may have a record in the cecase table with its boolean flag called propertyinfocase set to true.
The propertyinfo case associated with the property includes one or more events for display on the property's profile
Goal: Integrate property info case data into properties.xhtml such that we can search for properties by attribute and see case events associated with the attributes we desire.
Proposed steps
Study the method searchForProperties in PropertyIntegrator and internalize how it builds the SQL statement for queries based on the boolean flags contained inside the SearchParamsProperty object. Note that the SearchParamsProperty has "useXXX" flags and associated member variables for the values to search. They always exist in pairs such the user doesn't need to specify params for attributes they don't care about. For example, the "filterByUseType" flag is used to tell the searchForProperties method whether or not to include a clauaaaaaase that will specify a key in the propertyusetype table.
Adjust the SELECT statement embedded in searchForProperties to include one or more JOIN clauses in the FROM section of the statement
The following steps assume the following components are ready to roll:
Goal: Integrate property info case data into properties.xhtml such that we can search for properties by attribute and see case events associated with the attributes we desire.
Proposed steps