Dont get the right hits using dataform with attachmentplugin

Hi

I have a Dataform that contain

Topic Relevant

Checkbox

7

Project Framework & Execution, Generic Processes, Product & System, Software, Hardware, Mechanics, Existing Offer Process, Other, All

Which areas is relevant for the topics

now I would like to make a search for all attachments that in the attachment name contain the word "emplate" (template) AND have the value "Project Framework & Execution" in the dataform field Topic Relevant......

This is what I have made

%ATTACHMENTLIST{TopicRelevant~'ProjectFramework*' includefilepattern="emplate" web="Main" nonoise="on" type="query" header="| File type | File name | File comment | Topic where file are attached |" format="| $fileIcon | $fileName ($fileSize) | $fileComment | $fileTopic |"}%

I know for a fact that at least 2 attachments exists with these data.... but I get 0 hits

Any idea what I have done wrong?

-- PeterSvendsen - 22 Jan 2013

Can I make a search function that find all topic where TopicRelevant match ProjectFramework and take this putput and search if any of these contain a template as attachment?

-- PeterSvendsen - 22 Jan 2013

AttachmentListPlugin doesn't provide for the kind of query you described above. You can use QuerySearch to implement that query and then use AttachmentListPlugin to list the attachments in each topic found. Here's some draft code (untested):

%SEARCH{"attachments[name ~ '*template*' AND TopicRelevant ~ 'Project Framework & Execution*'" 
   type="query" 
  nonoise="on" 
  header="| *File type* | *File name* | *File comment* | *Topic where file are attached* |" 
  format="$percntATTACHMENTLIST{topic=\"$topic\" 
                    web=\"$web\" 
                    includefilepattern=\"(?i).*?template.*\" 
                    format=\"| $fileIcon | [[$fileUrl][$fileName]] ($fileSize) | $fileComment | $web.$topic |\" 
                    separator=\" $n\"
               }$percnt"
  separator=" $n"
}%

-- LynnwoodBrown - 17 Apr 2013

Commenting is disabled while not logged in