Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Sign up

Sign up | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

No permission to create posts
sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
Create Person Group - respartyseq
September 28, 2010
3:00 am
Avatar
Robert
Member
Members
Forum Posts: 11
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Hello,

I'm trying to create Person Groups using webservices.

One of the fields Maximo insists I fill in is the sequence - respartyseq.

 

But I'm not really interested in this field, especially in the future when I'll be adding more users to the group.

 

Is there any way of telling Maximo "just add one to the highest existing sequence"?

I'd like to avoid using code or SQL as much as possible - just the regular MXPersonGroup Web Service.

 

Thanks,

Robert

September 28, 2010
8:16 am
Avatar
Chon
Stoneham, MA USA
Admin
Forum Posts: 1090
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

Hello, Please register to see the Admin's answer!

September 30, 2010
12:16 pm
Avatar
Robert
Member
Members
Forum Posts: 11
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Ouch...

 

So nothing is ready out of the box then 🙁

 

I'll give it a try.

 

Thanks.

October 1, 2010
12:23 pm
Avatar
david_grimes
New Member
Members
Forum Posts: 1
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

you may need the following:

 

update maxattribute set restricted=1 where objectname='xxx' and attributename='yyy';

update maxattributecfg set restricted=1 where objectname='xxx' and attributename='yyy';

commit;

 

NOTE: Use this for cases where you need the system to use the seq value that's automatically generated by the database (and the MIF is requiring a value to be provided within the data coming into the system).  For custom tables, the restricted flag can be set at the time the table is originally created.

October 1, 2010
1:06 pm
Avatar
Chon
Stoneham, MA USA
Admin
Forum Posts: 1090
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

Hello, Please register to see the Admin's answer!

October 1, 2010
4:47 pm
Avatar
Robert
Member
Members
Forum Posts: 11
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

So because I set the fields to restricted, Maximo knows that it needs to invent values for them?

 

How is the business logic for the values of the fields defined?

 

I mean, how does Maximo know that respartyseq needs to advance by one for each person?

October 2, 2010
11:47 am
Avatar
Robert
Member
Members
Forum Posts: 11
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

I've found this http://www.ibm.com/developerwo.....dID=272720 which seems to have the answer to my question.

 

Haven't had a chance to do any testing myself yet, I'll keep you informed.

Robert

October 4, 2010
2:06 am
Avatar
Robert
Member
Members
Forum Posts: 11
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Doesn't work...

 

The autonumber field for RESPARTYSEQ is empty and greyed out, I can't add a sequence for it.

Any other ideas?

October 4, 2010
8:50 am
Avatar
Chon
Stoneham, MA USA
Admin
Forum Posts: 1090
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

Hello, Please register to see the Admin's answer!

October 5, 2010
3:12 am
Avatar
Robert
Member
Members
Forum Posts: 11
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Chon said:

Have you tried creating your own object yet?


I created a new object, by duplicating the migration manager object and changed "consumed" to integration instead of migration.

 

I kept the same java class.

October 5, 2010
7:33 am
Avatar
Chon
Stoneham, MA USA
Admin
Forum Posts: 1090
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

Hello, Please register to see the Admin's answer!

October 5, 2010
7:46 am
Avatar
Robert
Member
Members
Forum Posts: 11
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

🙂

 

My ultimate goal is to create Persons, Persongroups, Users & Usergroups through webservices.

 

Thanks.

October 5, 2010
8:02 am
Avatar
Chon
Stoneham, MA USA
Admin
Forum Posts: 1090
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

Hello, Please register to see the Admin's answer!

October 5, 2010
8:16 am
Avatar
Chon
Stoneham, MA USA
Admin
Forum Posts: 1090
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

Hello, Please register to see the Admin's answer!

October 5, 2010
8:40 am
Avatar
Robert
Member
Members
Forum Posts: 11
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Yes, certainly.

It's a very useful post.

 

I am creating all these objects with webservices, I simply have a few problems with specific things like the sequence numbers in PersonGroup.

 

Robert

October 5, 2010
10:30 am
Avatar
Chon
Stoneham, MA USA
Admin
Forum Posts: 1090
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

Hello, Please register to see the Admin's answer!

October 5, 2010
10:39 am
Avatar
Robert
Member
Members
Forum Posts: 11
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Thanks Chon,

But like I said, I've gotten past that stage.

 

I can create PersonGroups without any trouble. The problem is that I have to put the value of respartyseq into the XML.

I'm trying to avoid that and let the system autonumber the sequence for me.

October 5, 2010
12:15 pm
Avatar
Chon
Stoneham, MA USA
Admin
Forum Posts: 1090
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

Hello, Please register to see the Admin's answer!

October 5, 2010
3:45 pm
Avatar
Robert
Member
Members
Forum Posts: 11
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

I tried that too, but I'm worried about the null value.

 

Doesn't the sequence number have any meaning?

Won't there be problems down the line?

 

I'd rather not go into writing Java...

October 5, 2010
4:02 pm
Avatar
Chon
Stoneham, MA USA
Admin
Forum Posts: 1090
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

Hello, Please register to see the Admin's answer!

No permission to create posts
Forum Timezone: America/New_York

Most Users Ever Online: 54

Currently Online:
1 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

sun kim: 60

madd0g17: 59

v.barsamov: 51

Maximofresher: 44

cgregory: 42

matta0990: 33

Member Stats:

Guest Posters: 0

Members: 13573

Moderators: 0

Admins: 3

Forum Stats:

Groups: 1

Forums: 8

Topics: 1528

Posts: 4195

Newest Members:

Alan Drake, Ibrahim Abdalla, denwercarlyson, workspaceboyyy, kennylittleboy, Lori Wilson

Administrators: Chon: 1090, kristensibilia: 0, Joe Grassia: 0