...
Code Block | ||
---|---|---|
| ||
<AddressProvider id="8C51B042-81EA-46E3-A429-821641E19A6A" order="1" active="false"> <Debug>false</Debug> <Title>Generic SQL Provider</Title> <Icon>{Base64 Image}</Icon> <SafeQuery>false</SafeQuery> <ConnectionString>{ConnectionString}</ConnectionString> <ConnectionProvider>System.Data.OleDb</ConnectionProvider> <Query> <!-- Example in T-SQL --> SELECT [SPALTENNAME] AS {Feldname OneOffixxprimedocs} FROM [TABLE] WHERE UCase([Vorname]) Like UCase('%{firstName}%') AND UCase([Name]) Like UCase('%{lastName}%') AND UCase([Strasse] & ' ' & [Hausnummer]) Like UCase('%{street}%') AND [Postleitzahl] Like '%{plz}%' AND UCase([Ort]) Like UCase('%{city}%') </Query> <SearchParameters> <SearchParameter Name="company" Label="Firma" Type="String" Length="100" Sort="1" /> <SearchParameter Name="firstName" Label="Vorname/Name" Type="String" Length="100" Sort="2" /> <SearchParameter Name="lastName" Label="" Type="String" Length="100" Sort="2" Width="90" /> <SearchParameter Name="street" Label="Strasse" Type="String" Length="100" Sort="3" /> <SearchParameter Name="plz" Label="PLZ/Ort" Type="String" Length="6" Sort="4" /> <SearchParameter Name="city" Label="" Type="String" Length="100" Width="130" Sort="4" /> <SearchParameter Name="country" Label="Land" Type="String" Length="100" Sort="5" /> </SearchParameters> <ContactMapping> <ContactItemXPath>Contact</ContactItemXPath> <ContactElement id="Person_LastName">Column_LastName</ContactElement> <ContactElement id="Person_FirstName">Column_FirstName</ContactElement> </ContactMapping> </AddressProvider> |
...
Beispiel für Transact-SQL:
Code Block | ||
---|---|---|
| ||
SELECT [Column1] AS OneOffixxFieldname1, [Column2] AS OneOffixxFieldname2, FROM [TABLENAME] WHERE UCase([Column1]) Like UCase('%{searchParam1}%') AND UCase([Column2]) Like UCase('%{searchParam2}%') |
...
Beispiel für Oracle SQL:
Code Block | ||
---|---|---|
| ||
SELECT Column1 AS "OneOffixxFieldname1", Column2 AS "OneOffixxFieldname2" FROM TABLENAME WHERE UPPER(Column1) Like UPPER('%{searchParam1}%') AND UPPER(Column2) Like UPPER('%{searchParam2}%') |
...