Forums

[Bug] Can't search files by Filename?

Permalink
$fl = new FileList();
$fl->filterByFilename(basename($fileLocation));
$checkFile = $fl->get();

mysqlt error: [1054: Unknown column 'ak_filename' in 'where clause'] in EXECUTE("SELECT DISTINCT f.fID, u.uName as fvAuthorName FROM Files f INNER JOIN FileVersions fv ON f.fID = fv.fID LEFT JOIN Users u on u.uID = fv.fvAuthorUID left join FileSearchIndexAttributes on (fv.fID = FileSearchIndexAttributes.fID) where 1=1 and fvIsApproved = '1' and ak_filename = 'test.mp3' ")
 
planist1 replied on at Permalink Best Answer Reply
planist1
Not sure if you have looked here, but it might be worthwhile. http://www.concrete5.org/documentation/developers/files/searching-a...


Specifically regarding:
$fl->filterByKeywords($keywords)
Filters files by keywords, which searches
filename
title
tags
username of uploader
Any file attributes marked as being included in the search index.
JoshWegener replied on at Permalink Reply
That is my bad... I was reading that, but I thought you replaced "Keyword" with the Keyword you wanted to use... like Filename...
PineCreativeLabs replied on at Permalink Reply
PineCreativeLabs
Is this something you're trying to do on your site, on the front-end?

If so, I have an addon that might be a simple solution for you:

http://www.concrete5.org/marketplace/addons/file-list-pro...