How to set time range from current year to max year from data source

[Szymon Mon]

Hi,

I created IronPython script where set range of time which is available to show on the report but there is one drawback, the year are hard coded.

I have column called "Dates" which has of the type as datetime. Based on it created new column which extract year from date and its date type is integer. It is called "Year" in below code.

I would like to change "Year" filed to "Dates" and set Values as shown on the right side of last line: year(DateTimeNow), Max(Dates)

from Spotfire.Dxp.Application import Filters

from Spotfire.Dxp.Application.Filters import RangeFilter,ValueRange

from Spotfire.Dxp.Application.Filters import FilterTypeIdentifiers

from System import DateTime

from System.Globalization import CultureInfo

myPanel=Document.ActivePageReference.FilterPanel

myFilter=myPanel.TableGroups[0].GetFilter("Year") --> Dates

lblFilter=myFilter.FilterReference.As[RangeFilter]()

lblFilter.ValueRange=ValueRange(2019, 2029) --> (year(DateTimeNow), Max(Dates))

[Khushboo Rabadia]

You can create two calculated columns in your table with current and max year or have those columns in your information link.

In your python script, you can just extract the values of two columns from first row using DataValueCursor and break the loop using break; statement once the first row values are extracted:

https://community.spotfire.com/wiki/how-retrieve-table-column-values-tibco-...

 

for row in table.GetRows(cursor,cursor1):

current = cursor.CurrentValue

maxdate = cursor1.CurrentValue

break;