protected function getFileQuery()
    {
        $table = DataObject::singleton(File::class)->baseTable();
        // Select all records which have a Filename value, but not FileFilename.
        /** @skipUpgrade */
        return File::get()
            ->exclude('ClassName', [Folder::class, 'Folder'])
            ->filter('FileFilename', array('', null))
            ->where(sprintf(
                '"%s"."Filename" IS NOT NULL AND "%s"."Filename" != \'\'',
                $table,
                $table
            )) // Non-orm field
            ->alterDataQuery(function (DataQuery $query) use ($table) {
                return $query->addSelectFromTable($table, ['Filename']);
            });
    }
protected function getFileQuery()
    {
        $table = DataObject::singleton(File::class)->baseTable();
        // Select all records which have a Filename value, but not FileFilename.
        /** @skipUpgrade */
        return File::get()
            ->exclude('ClassName', [Folder::class, 'Folder'])
            ->filter('FileFilename', array('', null))
            ->where(sprintf(
                '"%s"."Filename" IS NOT NULL AND "%s"."Filename" != \'\'',
                $table,
                $table
            )) // Non-orm field
            ->alterDataQuery(function (DataQuery $query) use ($table) {
                return $query->addSelectFromTable($table, ['Filename']);
            });
    }
protected function getFileQuery ( ) { $ table = DataObject :: singleton ( File :: class ) -> baseTable ( ) ; // Select all records which have a Filename value, but not FileFilename. /** @skipUpgrade */ return File :: get ( ) -> exclude ( 'ClassName' , [ Folder :: class , 'Folder' ] ) -> filter ( 'FileFilename' , array ( '' , null ) ) -> where ( sprintf ( '"%s"."Filename" IS NOT NULL AND "%s"."Filename" != \'\'' , $ table , $ table ) ) // Non-orm field -> alterDataQuery ( function ( DataQuery $ query ) use ( $ table ) { return $ query -> addSelectFromTable ( $ table , [ 'Filename' ] ) ; } ) ; }
Get list of File dataobjects to import

@return DataList
@throws \Exception
Get list of File dataobjects to import