|
Search | Today's Posts | Mark Forums Read |
|
Thread Tools | Search this Thread |
|
|||
|
|||
A large number of assets were created with a default contract as a specific contract and not as a series contract.
There is nothing in the API documentation about how to set this. Looking at an Asset object in the debugger, I don't see anything related to contracts. In the raw database table for Assets I can see a CONTRACTRECID field, shows a normal contract RecID for a specific, and an asterisk-prefixed code that I presume is found in the BContractSeries table but I can't locate a matching record. Any advice will be much appreciated! |
|
|||
|
|||
Thank you for posting this.
Once the Contract Series is set to the Asset, field FLDASTCONTRACTID is populated with a value from Contract.SEQID field - prefixed with asterisk. The Contracts.SEQID (without the asterisk) equals to BContractSeries.SEQID. Hope this helps. |
|
|||
|
|||
Sure, will give it a try. My concern is that the query below yields six records that are all part of this series, as expected. So clearly it's a legit SeqID
select * from bcontracts where seqid = 'ZVDXHL6HO28AMPQ9VQ4H' However, this next query returns zero records and I was expecting to see exactly one. select * from bcontractseries where seqid = 'ZVDXHL6HO28AMPQ9VQ4H' I'll work on the API code this morning and hopefully it'll "just work" and I don't need to solve the mystery of the bcontractseries table. |
|
|||
|
|||
Got it, that makes sense.
Almost have this API code running but there's zero documentation on Contracts in the API references. I have successfully fetched a contract object and now need to extract the SeqID from it. There's no SeqID property on the object so I'll need the field name for the Get as illustrated below. SeqID = contract.GetFieldValue("??") If this actually is documented somewhere I'd be happy to go there and discover all of this. |
|
|||
|
|||
Success, I'm able to set assets with a specific contract to a series contract. This is based on running a series of single record test cases.
However, in a batch mode for some (not all) assets I get an error saying that the Type and Name fields are required when I call the asset.Save() method. Looking in the debugger, there are values for both in the asset object. This error is off-topic for this thread so let me know if I should create a new thread. |
«
Previous Thread
|
Next Thread
»
Thread Tools | Search this Thread |
|
All times are GMT -6. The time now is 02:25 AM.