Kuali Rice Development
  1. Kuali Rice Development
  2. KULRICE-10221

KRAD Component Suggest doesn't return results from db table

    Details

    • Type: Bug Fix Bug Fix
    • Status: Closed Closed
    • Priority: Major Major
    • Resolution: Duplicate
    • Affects Version/s: 2.4
    • Fix Version/s: 2.4
    • Component/s: Development, JPA
    • Security Level: Public (Public: Anyone can view)
    • Labels:
      None
    • Environment:
      Trunk, running locally, using mysql
    • Similar issues:
      KULRICE-10071KRAD Component Suggest - Some examples don't suggest based on examples given
      KULRICE-10400Many of the suggest configurations not returning results
      KULRICE-10531a6-sub not returning suggestion.
      KULRICE-12014KRAD Library- Widgets - Suggest not working properly
      KULRICE-8565Collection table starts not displaying after returning from a controller called dialog.
      KULRICE-9969KRAD Kitchen Sink Navigation select Uif Component navigation Uif Component View results in blank page
      KULRICE-12012Parameter Lookup - Selecting a component from search results does not populate “Component” search criteria field
      KULRICE-7592Suggest query not working correctly with custom service method
      KULRICE-10595Library widgets suggest examples not working
      KULRICE-12393KRAD - Many-To-Many multiselect doesn't work with CustomCollectionEditor
    • Rice Module:
      KRAD
    • Sprint:
      2.4.0-m2 Sprint 2
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required
    • Code Review Status:
      Not Required
    • Include in Release Notes?:
      Yes

      Description

      The KRAD suggests that connect to database tables aren't working in the KRAD sample app. The SQL generated as changed.

      For example prior:

      SELECT ... WHERE UPPER(A0.acct_type) LIKE 'CA%'

      now it is:

      SELECT ... WHERE ACCT_TYPE LIKE 'CA*'

        Issue Links

          Activity

          Hide
          Jonathan Keller added a comment -

          This looks like a change to the lookup service - something with treating fields as literals. I've never set that. Maybe a default changed somewhere...

          Show
          Jonathan Keller added a comment - This looks like a change to the lookup service - something with treating fields as literals. I've never set that. Maybe a default changed somewhere...
          Hide
          Jonathan Keller added a comment -

          No - it seems that on one of the KRAD views defined in the sample application, that particular field's wildcard support was turned off:

          ./rice-framework/krad-sampleapp/src/main/resources/org/kuali/rice/krad/labs/LabsLookupViews.xml:184: <bean parent="Uif-LookupCriteriaInputField" p:propertyName="number" p:disableWildcardsAndOperators="true"/>

          Show
          Jonathan Keller added a comment - No - it seems that on one of the KRAD views defined in the sample application, that particular field's wildcard support was turned off: ./rice-framework/krad-sampleapp/src/main/resources/org/kuali/rice/krad/labs/LabsLookupViews.xml:184: <bean parent="Uif-LookupCriteriaInputField" p:propertyName="number" p:disableWildcardsAndOperators="true"/>
          Hide
          Jonathan Keller added a comment -

          huh - I see the problem now.

          It looks like something is not as we expected JPA to handle it based on this code/comment:

                  } else if (p instanceof LikePredicate) {
                      //no need to convert * or ? since ojb handles the conversion/escaping
                      addLike(parent, pp, value);
          
          Show
          Jonathan Keller added a comment - huh - I see the problem now. It looks like something is not as we expected JPA to handle it based on this code/comment: } else if (p instanceof LikePredicate) { //no need to convert * or ? since ojb handles the conversion/escaping addLike(parent, pp, value);
          Hide
          Adam Campbell (Inactive) added a comment -

          closed as duplicate - text from this jira has been incorporated into KULRICE-10595

          Show
          Adam Campbell (Inactive) added a comment - closed as duplicate - text from this jira has been incorporated into KULRICE-10595

            People

            • Assignee:
              Jonathan Keller
              Reporter:
              Jeff Ruch
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 3 hours
                3h
                Remaining:
                Remaining Estimate - 3 hours
                3h
                Logged:
                Time Spent - Not Specified
                Not Specified

                  Agile

                    Structure Helper Panel