pmakholm/gist:2214090

## gistfile1.xml
<?xml version="1.0" encoding="utf-8"?>

<!--
2011-07-28: Tilføjet RSS
2009-08-05: Helt nyt view og parfil. OBS parameter minister daekker over ministerArea
2009-04-18: PEP Rediget til optimering (udkommentering spørgsmåltyper)
2009-03-26: Redigeret til samrådsspm.
2009-03-19: SYNKRONISERET til alle servere
2008-05-11: denne configuration er OK PEP
2010-04-06: rettet sortering på nr. JOKR

-->

<wsConfig name="spoergsmaal">

<!---->

<connection/>

<sources>

<source default="true" type="view" distinct="true">

<selectfrom>
xWebCaseQuestionsAll left outer join ftcn_casenumber on xWebCaseQuestionsAll.caseRecNo = ftcn_casenumber.ftcn_ca_recno</selectfrom>

<groupby>
</groupby>

</source>

<source codematch="A" type="view" distinct="true">

<selectfrom>
xWebCaseQuestions left outer join ftcn_casenumber on xWebCaseQuestions.caseRecNo = ftcn_casenumber.ftcn_ca_recno</selectfrom>

<groupby>
</groupby>

</source>

<source codematch="AD" type="view" distinct="true">

<selectfrom>
xWebCaseQuestionsInquirer left outer join ftcn_casenumber on xWebCaseQuestionsInquirer.caseRecNo = ftcn_casenumber.ftcn_ca_recno</selectfrom>

<groupby>
</groupby>

</source>

<source codematch="B" type="view" distinct="true">

<selectfrom>
xWebCaseQuestions20 left outer join ftcn_casenumber on xWebCaseQuestions20.caseRecNo = ftcn_casenumber.ftcn_ca_recno</selectfrom>

<groupby>
</groupby>

</source>

<source codematch="BD" type="view" distinct="true">

<selectfrom>
dbo.xWebCaseQuestions20Inquirer left outer join ftcn_casenumber on dbo.xWebCaseQuestions20Inquirer.caseRecNo = ftcn_casenumber.ftcn_ca_recno</selectfrom>

<groupby>
</groupby>

</source>

<source codematch="C" type="view" distinct="true">

<selectfrom>

(dbo.xWebCaseQuestions20 INNER JOIN
dbo.xWebCaseActivity ON dbo.xWebCaseQuestions20.caseRecno = dbo.xWebCaseActivity.activityCaseRecno)
left outer join ftcn_casenumber on dbo.xWebCaseQuestions20.caseRecNo = ftcn_casenumber.ftcn_ca_recno
</selectfrom>

<groupby>
</groupby>

</source>

<source codematch="CD" type="view" distinct="true">

<selectfrom>

(dbo.xWebCaseQuestions20Inquirer INNER JOIN
dbo.xWebCaseActivity ON dbo.xWebCaseQuestions20Inquirer.caseRecno = dbo.xWebCaseActivity.activityCaseRecno)
left outer join ftcn_casenumber on dbo.xWebCaseQuestions20Inquirer.caseRecNo = ftcn_casenumber.ftcn_ca_recno
</selectfrom>

<groupby>
</groupby>

</source>

<source codematch="D" type="view" distinct="true">

<selectfrom>
xWebCaseQuestionsAllInquirer left outer join ftcn_casenumber on xWebCaseQuestionsAllInquirer.caseRecNo = ftcn_casenumber.ftcn_ca_recno</selectfrom>

<groupby>
</groupby>

</source>

</sources>


<linkURL>

<part type="static">
samling</part>

<part type="column">
session</part>

<part type="replace" matchName="A">
caseTypeRecno</part>

<part type="substitute" matchName="B">
caseTypeRecno</part>

<part type="static" ifcontent="documentParagraphNumber">
pgf</part>

<part type="column" ifcontent="documentParagraphNumber">
documentParagraphNumber</part>

<part type="replace" ifcontent="documentDisplayNumber" matchName="C">
documentCategoryRecno</part>

<part type="column" ifcontent="documentDisplayNumber">
documentDisplayNumber</part>

<part type="static">
index.htm</part>

</linkURL>


<linkReplace matchName="A">

<replace id="100001">
almdel</replace>

<replace id="100002">
kommissionsforslag</replace>

<replace id="100004">
aktstykke</replace>

<replace id="100005">
raadsmoede</replace>

<replace id="100007">
spoergsmaal</replace>

<replace id="100010">
beslutningsforslag</replace>

<replace id="100012">
umdel</replace>

<replace id="100016">
lovforslag</replace>

</linkReplace>


<linkReplace matchName="B">

<replace id="100001">
committeeAbbreviation</replace>

<replace id="100002">
caseNumber</replace>

<replace id="100004">
caseNumber</replace>

<replace id="100005">
caseRecno</replace>

<replace id="100007">
caseNumber</replace>

<replace id="100010">
caseNumber</replace>

<replace id="100012">
committeeAbbreviation</replace>

<replace id="100016">
caseNumber</replace>

</linkReplace>


<linkReplace matchName="C">

<replace id="100044">
spm</replace>

<replace id="100045">
samspm</replace>

</linkReplace>


<columns>

<!--	 <column id="cNumber" width="">

<expression>
CASE WHEN caseTypeRecno=100012 then 'UM-del' WHEN caseTypeRecno=100001 THEN committeeAbbreviation + ' Alm. del' ELSE caseNumber END + ' '+documentDisplayParagraphNumber + documentSortPrefix + ' ' + documentDisplayNumber</expression>

<title>
Nr</title>

<orderasc>
caseTypeRecno asc, documentSortPrefix asc, documentSortNumber asc</orderasc>

<orderdesc>
caseTypeRecno desc, documentSortPrefix desc, documentSortNumber desc</orderdesc>

</column>
-->

<column id="cNumber" width="">

<expression>
CASE WHEN caseTypeRecNo=100005 then 'Rådsmøde '+ caseNumber WHEN caseTypeRecno=100012 then 'UM-del' WHEN caseTypeRecno=100001 THEN 'Alm. del ' + committeeAbbreviation ELSE caseNumber END + ' '+ IsNull(documentDisplayParagraphNumber,'') + IsNull(documentSortPrefix, '') + ' ' + IsNull(documentDisplayNumber, '')</expression>

<title>
Nr</title>

<orderasc>

CASE WHEN ftcn_casenumber.ftcn_casetypedesc in ('B ', 'S ', 'L ', 'Aktstk.', 'US') THEN UPPER(ftcn_casenumber.ftcn_casetypedesc + ' ' + REPLICATE('0', 50 - len(ftcn_casenumber.ftcn_casenumber)) + ftcn_casenumber.ftcn_casenumber + ' ' + IsNull(ftcn_casenumber.ftcn_casenosuffix, '') + ' ' + REPLICATE('0', 50 - len(convert(varchar(10),IsNull(documentParagraphNumber,0)))) + convert(varchar(10),IsNull(documentParagraphNumber,0)))
ELSE
(
CASE WHEN caseTypeRecno=100012 then 'UM-DEL'
WHEN caseTypeRecno=100001 THEN 'ALM. DEL ' + committeeAbbreviation + ' ' + REPLICATE('0', 50 - len(convert(varchar(10),IsNull(documentParagraphNumber,0)))) + convert(varchar(10),IsNull(documentParagraphNumber,0)) + ' ' + documentSortPrefix + REPLICATE('0', 50 - len(documentDisplayNumber)) + documentDisplayNumber
WHEN caseTypeRecNo=100005 THEN 'RÅDSMØDE ' + caseNumber
ELSE UPPER(caseNumber) END
)
END asc,
committeeAbbreviation asc,
documentSortPrefix asc,
documentSortNumber asc
</orderasc>

<orderdesc default="yes">

CASE WHEN ftcn_casenumber.ftcn_casetypedesc in ('B ', 'S ', 'L ', 'Aktstk.', 'US') THEN UPPER(ftcn_casenumber.ftcn_casetypedesc + ' ' + REPLICATE('0', 50 - len(ftcn_casenumber.ftcn_casenumber)) + ftcn_casenumber.ftcn_casenumber + ' ' + IsNull(ftcn_casenumber.ftcn_casenosuffix, '') + ' ' + REPLICATE('0', 50 - len(convert(varchar(10),IsNull(documentParagraphNumber,0)))) + convert(varchar(10),IsNull(documentParagraphNumber,0)))
ELSE
(
CASE WHEN caseTypeRecno=100012 then 'UM-DEL'
WHEN caseTypeRecno=100001 THEN 'ALM. DEL ' + committeeAbbreviation + ' ' + REPLICATE('0', 50 - len(convert(varchar(10),IsNull(documentParagraphNumber,0)))) + convert(varchar(10),IsNull(documentParagraphNumber,0)) + ' ' + documentSortPrefix + REPLICATE('0', 50 - len(documentDisplayNumber)) + documentDisplayNumber
WHEN caseTypeRecNo=100005 THEN 'RÅDSMØDE ' + caseNumber
ELSE UPPER(caseNumber) END
)
END desc,
committeeAbbreviation desc,
documentSortPrefix desc,
documentSortNumber desc
</orderdesc>

</column>

<column id="documentTitle" width="" restricted="documentRestriction">

<expression>
</expression>

<title>
Titel</title>

<orderasc>
documentTitle asc</orderasc>

<orderdesc>
documentTitle desc</orderdesc>

</column>

<!--<column id="committeeName">

<title>
Udvalg</title>

<orderasc>
committeeName asc</orderasc>

<orderdesc>
committeeName desc</orderdesc>

</column>
-->


<column id="ct_name3">

<title>
Minister</title>

<expression>
[dbo].[CapitalizeString](ct_name3)</expression>

<orderasc>
ct_name3 asc</orderasc>

<orderdesc>
ct_name3 desc</orderdesc>

</column>


<!--
<column id="caseMinistryName">

<title>
Ministerområde</title>

<orderasc>
caseMinistryName asc</orderasc>

<orderdesc>
caseMinistryName desc</orderdesc>

</column>

-->

<column id="status">

<expression>
case when answerExists=2 then 'Ikke besvaret' when answerExists=1 then 'Besvaret' else '' end</expression>

<title>
Status</title>

<orderasc>
answerExists asc</orderasc>

<orderdesc>
answerExists desc</orderdesc>

</column>

<column id="documentCategoryDesc">

<title>
Type</title>

<orderasc>
documentCategoryDesc asc</orderasc>

<orderdesc>
documentCategoryDesc desc</orderdesc>

</column>

<column id="dokDatoShow">

<expression>
convert(nvarchar, IsNull(documentDistributionDate, documentDate),104) + ' ('+ sessionUserFriendly +')'</expression>

<title>
Spørgsmåls dato og samling</title>

<orderasc>
IsNull(documentDistributionDate, documentDate) asc</orderasc>

<orderdesc>
IsNull(documentDistributionDate, documentDate) desc</orderdesc>

</column>

</columns>


<rsscolumns>

<column id="title" width="">

<title>
title</title>

<expression>
CASE WHEN caseTypeRecNo=100005 then 'Rådsmøde '+ caseNumber WHEN caseTypeRecno=100012 then 'UM-del' WHEN caseTypeRecno=100001 THEN 'Alm. del ' + committeeAbbreviation ELSE caseNumber END + ' '+ IsNull(documentDisplayParagraphNumber,'') + IsNull(documentSortPrefix, '') + ' ' + IsNull(documentDisplayNumber, '')</expression>

</column>

<column id="description" width="" restricted="documentRestriction">

<title>
description</title>

<expression>
case when answerExists=2 then '(Ikke besvaret) ' when answerExists=1 then '(Besvaret) ' else '' end + documentTitle</expression>

</column>

<column id="pubDate" width="">

<exclude whenParameter="actualPort" is="ne" tovalue="81" />

<title>
pubDate</title>

<expression>
dbo.xWebToRfc822DateTime(IsNull(documentDistributionDate, documentDate))</expression>

<orderdesc default="yes">
IsNull(documentDistributionDate, documentDate) desc</orderdesc>

</column>

<column id="pubDate" width="">

<exclude whenParameter="actualPort" is="eq" tovalue="81" />

<title>
pubDate</title>

<expression>
dbo.xWebToRfc822DateTime(IsNull(documentDistributionDatePublic, documentDate))</expression>

<orderdesc default="yes">
IsNull(documentDistributionDatePublic, documentDate) desc</orderdesc>

</column>

<column id="guid" width="">

<title>
guid</title>

<expression>
documentDate</expression>

</column>

</rsscolumns>


<hiddenColumns>

<column id="session" />

<column id="committeeAbbreviation" />

<column id="caseTypeRecno" />

<column id="caseRecno" />

<column id="caseNumber" />

<column id="documentCategoryRecno" />

<column id="documentParagraphNumber" />

<column id="documentSortPrefix" />

<column id="documentSortNumber" />

<column id="documentDisplayNumber" />

<column id="documentRestriction" />

<column id="docKey" />

</hiddenColumns>


<rsshiddenColumns>

<column id="session" />

<column id="committeeAbbreviation" />

<column id="caseTypeRecno" />

<column id="caseRecno" />

<column id="caseNumber" />

<column id="documentCategoryRecno" />

<column id="documentParagraphNumber" />

<column id="documentSortPrefix" />

<column id="documentSortNumber" />

<column id="documentDisplayNumber" />

<column id="documentRestriction" />

<column id="docKey" />

</rsshiddenColumns>


<whereSection>


<filter type="column" id="committeeAbbreviation" operator="AND" whenParameter="committee" is="ne" tovalue="-1">

<expression operator="eq" expr1="committee" filtervalue="$">
N'$'</expression>

</filter>


<filter type="column" id="session" operator="AND" whenParameter="session" is="ne" tovalue="">

<expression operator="eq" expr1="session" filtervalue="$">
N'$'</expression>

</filter>


<filter type="column" id="ct_recno" operator="AND" whenParameter="minister" is="ne" tovalue="-1">

<expression operator="eq" expr1="minister" filtervalue="$">
N'$'</expression>

</filter>


<!--<filter type="column" id="caseMinistryRecno" operator="AND" whenParameter="minister" is="ne" tovalue="-1" codeflag="">

<expression operator="eq" expr1="minister" filtervalue="$">
$</expression>

</filter>
-->


<filter type="column" id="documentDate" operator="AND" whenParameter="startDate" is="ne" tovalue="">

<expression operator="between" expr1="startDate" expr2="endDate" filtervalue="$">
convert(datetime,N'$',112)</expression>

</filter>


<filter type="column" id="documentDate" operator="AND" whenParameter="days" is="ne" tovalue="">

<expression operator="ge" expr1="days" filtervalue="$">
dateadd(dd,-$,getdate())</expression>

</filter>


<filter type="static" operator="AND" whenParameter="questionSearchtype" is="eq" tovalue="1" codeflag="B">
caseTypeRecno=100007</filter>


<filter type="static" operator="AND" whenParameter="questionSearchtype" is="eq" tovalue="2" codeflag="C">
caseTypeRecno=100007 and activityTypeRecno=100013 and activityStatusRecno in (16,100060,100061,100062,100063)</filter>

<filter type="static" operator="AND" whenParameter="questionSearchtype" is="eq" tovalue="3" codeflag="C">
caseTypeRecno=100007 and activityTypeRecno=100041 and activityStatusRecno in (16,100150,100151,100152,100153)</filter>


<filter type="static" operator="AND" whenParameter="questionSearchtype" is="eq" tovalue="4" codeflag="A">
documentCategoryRecno=100044</filter>

<filter type="static" operator="AND" whenParameter="questionSearchtype" is="eq" tovalue="5" codeflag="A">
documentCategoryRecno=100045</filter>


<filter type="static" operator="AND" whenParameter="statusAnswer" is="eq" tovalue="1">
answerExists=1</filter>

<filter type="static" operator="AND" whenParameter="statusAnswer" is="eq" tovalue="2">
answerExists=2</filter>


<filter type="column" id="contactRecno" operator="AND" whenParameter="inquirer" is="ne" tovalue="-1" codeflag="D">

<expression operator="eq" expr1="inquirer" filtervalue="$">
$</expression>

</filter>


<filter type="filter" operator="AND" whenParameter="rss" is="eq" tovalue="1">

<filter type="static" operator="AND" whenParameter="actualPort" is="ne" tovalue="81">
substring(documentRestriction,2,1)!='H'</filter>

</filter>


</whereSection>

</wsConfig>
	<?xml version="1.0" encoding="utf-8"?>

	<!--
	2011-07-28: Tilføjet RSS
	2009-08-05: Helt nyt view og parfil. OBS parameter minister daekker over ministerArea
	2009-04-18: PEP Rediget til optimering (udkommentering spørgsmåltyper)
	2009-03-26: Redigeret til samrådsspm.
	2009-03-19: SYNKRONISERET til alle servere
	2008-05-11: denne configuration er OK PEP
	2010-04-06: rettet sortering på nr. JOKR

	-->

	<wsConfig name="spoergsmaal">

	<!---->

	<connection/>

	<sources>

	<source default="true" type="view" distinct="true">

	<selectfrom>
	xWebCaseQuestionsAll left outer join ftcn_casenumber on xWebCaseQuestionsAll.caseRecNo = ftcn_casenumber.ftcn_ca_recno</selectfrom>

	<groupby>
	</groupby>

	</source>

	<source codematch="A" type="view" distinct="true">

	<selectfrom>
	xWebCaseQuestions left outer join ftcn_casenumber on xWebCaseQuestions.caseRecNo = ftcn_casenumber.ftcn_ca_recno</selectfrom>

	<groupby>
	</groupby>

	</source>

	<source codematch="AD" type="view" distinct="true">

	<selectfrom>
	xWebCaseQuestionsInquirer left outer join ftcn_casenumber on xWebCaseQuestionsInquirer.caseRecNo = ftcn_casenumber.ftcn_ca_recno</selectfrom>

	<groupby>
	</groupby>

	</source>

	<source codematch="B" type="view" distinct="true">

	<selectfrom>
	xWebCaseQuestions20 left outer join ftcn_casenumber on xWebCaseQuestions20.caseRecNo = ftcn_casenumber.ftcn_ca_recno</selectfrom>

	<groupby>
	</groupby>

	</source>

	<source codematch="BD" type="view" distinct="true">

	<selectfrom>
	dbo.xWebCaseQuestions20Inquirer left outer join ftcn_casenumber on dbo.xWebCaseQuestions20Inquirer.caseRecNo = ftcn_casenumber.ftcn_ca_recno</selectfrom>

	<groupby>
	</groupby>

	</source>

	<source codematch="C" type="view" distinct="true">

	<selectfrom>

	(dbo.xWebCaseQuestions20 INNER JOIN
	dbo.xWebCaseActivity ON dbo.xWebCaseQuestions20.caseRecno = dbo.xWebCaseActivity.activityCaseRecno)
	left outer join ftcn_casenumber on dbo.xWebCaseQuestions20.caseRecNo = ftcn_casenumber.ftcn_ca_recno
	</selectfrom>

	<groupby>
	</groupby>

	</source>

	<source codematch="CD" type="view" distinct="true">

	<selectfrom>

	(dbo.xWebCaseQuestions20Inquirer INNER JOIN
	dbo.xWebCaseActivity ON dbo.xWebCaseQuestions20Inquirer.caseRecno = dbo.xWebCaseActivity.activityCaseRecno)
	left outer join ftcn_casenumber on dbo.xWebCaseQuestions20Inquirer.caseRecNo = ftcn_casenumber.ftcn_ca_recno
	</selectfrom>

	<groupby>
	</groupby>

	</source>

	<source codematch="D" type="view" distinct="true">

	<selectfrom>
	xWebCaseQuestionsAllInquirer left outer join ftcn_casenumber on xWebCaseQuestionsAllInquirer.caseRecNo = ftcn_casenumber.ftcn_ca_recno</selectfrom>

	<groupby>
	</groupby>

	</source>

	</sources>


	<linkURL>

	<part type="static">
	samling</part>

	<part type="column">
	session</part>

	<part type="replace" matchName="A">
	caseTypeRecno</part>

	<part type="substitute" matchName="B">
	caseTypeRecno</part>

	<part type="static" ifcontent="documentParagraphNumber">
	pgf</part>

	<part type="column" ifcontent="documentParagraphNumber">
	documentParagraphNumber</part>

	<part type="replace" ifcontent="documentDisplayNumber" matchName="C">
	documentCategoryRecno</part>

	<part type="column" ifcontent="documentDisplayNumber">
	documentDisplayNumber</part>

	<part type="static">
	index.htm</part>

	</linkURL>


	<linkReplace matchName="A">

	<replace id="100001">
	almdel</replace>

	<replace id="100002">
	kommissionsforslag</replace>

	<replace id="100004">
	aktstykke</replace>

	<replace id="100005">
	raadsmoede</replace>

	<replace id="100007">
	spoergsmaal</replace>

	<replace id="100010">
	beslutningsforslag</replace>

	<replace id="100012">
	umdel</replace>

	<replace id="100016">
	lovforslag</replace>

	</linkReplace>


	<linkReplace matchName="B">

	<replace id="100001">
	committeeAbbreviation</replace>

	<replace id="100002">
	caseNumber</replace>

	<replace id="100004">
	caseNumber</replace>

	<replace id="100005">
	caseRecno</replace>

	<replace id="100007">
	caseNumber</replace>

	<replace id="100010">
	caseNumber</replace>

	<replace id="100012">
	committeeAbbreviation</replace>

	<replace id="100016">
	caseNumber</replace>

	</linkReplace>


	<linkReplace matchName="C">

	<replace id="100044">
	spm</replace>

	<replace id="100045">
	samspm</replace>

	</linkReplace>


	<columns>

	<!-- <column id="cNumber" width="">

	<expression>
	CASE WHEN caseTypeRecno=100012 then 'UM-del' WHEN caseTypeRecno=100001 THEN committeeAbbreviation + ' Alm. del' ELSE caseNumber END + ' '+documentDisplayParagraphNumber + documentSortPrefix + ' ' + documentDisplayNumber</expression>

	<title>
	Nr</title>

	<orderasc>
	caseTypeRecno asc, documentSortPrefix asc, documentSortNumber asc</orderasc>

	<orderdesc>
	caseTypeRecno desc, documentSortPrefix desc, documentSortNumber desc</orderdesc>

	</column>
	-->

	<column id="cNumber" width="">

	<expression>
	CASE WHEN caseTypeRecNo=100005 then 'Rådsmøde '+ caseNumber WHEN caseTypeRecno=100012 then 'UM-del' WHEN caseTypeRecno=100001 THEN 'Alm. del ' + committeeAbbreviation ELSE caseNumber END + ' '+ IsNull(documentDisplayParagraphNumber,'') + IsNull(documentSortPrefix, '') + ' ' + IsNull(documentDisplayNumber, '')</expression>

	<title>
	Nr</title>

	<orderasc>

	CASE WHEN ftcn_casenumber.ftcn_casetypedesc in ('B ', 'S ', 'L ', 'Aktstk.', 'US') THEN UPPER(ftcn_casenumber.ftcn_casetypedesc + ' ' + REPLICATE('0', 50 - len(ftcn_casenumber.ftcn_casenumber)) + ftcn_casenumber.ftcn_casenumber + ' ' + IsNull(ftcn_casenumber.ftcn_casenosuffix, '') + ' ' + REPLICATE('0', 50 - len(convert(varchar(10),IsNull(documentParagraphNumber,0)))) + convert(varchar(10),IsNull(documentParagraphNumber,0)))
	ELSE
	(
	CASE WHEN caseTypeRecno=100012 then 'UM-DEL'
	WHEN caseTypeRecno=100001 THEN 'ALM. DEL ' + committeeAbbreviation + ' ' + REPLICATE('0', 50 - len(convert(varchar(10),IsNull(documentParagraphNumber,0)))) + convert(varchar(10),IsNull(documentParagraphNumber,0)) + ' ' + documentSortPrefix + REPLICATE('0', 50 - len(documentDisplayNumber)) + documentDisplayNumber
	WHEN caseTypeRecNo=100005 THEN 'RÅDSMØDE ' + caseNumber
	ELSE UPPER(caseNumber) END
	)
	END asc,
	committeeAbbreviation asc,
	documentSortPrefix asc,
	documentSortNumber asc
	</orderasc>

	<orderdesc default="yes">

	CASE WHEN ftcn_casenumber.ftcn_casetypedesc in ('B ', 'S ', 'L ', 'Aktstk.', 'US') THEN UPPER(ftcn_casenumber.ftcn_casetypedesc + ' ' + REPLICATE('0', 50 - len(ftcn_casenumber.ftcn_casenumber)) + ftcn_casenumber.ftcn_casenumber + ' ' + IsNull(ftcn_casenumber.ftcn_casenosuffix, '') + ' ' + REPLICATE('0', 50 - len(convert(varchar(10),IsNull(documentParagraphNumber,0)))) + convert(varchar(10),IsNull(documentParagraphNumber,0)))
	ELSE
	(
	CASE WHEN caseTypeRecno=100012 then 'UM-DEL'
	WHEN caseTypeRecno=100001 THEN 'ALM. DEL ' + committeeAbbreviation + ' ' + REPLICATE('0', 50 - len(convert(varchar(10),IsNull(documentParagraphNumber,0)))) + convert(varchar(10),IsNull(documentParagraphNumber,0)) + ' ' + documentSortPrefix + REPLICATE('0', 50 - len(documentDisplayNumber)) + documentDisplayNumber
	WHEN caseTypeRecNo=100005 THEN 'RÅDSMØDE ' + caseNumber
	ELSE UPPER(caseNumber) END
	)
	END desc,
	committeeAbbreviation desc,
	documentSortPrefix desc,
	documentSortNumber desc
	</orderdesc>

	</column>

	<column id="documentTitle" width="" restricted="documentRestriction">

	<expression>
	</expression>

	<title>
	Titel</title>

	<orderasc>
	documentTitle asc</orderasc>

	<orderdesc>
	documentTitle desc</orderdesc>

	</column>

	<!--<column id="committeeName">

	<title>
	Udvalg</title>

	<orderasc>
	committeeName asc</orderasc>

	<orderdesc>
	committeeName desc</orderdesc>

	</column>
	-->


	<column id="ct_name3">

	<title>
	Minister</title>

	<expression>
	[dbo].[CapitalizeString](ct_name3)</expression>

	<orderasc>
	ct_name3 asc</orderasc>

	<orderdesc>
	ct_name3 desc</orderdesc>

	</column>


	<!--
	<column id="caseMinistryName">

	<title>
	Ministerområde</title>

	<orderasc>
	caseMinistryName asc</orderasc>

	<orderdesc>
	caseMinistryName desc</orderdesc>

	</column>

	-->

	<column id="status">

	<expression>
	case when answerExists=2 then 'Ikke besvaret' when answerExists=1 then 'Besvaret' else '' end</expression>

	<title>
	Status</title>

	<orderasc>
	answerExists asc</orderasc>

	<orderdesc>
	answerExists desc</orderdesc>

	</column>

	<column id="documentCategoryDesc">

	<title>
	Type</title>

	<orderasc>
	documentCategoryDesc asc</orderasc>

	<orderdesc>
	documentCategoryDesc desc</orderdesc>

	</column>

	<column id="dokDatoShow">

	<expression>
	convert(nvarchar, IsNull(documentDistributionDate, documentDate),104) + ' ('+ sessionUserFriendly +')'</expression>

	<title>
	Spørgsmåls dato og samling</title>

	<orderasc>
	IsNull(documentDistributionDate, documentDate) asc</orderasc>

	<orderdesc>
	IsNull(documentDistributionDate, documentDate) desc</orderdesc>

	</column>

	</columns>


	<rsscolumns>

	<column id="title" width="">

	<title>
	title</title>

	<expression>
	CASE WHEN caseTypeRecNo=100005 then 'Rådsmøde '+ caseNumber WHEN caseTypeRecno=100012 then 'UM-del' WHEN caseTypeRecno=100001 THEN 'Alm. del ' + committeeAbbreviation ELSE caseNumber END + ' '+ IsNull(documentDisplayParagraphNumber,'') + IsNull(documentSortPrefix, '') + ' ' + IsNull(documentDisplayNumber, '')</expression>

	</column>

	<column id="description" width="" restricted="documentRestriction">

	<title>
	description</title>

	<expression>
	case when answerExists=2 then '(Ikke besvaret) ' when answerExists=1 then '(Besvaret) ' else '' end + documentTitle</expression>

	</column>

	<column id="pubDate" width="">

	<exclude whenParameter="actualPort" is="ne" tovalue="81" />

	<title>
	pubDate</title>

	<expression>
	dbo.xWebToRfc822DateTime(IsNull(documentDistributionDate, documentDate))</expression>

	<orderdesc default="yes">
	IsNull(documentDistributionDate, documentDate) desc</orderdesc>

	</column>

	<column id="pubDate" width="">

	<exclude whenParameter="actualPort" is="eq" tovalue="81" />

	<title>
	pubDate</title>

	<expression>
	dbo.xWebToRfc822DateTime(IsNull(documentDistributionDatePublic, documentDate))</expression>

	<orderdesc default="yes">
	IsNull(documentDistributionDatePublic, documentDate) desc</orderdesc>

	</column>

	<column id="guid" width="">

	<title>
	guid</title>

	<expression>
	documentDate</expression>

	</column>

	</rsscolumns>


	<hiddenColumns>

	<column id="session" />

	<column id="committeeAbbreviation" />

	<column id="caseTypeRecno" />

	<column id="caseRecno" />

	<column id="caseNumber" />

	<column id="documentCategoryRecno" />

	<column id="documentParagraphNumber" />

	<column id="documentSortPrefix" />

	<column id="documentSortNumber" />

	<column id="documentDisplayNumber" />

	<column id="documentRestriction" />

	<column id="docKey" />

	</hiddenColumns>


	<rsshiddenColumns>

	<column id="session" />

	<column id="committeeAbbreviation" />

	<column id="caseTypeRecno" />

	<column id="caseRecno" />

	<column id="caseNumber" />

	<column id="documentCategoryRecno" />

	<column id="documentParagraphNumber" />

	<column id="documentSortPrefix" />

	<column id="documentSortNumber" />

	<column id="documentDisplayNumber" />

	<column id="documentRestriction" />

	<column id="docKey" />

	</rsshiddenColumns>



	<whereSection>


	<filter type="column" id="committeeAbbreviation" operator="AND" whenParameter="committee" is="ne" tovalue="-1">

	<expression operator="eq" expr1="committee" filtervalue="$">
	N'$'</expression>

	</filter>


	<filter type="column" id="session" operator="AND" whenParameter="session" is="ne" tovalue="">

	<expression operator="eq" expr1="session" filtervalue="$">
	N'$'</expression>

	</filter>


	<filter type="column" id="ct_recno" operator="AND" whenParameter="minister" is="ne" tovalue="-1">

	<expression operator="eq" expr1="minister" filtervalue="$">
	N'$'</expression>

	</filter>


	<!--<filter type="column" id="caseMinistryRecno" operator="AND" whenParameter="minister" is="ne" tovalue="-1" codeflag="">

	<expression operator="eq" expr1="minister" filtervalue="$">
	$</expression>

	</filter>
	-->


	<filter type="column" id="documentDate" operator="AND" whenParameter="startDate" is="ne" tovalue="">

	<expression operator="between" expr1="startDate" expr2="endDate" filtervalue="$">
	convert(datetime,N'$',112)</expression>

	</filter>


	<filter type="column" id="documentDate" operator="AND" whenParameter="days" is="ne" tovalue="">

	<expression operator="ge" expr1="days" filtervalue="$">
	dateadd(dd,-$,getdate())</expression>

	</filter>


	<filter type="static" operator="AND" whenParameter="questionSearchtype" is="eq" tovalue="1" codeflag="B">
	caseTypeRecno=100007</filter>


	<filter type="static" operator="AND" whenParameter="questionSearchtype" is="eq" tovalue="2" codeflag="C">
	caseTypeRecno=100007 and activityTypeRecno=100013 and activityStatusRecno in (16,100060,100061,100062,100063)</filter>

	<filter type="static" operator="AND" whenParameter="questionSearchtype" is="eq" tovalue="3" codeflag="C">
	caseTypeRecno=100007 and activityTypeRecno=100041 and activityStatusRecno in (16,100150,100151,100152,100153)</filter>


	<filter type="static" operator="AND" whenParameter="questionSearchtype" is="eq" tovalue="4" codeflag="A">
	documentCategoryRecno=100044</filter>

	<filter type="static" operator="AND" whenParameter="questionSearchtype" is="eq" tovalue="5" codeflag="A">
	documentCategoryRecno=100045</filter>


	<filter type="static" operator="AND" whenParameter="statusAnswer" is="eq" tovalue="1">
	answerExists=1</filter>

	<filter type="static" operator="AND" whenParameter="statusAnswer" is="eq" tovalue="2">
	answerExists=2</filter>


	<filter type="column" id="contactRecno" operator="AND" whenParameter="inquirer" is="ne" tovalue="-1" codeflag="D">

	<expression operator="eq" expr1="inquirer" filtervalue="$">
	$</expression>

	</filter>


	<filter type="filter" operator="AND" whenParameter="rss" is="eq" tovalue="1">

	<filter type="static" operator="AND" whenParameter="actualPort" is="ne" tovalue="81">
	substring(documentRestriction,2,1)!='H'</filter>

	</filter>



	</whereSection>

	</wsConfig>