DESCRIPTION - Allows an authenticated user to retrieve the key asset data (id, code, description, marks and duration) of all assets with at least one field partially/completely matching a given keyword.
It's worth mentioning that the given keyword is searched across the following asset properties (i.e. Etere tables): assets (filmati) and season (season).
INPUT
Parameter - _user
Description : Login name of the executor.
Example : user01
Parameter - _pwd
Description : Password of the executor.
Example : pass01
Parameter - _searchString
Description : Keyword to be searched.
Example : charlie b*
Note: The full-text search supports using the following wildcards on the _searchString keyword:
apple - Match fields containing the entire word apple
apple or banana - Match fields containing at least one between the entire words apple and banana
apple and banana - Match fields containing both entire words, apple and banana
NB: In case two words are entered without operators (e.g. apple banana), the the AND operator will be considered as present (e.g. apple AND banana).
apple and not banana - Match fields containing only the entire word apple, not the word banana
" apple* " - Match fields containing a word starting by apple (e.g. apple, the apples, appleton)
NB: The asterisk (*) must be preceded by at least one character (e.g. a).
"apple banana" - Match fields containing the exact phrase apple banana (e.g. apple banana juice)
apple near banana - Match fields containing the entire word apple, rating the result lower if it also contains the word banana.
*** - Match all assets in the database
NB: The three asterisks (***) must be entered without other characters.
OUTPUT - <asset idAsset="9" code="Charlie Brown-0001" description="Charlie Brown - No.0001" newtype="TV" duration="44200" TCIN="0" TCOUT="44999"/>
<asset idAsset="10" code="Charlie Brown-0002" description="Charlie Brown - No.0002" newtype="TV" duration="43900" TCIN="0" TCOUT="44999"/> ...
XSD (XML Schema Definition)
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="WSApiResponse" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="WSApiResponse" msdata:IsDataSet="true" msdata:Locale="en-US">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="Function">
<xs:complexType>
<xs:sequence>
<xs:element name="asset" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:attribute name="idAsset" type="xs:string" />
<xs:attribute name="code" type="xs:string" />
<xs:attribute name="description" type="xs:string" />
<xs:attribute name="newtype" type="xs:string" />
<xs:attribute name="duration" type="xs:string" />
<xs:attribute name="TCIN" type="xs:string" />
<xs:attribute name="TCOUT" type="xs:string" />
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="Name" type="xs:string" />
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>