You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@ofbiz.apache.org by "Jacques Le Roux (Jira)" <ji...@apache.org> on 2020/03/10 12:48:00 UTC

[jira] [Commented] (OFBIZ-11447) Default search/find option for pk as integer generates an error

    [ https://issues.apache.org/jira/browse/OFBIZ-11447?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17055909#comment-17055909 ] 

Jacques Le Roux commented on OFBIZ-11447:
-----------------------------------------

While at it I want to add something about "Why primary keys are VAR_CHAR type in OFBiz?" 
It was answered here https://markmail.org/message/skomgdz4ubpjieb3 and [there is even en entry in the FAQ for that|https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-primaryKeysAreVAR_CHARType]


> Default search/find option for pk as integer generates an error
> ---------------------------------------------------------------
>
>                 Key: OFBIZ-11447
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-11447
>             Project: OFBiz
>          Issue Type: Bug
>          Components: framework/webtools
>    Affects Versions: Trunk
>            Reporter: Pierre Smits
>            Priority: Major
>              Labels: find, search
>         Attachments: WebtoolsErrorSearchForInteger.rtf
>
>
> When a entity is defined with having an integer field as the primary key, the default search/find option in the search form is the 'Contains' option. 
> Using this, with a integer value entered, an error is generated, like in attached WebtoolsErrorSearchForInteger file.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)