Udtræk af §20-spørgsmål (XML)

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>