Hi Friends,
I'm trying to build a custom output set for research notes. I have copied and pasted the fields as described in the Output set cookbook page 26 (the copy I have was last updated August 2013 and that's the newest version I could find).
I am able to add the parameter "Customer notes" in output set builder, but when I click on the ... button next to the parameter supposedly to choose the note type I get an error message and the application crashes.
Error message:
Application terminated
Error: Null object reference at line 1 in close event of object w_query_paramenter_entry
Anybody know what the error means, or what I should have done differently when setting this up?
Thanks,
Kanani
Hi, Kanani:
It looks as if you didn’t specify a parameter of Note Type.
Here’s what I have:
TR_QUERY_ELEMENT entry:
Description: Research Notes
Category: Research
Data Select: !.notes
Data From: (select a.customer_no, a.note_type, notes = dbo.FS_GET_CUST_NOTES(a.cust_notes_no) from vxs_cust_notes a)
Data Where: note_type in (<<p4>>)
Control Group: [whatever you like here]
Single Row: [leave unchecked]
Primary Group Default: [leave unchecked]
Make sure to replace the “4” in the Data Where field with the id of the parameter defined in TR_QUERY_ELEMENT_PARAMETER below.
TR_QUERY_ELEMENT_PARAMETER:
Note Type: Number
End of Day: [leave unchecked]
Multi Select: [leave unchecked]
Ref Tbl: VRS_CUST_NOTES_TYPE
Ref Id: id
Ref Desc: description
Ref Sort: inactive desc, description
Output Set Builder:
Add the Research Notes element; click the box with the ellipses to add the parameter of Note Type; save the output set as Notes-Note Type (replacing “Note Type” with the actual note type)
In List Manager, make a list of everyone with the note type you selected.
Works like a charm!
I haven’t tried to run this with Multi-Select enabled.
Lucie
______________________________Lucie SpielerIT Development and Training Manager
Florida Grand Opera