title: Search for a file's name through Query Interface in Typo3 without raw query
body: <p>hope someone can help me out here: I am trying to create a query which searches for a file's name and meta data. what I am doing is </p>
  
  <pre><code>$constraints[] = $query-&gt;like(
              $property
              '%' . strtolower($term) . '%',
              false);
  </code></pre>
  
  <p>and In the <code>$property</code> I am using <code>files.name</code> and <code>files.properties</code> but it gives me an error saying column is not mapped. I get the result when I use <code>files.title</code> as it is being referenced in the <code>sys_file_reference</code> table, but I checked that the name is saved in the <code>sys_file</code> table. So how can I create that mapping, or how do I search for this additional info in the query without using raw query.</p>