Question

Database archeology from V 7.2.1 - What does SearchJoinsToc in tstr do?

Version 7

Updated June 10, 2014

asked on June 10, 2014

Here's a blast from the past, for the old schoolers out there.

In the V 7.2.1 database structure, there is a column, tstr.SearchJoinsToc, which takes a T/F value.

Our understand is that this value will allow, or not, for fields in different templates to be added to a search results list, even when a different template is searched.

Example:

Template A has a Field called "Name" and Template B has a field called "Name"

If I search Template A for the Name field, and if SearchJoinsToc is true, SQL tracing indicates that the Name field from Template B will also be processed in the background, via a Union statement. Can we confirm if that is the case?

Further, does SearchJoinsToc also come into play when selecting columns for display? We are asking because we are now getting SQL errors (7050) when we try to add columns.

Or put another way, can we get the official LF explanation for the role of this column, what it does when True and what it does when False? Thanks -

0 0

Answer

APPROVED ANSWER

replied on June 10, 2014

In the TOC table, there is a column for TemplateId. This indicates which template is associated with which entry. Similarly, in the TDx tables (each table is for a single template), there is a column for TocID which lists which field values belong to which entry.

In the TSTR table, if SearchJoinsToc is set to 'Y' then a search joins the TOC table to ensure the TemplateId matches. If 'N', then a search does not join the TOC and you will get all the entries in the corresponding TD table even if the TemplateId in the TOC doesn't match up to the search template. The template data will then be displayed in the search template.

As for the 7050 errors that occur, it may be because the corresponding TDx table that's being referenced may no longer exist in the database.

0 0

Replies

replied on June 10, 2014

Thanks, Alex -

So the value of 'Y' in SearchJoinsToc reduces the result set, while setting this to 'N' expands it?

Where would you use the 'N' option?

0 0

replied on June 10, 2014

You normally wouldn't use the 'N' option as it was for a specific DoD certification related process that just pertained to importing emails, setting metadata, and then being able to search for those entries.

0 0

You are not allowed to follow up in this post.

Question

Question

Database archeology from V 7.2.1 - What does SearchJoinsToc in tstr do?

Answer

Replies

Sign in to reply to this post.