Seal Report Library
Namespaces
Seal.Helpers
Helper Class
Helper Methods
AddAttribute Method
AddCTE Method
AddEmailAddresses Method
AddIfNotEmpty Method
AddIfNotNull Method
AddNotEmpty Method
AddNotEmpty2 Method
AddValue Method
AreEqualToSecond Method
ArePropertiesIdentical Method
CleanFileName Method
ClearAllLINQKeywords Method
ClearAllSQLKeywords Method
ClearSQLKeywords Method
Clone Method
CompareTrim Method
ConcatCellValues Method
ConvertDateTimeStandardFormat Method
ConvertNumericStandardFormat Method
CopyProperties Method
CopyPropertiesDifferentObjects Method
CopyPropertiesFromReference Method
DatabaseToNetTypeConverter Method
DbConnectionFromConnectionString Method
DBNameToDisplayName Method
DisplayDataTable Method
ExecutePrePostSQL Method
FindReplacePattern Method
FirstNotEmpty Method
FormatMessage Method
FromTimeSpan Method
GetApplicationDirectory Method
GetDatabaseType Method
GetDataTable Method
GetEmailAddresses Method
GetEnumDescription Method
GetEnumFromDescription<T> Method
GetExceptionMessage Method
GetLicense Method
GetLicenseText Method
GetMongoConnectionString Method
GetMySQLConnectionString Method
GetOdbcConnectionString Method
GetOleDbConnectionString Method
GetPropertyValue Method
GetSQLKeywordNames Method
GetStaticPropertyValue Method
GetStringList Method
GetSystemDriverList Method
GetUniqueName Method
GetUniqueNameCaseInsensitive Method
GetVals Method
HasTimeFormat Method
HtmlGetFilePath Method
HtmlMakeImageSrcData Method
IfNullOrEmpty Method
IsMachineAdministrator Method
IsMatchWildcard Method
IsPasswordComplex Method
IsValidOS Method
MaskEmail Method
MaskPhoneNumber Method
NetTypeConverter Method
NewGUID Method
ODBCToNetTypeConverter Method
OdbcTypeConverter Method
OleDbToNetTypeConverter Method
QuoteDouble Method
QuoteSingle Method
RemoveHTMLTags Method
RemoveWhitespace Method
Serialize Method
SetPropertyValue Method
ToDateFnsFormat Method
ToDateTime Method
ToDouble Method
ToFlatpickrFormat Method
ToHtml Method
ToHtmlNoBr Method
ToJS Method
ToMomentJSFormat Method
ToString Method
ToTimeSpan Method
ValidateNumeric Method
WriteDailyLog Method
WriteEventLogEntry Method
WriteLogEntry Method
WriteLogEntryScheduler Method
WriteLogException Method
Click or drag to resize

HelperClearAllSQLKeywords Method

Replace all Seal keywords (enum filters, enum values, common restrictions and values) in a SQL statement by neutral values (e.g. common restrictions by '1=1')

Namespace: Seal.Helpers
Assembly: SealLibrary (in SealLibrary.dll) Version: 10.0.1.0+a44cd3a7f03c2bf3cdbd971a878c679e40bed08a
Syntax
C#
Copy
public static string ClearAllSQLKeywords(
	string sql,
	ReportModel model = null
)

Parameters

sql  String
 
model  ReportModel  (Optional)
 

Return Value

String
See Also