caml query for text field(Title field) contains username in SharePoint hosted app

Question

In my hosted app I have one text field which contains username. I want to apply filter on a view which on filtering gives me data related to current user.

<Field ID="{fa564e0f-0c70-4ab9-b863-0177e6ddd247}" Type="Text" Name="Title" DisplayName="Name" Required="TRUE" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="Title" FromBaseType="TRUE" ColName="nvarchar1" EnforceUniqueValues="FALSE" Indexed="FALSE" MaxLength="255" Version="1" RowOrdinal="0" />

I can only have above text field to apply filter. How to apply caml query for this situations

Answer 1

A CAML query for that would look something like this

<View>
    <Query>
        <Where>
            <Contains>
                <FieldRef Name='Title'/>
                <Value Type='Text'>username</Value>
            </Contains>
        </Where>
    </Query>
</View>

But I do wonder why you are not using a field of user type, to be able to do a better filtering (and a better GUI for the end users)