Using a link field in criteria for calendar SQL.

Discuss your general Proclaim related queries here.
Post Reply
Posts: 4
Joined: Fri Nov 30, 2018 9:22 am
Has thanked: 1 time

Using a link field in criteria for calendar SQL.

Post by ts-nephos » Wed Dec 12, 2018 11:28 am

I have a table in my Main case type and would like to display records in this table within a calendar in the my Main case type, i.e. the same case. I've created a case for each record in the table, of an Alternate case type with a link field linking back to the Main case.

I've created a SQL search to run against the Alternate case type and find cases where the link field is equal to the Main case number. I have then added this SQL to the calendar.

The calendar is currently showing a singular case of the Alternate case type which has no link value. Adding a link value to that singular case removes it from the calendar. It's because of this that suggests to me the SQL is not correctly working.

My criteria is: "Main case type LINK TO Alternate case type.Alternate case type LINK TO Main case type.Link Case Ref" is equal to the "case.key" of the Main case type. Am I able to use a link field, from a linked case type, as part of my criteria?

Post Reply