Sorting RSS data source in asset list

(Neil) #1

Morning,

There seems to be several posts on sorting RSS feeds by one of the data fields but I can’t seem to make it work.

I have an RSS feed that looks like this:

<channel>
	<item>
		<link>//</link>
		<title></title>
		<description>/description>
		<pubDate>2018-02-21T00:00:00</pubDate>
		<guid> </guid>
		<closingDate>2018-12-31T11:59:00</closingDate>
		<advertText>
			<![CDATA[
			....
			]]>
		</advertText>
	</item>
	....
</channel>

and want to sort the list by closingDate

I have an RSS data source and have removed all sort options except for a Sorting by Asset Keyword Value which I’ve set as %ds__closingdate^date_format:Ymd% and use that as the default sort.

Whatever happens now the shadow assets just get displayed in order. I.e.
testjob
50578:0 20181231
50578:1 20180704
50578:2 20180703
50578:3 20180705
50578:4 20180705
…

Do I need to refer to %ds__closingdate% differently when sorting on the value as this is relative to the current asset rather than data source value?

Any ideas would be much appreciated.

Thanks.

Matrix Version:5.3.4

(Bart Banda) #2

Have you tried using an asset listing to list and sort the data records instead?

(Neil) #3

Yes. Sorry if that was unclear.

The sorting I was trying to describe is done the Asset Sorting screen of the Asset listing.

Cheers

(Tbaatar) #4

I have external RSS feeding sorting working.
Did you make sure to remove the percentages?

Screen Shot 2018-07-03 at 19.37.17.png1968x248 23.5 KB

(Neil) #5

Ace. User error.
In my defence, our version of the GUI doesn’t show the % signs on the box!

Many thanks.