[jboss-jira] [JBoss JIRA] Created: (JBRULES-2890) Enumerated Values Via Query

[Brad Davis (JIRA)]

Enumerated Values Via Query
---------------------------

                 Key: JBRULES-2890
                 URL: https://issues.jboss.org/browse/JBRULES-2890
             Project: Drools
          Issue Type: Feature Request
      Security Level: Public (Everyone can see)
          Components: drools-guvnor
    Affects Versions: 5.1.1.FINAL
            Reporter: Brad Davis
            Assignee: Mark Proctor
            Priority: Optional


When creating the Rules Fact Model, it would be helpful to be able to define a query and datasource to enumerate possible values for a given field.  An example of the usefulness would be for ICD Codes for healthcare.  By annotating a fact model field with Datasource and Query information, we could provide auto-complete / enumeration for a given field in the UI.  

public class ICD9Code {
   @org.jboss.brms.ui.validators.DatabaseEnumerator(
     datasource="ExampleDS",
     query={"select field from some table where field like '{value}%"')
   private String code;
   ...
}

As the user starts to type in the BRL UI, we could then perform a query on the underlying datasource to autocomplete the annotated field.  For large datasets, this would decrease the entry time significantly for the business users, while also ensuring that users are adhering to known business values.


This would also be useful for zip codes, states, etc.

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira