Uploaded image for project: 'In-Portal CMS'
  1. In-Portal CMS
  2. INP-1826

Convert search/custom having filters into a where filters in grids

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.2.2-B3
    • Component/s: Database, Optimization
    • Labels:
      None

      Description

      1. in the "\kDBList::GetWhereClause" method use the "\kDBList::extractCalculatedFields" method on the HAVING clause from the "search" and "custom" filters and merge the results with the WHERE clause of these filters
      2. don't add the HAVING clause from the "search" and "custom" filters in the "\kDBList::GetHavingClause" method
      3. (refactoring) improve "\kDBList::extractCalculatedFields" method to immediately exit, when an empty SQL clause is given

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                alex Alex
                Reporter:
                alex Alex
                Developer:
                Alex
                Reviewer:
                Erik Snarski [Intechnic]
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 5h 1m
                  5h 1m