Skip to main content

I'm trying to create an advanced SmartObject Method that can read data from one SmartObject, and combine that information with input parameters to create a new record in another SmartObject:

 

Table1 -> (transform) -> Table 2.

 

I can sucessfully read the information from Table1, and this data is set in the smart object properties, however the write method in table 2 writes null values for every field. 

 

I need this to be able to record the State of Table 1 at the time of certain transactions for reporting purposes. Is this going to be possible without writing a custom service broker?

 

I guess the service object methods will be something like...


1. Table1.Read


2. StoredProc.Execute


3. Table2.Write


 


Perhaps step 2 is returning empty results? 


 


The problem has been worked around temporarily. Instead of trying to do the read and create in one smart object call, we have now added two steps in each action. The first step creates a reference to the smart object, the second step saves the result. 

 

Long term we are going to write a customer service object to make it easier for developing these WF's. The number of clicks with the work-around is significant. 


Reply