Custom Screen Help

In the query or procedure that serves as the datawindow datasource, you need to make sure that you are filtering for the current constituent ID (customer_no).  In a SQL Query, you can use the parameter @id_key like this:

Select some, columns, that, you, use, for , your, custom, screen

From LT_MY_CUSTOM_TABLE

Where customer_no = @id_key

I am trying to create my first custom screen for staff information.  I have created the local table, the Infomaker report and have configured TR_Custom_Tab.  However, I am missing something, because my custom tab now shows ALL of the table entries on the new custom screen, instead of only the information for the constituent record I am looking at.  I’m sure this is something simple that I need to adjust either in my stored procedure or report.  Can someone tell me how to limit the info displayed on the custom screen to only the data that matches the constituent id on the record I am viewing?

Thanks in advance,

Penny Tabor

IT Manager

Midland Center for the Arts

Midland, MI 48640

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

In the query or procedure that serves as the datawindow datasource, you need to make sure that you are filtering for the current constituent ID (customer_no).  In a SQL Query, you can use the parameter @id_key like this:

Select some, columns, that, you, use, for , your, custom, screen

From LT_MY_CUSTOM_TABLE

Where customer_no = @id_key

I am trying to create my first custom screen for staff information.  I have created the local table, the Infomaker report and have configured TR_Custom_Tab.  However, I am missing something, because my custom tab now shows ALL of the table entries on the new custom screen, instead of only the information for the constituent record I am looking at.  I’m sure this is something simple that I need to adjust either in my stored procedure or report.  Can someone tell me how to limit the info displayed on the custom screen to only the data that matches the constituent id on the record I am viewing?

Thanks in advance,

Penny Tabor

IT Manager

Midland Center for the Arts

Midland, MI 48640

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!