So I'm kind of new to Xmod Pro and I need to make a RSS feed showing some news items from a list out of the database.
But what every i do the RSS feed shows up empty. But if i look at the source is does show the correct items.
So here is what i have made:
---------------------------------
<xmod:Feed ContentType="text/xml">
<ListDataSource CommandText="SELECT ListId,ListItemId,PropertyId,Value FROM S22_ListItem_Properties_Strings WHERE listId=43 and PropertyId=372" />
<HeaderTemplate><?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
<channel>
<title>TTN</title>
https://www.agrifirm.com</link>
<description>test</description>
</HeaderTemplate>
<ItemTemplate>
<Item>
<title>[[Value]]</title>
<link>[[ListItemId]]</link>
<description>[[PropertyId]]</description>
</Item>
</ItemTemplate>
<FooterTemplate>
</channel>
</rss>
</FooterTemplate>
</xmod:Feed>
------------------------------------------
And here is the RSS link:
https://www.agrifirm.com/DesktopModules/XModPro/Feed.aspx?xfd=TTNNEW&pid=1
If you look at the source of the page is will show items. What am I missing?
-------------------------------------
And i do have a other question.
The news items are stored in the database with the description and title in one table, but in de same row.
Like this:
Id: 1; ListItemId: 201; PropertyId: 1; Value: Title of item;
Id: 2; ListItemId: 201; PropertyId: 2; Value: Discription;
Id: 3; ListItemId: 425; PropertyId: 1; Value: Title of item;
Id: 4; ListItemId: 425; PropertyId: 2; Value: Description;
Can I combine them with rules. Because the ListItemId contains the matching number for the title and description and the PropertyId contains the "type" of item. (So, 1 is Always a title and 2 is Always a description)