sorting by date value attributes

[Former Member]

Hi SDN gurus,

can somebody pls help me in the following scenario,

I have a value node with three attributes called date,time and value in it

in the runtime the value nodes will have the following record

date time value

============================

11/05/2010 23:37 black

12/05/2010 23:37 black

13/05/2010 23:37 black

14/05/2010 23:37 black

now my issue is I want to find out the latest date and display the record

like my output should be

14/05/2010 23:37 black

can somebody pls point some code snippet on how to find the latest day and fetch record associated with it

Thanks in advance

RAD

[Former Member · Accepted solution]

Hello RAD

If you told about Data manager - Yes

You can use Search menu for select your taxonomy and into taxonomy select date and it latest value

You can select date field in main records menu and order it

You can use free form search->expression for set expression formula

If you told about standart package for NW Portal - Yes

If you told about MDM API - Yes

Regards

Kanstantsin Chernichenka

[Former Member]

Hi Rad,

I have a value node with three attributes called date,time and value in it

By node, do you mean In a main table, a record which has some category say XYZ and this category is linked with three Attributes having Attribute Names as date, time and value.

Or is it a field in main table which has value as combination of 11/05/2010 23:37 black ?

Can you please make it clear and elaborate more about your requirement..?

Regards,

Mandeep Saini