TIMSS 6: Adding views to the Search Screen

In TIMSS 6, you can add views to the APPQUERYSEARCH screen. First create the views you want to search with. Make sure the view includes the MASTER_CUSTOMER_ID and SUB_CUSTOMER_ID.

Next use Extender to add to the OnOpening event of the screen you want to add the view to the search. If that's CUS001, then the code would look like this:

Public Sub CUS001C_OnOpening ( ByRef MyForm As Object)

MyForm.SearchViewNames =
“Cus_Address_Alias_C_VW,Cus_OSR_Relationships_VW,
Cus_ISR_Relationships_VW,Cus_Proj_Mgr_Relationships_VW”

End Sub


Applies to: TIMSS6

Google Maps

So you've added a Google search button to a screen to search for a customer. Want to get launch Google Maps from within TIMSS/Personify? Do the same thing (launch a browser window) only pass the address in the URL string.

http://maps.google.com/maps?f=q&hl=en&q=1919+gallows+rd+22182

The information in the URL above after "q=" is the address we are querying on with pluses instead of spaces.

Want directions? Then you’d use the start address (SADDR) and destination address (DADDR) to pass both addresses.

http://maps.google.com/maps?f=d&hl=en
&saddr=1919+gallows+rd+22182
&daddr=1600+Pennsylvania+Ave+NW+20006

Applies to: TIMSS6 & Personify

Logging TCMS Users

This one comes from my replacement at COF: Russ, but I've heard requests for this functionality at TAUG.

So you want to track customer logins to TCMS, but the only information stored in the WEB_USER table is their last login. If you put a trigger on that table to populate a log table (or even CUS_ACTIVITY) every time the last login time changes, you've done it as this field is updated every time the customer logs in.

Not only can you track the logins, but using the same methodology you can track changes to user names and passwords also stored in that table. You can also track the MODOPER to see who made the change: the customer or a staff member.

Applies to: TIMSS6 & Personify