Supported Operations

19.4.1.15 GetAssetListByAllTableFullText

DESCRIPTION: Allows an authenticated user to retrieve the key asset data (id, code, description, type, duration, marks and audio data) of all assets with at least one field partially/completely matching a given keyword. Please refer to the Etere tables > Assets repository chapter for information on fields returned by this function.

It's worth mentioning that the given keyword is searched across the following asset data tables: assets (filmati), (season), artists (artisti), genres (generi), interruptions (interruzioni), metadata (smpte), roles (ruoli), segments (mam), documents (doma) and subtitles (sottotitoli).

INPUT:

_user: Login name of the executor.

_pwd: Password of the executor.

_searchString: Keyword to be searched.

GetAssetListByAllTableFullText

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;

WARNING: If two words are entered without operators (e.g. apple banana), the AND operator will be considered 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 with apple (e.g. apple, the apples, Appleton);

WARNING: 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 includes the word banana.

***: Match all assets in the database.

WARNING: The three asterisks (***) must be entered without other characters.

OUTPUT:

GetAssetListByAllTableFullText_output

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="f" 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:attribute name="AUDIO_LANGUAGE" type="xs:string" />
<xs:attribute name="AUDIO" 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>

GetAssetListByAllTableFullText

GetAssetListByAllTableFullText_output