Hi,
I'm looking for some help getting started with building stored procedures for TNEW custom fields vs sending them to CSI.
Having trouble getting started and not finding much documentation on this, I don't know what variables are sent to the procedure from TNEW, like session key, order number, etc.
Like for instance LRP_TNEW_GET_ORDER_CONTRIBUTIONS is a stored procedure that looks up order info, so if I have TNEW run that stored procedure, will it send it the order number?
Anyone have any examples of something simple, like using a stored procedure in a custom from field to update an attribute in a constituent record or something like that?
Thanks in advance for any help!
Mark
Hi Mark,
I have a process which accepts data from fields set up in LTR_TNEW_CUSTOM_FORM_DATA . For a particular production, the purchaser is required to answer 6 questions - the stored procedure then inserts the responses into a local (ie custom) table for reporting. For clarity, we are on RAMP running Tessitura v15.1 and TNEW v7.40
Feel free to email me directly at martin.keen@nida.edu.au if you want to discuss this more.
Martin