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

[Toni Rikkola (JIRA)]

     [ https://issues.jboss.org/browse/JBRULES-2890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Toni Rikkola updated JBRULES-2890:
----------------------------------

    Assignee:     (was: Mark Proctor)


> 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
>            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