[MyQuery]
1973 "cpsimg9408" "Published Documents by Date Range" "Published Documents by Date Range"
[END]
[MyQueryTables]
1973 1974 1 "EACH" "UserDocuments" no 0
1973 1975 2 "EACH" "Users" no 0
1973 1977 3 "FIRST" "Person" no 0
1973 1979 4 "FIRST" "PublishedDocs" no 0
1973 1981 5 "EACH" "Student" no 0
1973 1983 6 "EACH" "bPerson" yes 0
1973 1985 7 "EACH" "usersUserType" no 0
1973 1987 8 "EACH" "UserType" no 0
[END]
[MyQueryWhere]
1973 "WHERE" "" "bPerson" "PersonSeq" "=" "Student" "personSeq" "" "" 1984 "" 1983 1
1973 "Where" "" "usersUserType" "PersonSeq" "=" "UserDocuments" "PersonSeq" "" "" 1986 "" 1985 1
1973 "WHERE" "" "Student" "StudentID" "=" "UserDocuments" "StudentID" "" "" 1982 "" 1981 1
1973 "Where" "" "UserType" "UserTypeSeq" "=" "usersUserType" "UserTypeSeq" "" "" 1988 "" 1987 1
1973 "AND" "" "PublishedDocs" "PublishDate" ">=" "" "" "08/01/2015" "" 2006 "" 1979 2
1973 "AND" "" "PublishedDocs" "PublishDate" "<=" "" "" "06/30/2016" "" 2007 "" 1979 3
1973 "Where" "" "Users" "PersonSeq" "=" "UserDocuments" "PersonSeq" "" "" 1976 "" 1975 1
1973 "Where" "" "Person" "PersonSeq" "=" "UserDocuments" "PersonSeq" "" "" 1978 "" 1977 1
1973 "WHERE" "" "PublishedDocs" "PublishedDocsSeq" "=" "UserDocuments" "PublishedDocsSeq" "" "" 1980 "" 1979 1
[END]
[MyQueryFields]
1973 1995 "Users" "UsersID" "" "x(8)" "User ID" no 3 0
1973 1996 "bPerson" "LastName" "" "x(15)" "Student Last Name" no 10 0
1973 1993 "PublishedDocs" "PublishDate" "" "99/99/99" "PublishDate" no 2 0
1973 1994 "UserDocuments" "FileName" "" "x(8)" "FileName" no 1 0
1973 1989 "UserDocuments" "Viewed" "" "yes/no" "Viewed" no 4 0
1973 1990 "Person" "LastName" "" "x(15)" "Last Name" no 5 0
1973 1991 "Person" "FirstName" "" "x(15)" "First Name" no 6 0
1973 1992 "UserDocuments" "TotalDownloads" "" ">>>>>>>>>9" "TotalDownloads" no 8 0
1973 1997 "bPerson" "FirstName" "" "x(15)" "Student First Name" no 11 0
1973 1998 "UserDocuments" "StudentID" "" "ZZZZZZZ9" "Student ID" no 9 0
1973 1999 "UserType" "UserTypeDescr" "" "X(25)" "Description" no 7 0
[END]
[MyQuerySort]
1973 2000 "Person" "FirstName" no "" 3 "" "" no
1973 2001 "Person" "LastName" no "" 2 "" "" no
1973 2002 "UserDocuments" "FileName" yes "Count" 1 "" "" no
[END]
[MyQueryDocs]
1973 2003 4 "" 0 "" ""
1973 2004 2 "" 0 "" ""
1973 2005 6 "" 0 "" ""
[END]