Thanks I will go through it . On Sun, Aug 27, 2017 at 12:51 AM, Jacques Le Roux < [email protected]> wrote:
> Those are actually numbers represented as strings, see fieldtypederby.xml > as an example (look for id) > > That's why Renuka's answer is correct > > Jacques > > > > Le 26/08/2017 à 12:08, Rajesh Mallah a écrit : > >> Hi Renuka , >> >> Creating the Party Group was not the problem. >> The problem was that i was not able to search the created group using >> XMLRPC. >> >> When we leave group id empty it auto generates it , so IMHO its not >> correct to say "partyID cannot be the digit" >> >> I was able to search the groups on specifying the id as string type during >> making the request >> using XMLRPC. >> >> Now my issue is solved. >> >> >> regds >> mallah. >> >> >> >> >> >> >> On Sat, Aug 26, 2017 at 3:23 PM, Renuka Srishti < >> [email protected]> >> wrote: >> >> Hello Rajesh, >>> >>> There are 2 ways to create party group: >>> 1. If you do not enter any specific ID, it will work. >>> 2. When you create party group with ID as the digit, it shows an error >>> that >>> you can not create party group, partyId can not be the digit. >>> Alphanumeric >>> is reserved for this. Hence part group is not created, that's why its not >>> showing any result on search. >>> >>> Thanks >>> Renuka Srishti >>> >>> On Sat, Aug 26, 2017 at 1:43 PM, Rajesh Mallah <[email protected]> >>> wrote: >>> >>> observation: >>>> >>>> On passing 10000 as string by qualifying the type in XML things work as >>>> expected. >>>> >>>> Eg: below works ( <value><string>10000</string></value> ) >>>> >>>> REQ >>>>>>>>> >>>> <methodCall><methodName>findPartiesById</methodName>< >>>> params><param><value><struct><member><name>login.username</ >>>> name><value><string><![CDATA[admin]]></string></value></ >>>> member><member><name>login.password</name><value><string> >>>> <![CDATA[ofbiz]]></string></value></member><member><name> >>>> idToFind</name><value><string>10000</string></value></ >>>> member></struct></value></param></params></methodCall> >>>> >>>> and >>>> >>>> below ( <value><i4>10000</i4></value> ) does not. >>>> >>>> >>>> REQ >>>>>>>>> <?xml version="1.0" encoding="UTF-8"?> >>>> REQ >>>>>>>>> >>>> <methodCall><methodName>findPartiesById</methodName>< >>>> params><param><value><struct><member><name>login.password</ >>>> name><value><string><![CDATA[ofbiz]]></string></value></ >>>> member><member><name>idToFind</name><value><i4>10000</i4></ >>>> value></member><member><name>login.username</name><value>< >>>> string><![CDATA[admin]]></string></value></member></ >>>> struct></value></param></params></methodCall> >>>> >>>> >>>> IMHO the conversion of 10000 to 10,000 in backend is causing the >>>> >>> problem >>> >>>> . >>>> I am not sure if there is a scope of improvement or application >>>> >>> programmers >>> >>>> should >>>> be more careful by explicitly sending qualified types. >>>> >>>> regds >>>> mallah. >>>> >>>> >>>> >>>> On Sat, Aug 26, 2017 at 1:19 PM, Rajesh Mallah <[email protected] >>>> > >>>> wrote: >>>> >>>> I think i caught it , >>>>> >>>>> The problem is occurring only for numeric id. When i explicitly >>>>> >>>> specify >>> >>>> a >>>> >>>>> alphanum >>>>> id in creating a new party group then the problem is not there. >>>>> >>>>> This is supported by the kind of sqls being created also : >>>>> ( note the where clause ) i had specified partyID as '10000' not sure >>>>> >>>> if >>> >>>> its' derby specific. >>>>> >>>>> 2017-08-26 13:10:23,767 |http-nio-8080-exec-1 >>>>> |GenericDAO |T| Ran query in 1 milli-seconds: >>>>> EntityName: Party Sql: SELECT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID, >>>>> PREFERRED_CURRENCY_UOM_ID, DESCRIPTION, STATUS_ID, CREATED_DATE, >>>>> CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, >>>>> DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, >>>>> CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.PARTY WHERE ((PARTY_ID = ?)) >>>>> where clause:[PARTY_ID=10,000] >>>>> >>>>> >>>>> Does it qualify to be a BUG ? >>>>> I think the ramifications are severe as most application developers >>>>> >>>> would >>> >>>> like >>>>> system to auto generate IDs for them. >>>>> sw@development:~/Ofbiz/XML_RPC_SCRIPTS$ perl test-xmlrpc.pl 10000 >>>>> \ { >>>>> partiesFound [], >>>>> party undef >>>>> } >>>>> sw@development:~/Ofbiz/XML_RPC_SCRIPTS$ >>>>> sw@development:~/Ofbiz/XML_RPC_SCRIPTS$ >>>>> sw@development:~/Ofbiz/XML_RPC_SCRIPTS$ >>>>> sw@development:~/Ofbiz/XML_RPC_SCRIPTS$ perl test-xmlrpc.pl MyID1000 >>>>> \ { >>>>> partiesFound [], >>>>> party { >>>>> createdByUserLogin "admin", >>>>> createdDate "20170826T13:12:47", >>>>> createdStamp "20170826T13:12:47", >>>>> createdTxStamp "20170826T13:12:47", >>>>> dataSourceId undef, >>>>> description undef, >>>>> externalId undef, >>>>> isUnread undef, >>>>> lastModifiedByUserLogin "admin", >>>>> lastModifiedDate "20170826T13:12:47", >>>>> lastUpdatedStamp "20170826T13:12:47", >>>>> lastUpdatedTxStamp "20170826T13:12:47", >>>>> partyId "MyID1000", >>>>> partyTypeId "PARTY_GROUP", >>>>> preferredCurrencyUomId "USD", >>>>> statusId "PARTY_ENABLED" >>>>> } >>>>> } >>>>> >>>>> Regds >>>>> mallah >>>>> >>>>> >>>>> On Sat, Aug 26, 2017 at 1:00 PM, Rajesh Mallah < >>>>> >>>> [email protected]> >>> >>>> wrote: >>>>> >>>>> Hi Renuka , >>>>>> >>>>>> Thanks for Response , My Steps are as follows >>>>>> >>>>>> (1) load seed,seed-initial,demo >>>>>> (2) login to Ofbiz , using web ui and create a PartyGroup via >>>>>> Application > Party > New Party Group >>>>>> (3) execute findPartiesById using RPC eg: >>>>>> https://cwiki.apache.org/confluence/display/OFBIZ/Using+ >>>>>> XMLRPC+as+an+alternative+to+SOAP >>>>>> >>>>>> ( I use perl or the same https://pastebin.com/raw/UwLNq5AT ). >>>>>> >>>>>> (4) With new company ID the service findPartiesById does not return >>>>>> >>>>> any >>> >>>> data , whereas for old data like 'Company' >>>>>> it does return.. >>>>>> >>>>>> the problem seems to be with XMLRPC method only , as executing the >>>>>> service via >>>>>> Framework Web Tools > Run Service works fine for all PartyId. >>>>>> >>>>>> regds >>>>>> mallah. >>>>>> >>>>>> >>>>>> >>>>>> On Sat, Aug 26, 2017 at 12:42 PM, Renuka Srishti < >>>>>> [email protected]> wrote: >>>>>> >>>>>> Hello Rajesh, >>>>>>> >>>>>>> Can you mention the steps you followed? As I have tried and its >>>>>>> >>>>>> working >>> >>>> fine. >>>>>>> >>>>>>> Yes, here I can see one improvement that after creating any party, we >>>>>>> redirect to view profile and UI of this screen need some improvement. >>>>>>> >>>>>> The >>>> >>>>> message was shown there is not correct. >>>>>>> >>>>>>> Thanks >>>>>>> Renuka Srishti >>>>>>> >>>>>>> On Sat, Aug 26, 2017 at 12:19 PM, Rajesh Mallah < >>>>>>> >>>>>> [email protected] >>>> >>>>> wrote: >>>>>>> >>>>>>> Hi >>>>>>>> >>>>>>>> We have an instance using the stock demo,seed,seed-initial data. >>>>>>>> All the PartyGroups imported via demo are searchable using >>>>>>>> web service method findPartiesById . >>>>>>>> >>>>>>>> However when we create a Party Group by the UI and search >>>>>>>> using same process the result is nil. >>>>>>>> >>>>>>>> the RPCXML conversation is here: >>>>>>>> >>>>>>>> https://pastebin.com/1LB9BCFd >>>>>>>> >>>>>>>> am i missing anything ? >>>>>>>> >>>>>>>> >>>>>>>> regds >>>>>>>> mallah. >>>>>>>> >>>>>>>> >>>>>> >
