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.
