Project LID Homepage: Distributable Modules
lccQueryReporter Homepage
Updates

Update 4/6/2023: Upgrade: changed so that only shown rows are used against MaxRecords counts.

Update 10/31/2022: Bug fix: using Help Mode to display Content Codes

Update 7/7/2022: Upgrade: upgraded support for delimited download files in qualifying values.

Update 4/8/2022: Upgrade: when using filter negating, ex "!active" (to negate any records with 'active' in the value), it 'was' case sensitive. It is no longer case-sensitive.

Update 10/29/2021: Upgrade: upgraded character encoding (re-escaping) for web form values.

Update 9/29/2021: Upgrade: upgraded to .NET 4.8 to support TLS 1.2/1.3.

Update 7/19/2021: Adjustment: changed how AD properties are enumerated.

Update 7/7/2021: Bug fix: replacing flags (like yyyymmdd) in filenames when downloading report.

Update 5/3/2021: Doc fix: removed duplicated lcc:loginUserId sections.

Update 4/22/2021: Upgrade: Removed some debug information lines.

Update 4/21/2021: Upgrade: Added query flag UserCanHideColumns.

Update 4/19/2021: Upgrade: (windows mode) Form recreated after each search (instead of closing). Report paths flags (date/time) updated with current time on each new report creation. Added column flags 'httpLink', 'httpLinkTarget'.

Update 3/19/2021: Upgrade: (web mode) Added query flag 'AutoScrollToRecords'.

Update 3/1/2021: Upgrade: (web mode) Added which portal id is being accessed.

Update 2/26/2021: Upgrade: Improved 'AddColumn' module to handle adding decimal numbers better.

Update 2/25/2021: Update: Added note in whitepaper about domain account usage in SQL connections. Added column flag AddColumnResetAtColumnChange.

Update 2/24/2021: Upgrade: Added column flag AddColumn.

Update 2/22/2021: Upgrade: reformat multi-line values in reports to single line, i.e. replace new line with space.

Update 2/17/2021: Upgrade: new column flag "MaskValue". Bug Fix: when using Login Id/Password in Logic File and LDAP, security was not holding between page refreshes in 'web' mode.

Update 2/10/2021: Change: lcc:helpMode can be activated when not in Debug Mode. Upgrade: (web mode) jump to report after filters applied.

Update 2/9/2021: Upgraded: allow forward slash in filter values, so that dates can be entered. Added line break in 'web' mode, on column values containing new lines.

Update 2/8/2021: Upgraded: added User Filter Flags. Added ability to find records that have 'empty' values, or negate rows that have certain values. See section "User Filter Flags".

Update 2/5/2021: Upgraded: added Flag Replace section, capability.

Update 2/4/2021: Program released.

Description

lccQueryReporter is a console, web, windows program created to provide a way to allow end users/batch files/etc. to run queries and produce reports.

Demo Screenshots

Web Mode

Windows Mode

Console Mode

Installation
Documentation
Disclaimer
The programs, scripts and documentation are provided AS IS without warranty of any kind. Lower Columbia College further disclaims all implied warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the programs, scripts and documentation remains with you. In no event shall Lower Columbia College, its authors, or anyone else involved in the creation, production, or delivery of the programs, scripts or documentation be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the programs, scripts or documentation, even if Lower Columbia College has been advised of the possibility of such damages.