User Question Search And Export

24 February 2022 - 16:06 | Version 2 | LynnwoodBrown

No permission to view JSCalendarContribInline

Question Category
Measure Set
Staff
Start Date	Select start date for 'Date Posted'.
End Date	Select end date for 'Date Posted'.

Select filter options above and click "Show Report" to see results.

Code

Visible only to members of AdminGroup.

Results section

This report body after parameters are set


<noautolink>
<div style='overflow:scroll'>
%DATATABLE{"TopicType =~ 'UserQuestion' 
           AND QuestionCategory =~ '%URLPARAM{category}%'
           AND RelatedMIFs =~ '%URLPARAM{measureset}%'
           AND AnsweredBy = '%URLPARAM{staff}%' 
           AND (Status = 'Answered' OR Status='Database') 
           AND (DatePosted LATER_THAN '%URLPARAM{afterdate}%' OR DatePosted = '%URLPARAM{afterdate}%') 
           AND (DatePosted EARLIER_THAN '%URLPARAM{beforedate}%' OR DatePosted = '%URLPARAM{beforedate}%')" 
   columns="topic, Question, Details, Answer, QuestionCategory, RelatedMIFs, AnsweredBy"
   hidecolumns="topic"
   buttons="csv, excel, copy, pdf"
   paging="off"
   searching="on"
   info="on"
   class="questionExport"
}%
</div>
<noautolink>