dashboard not refreshing not until I reload data table.

[Iredia Osadolor]

I am not sure why my query is not referreshing on spotfire dashboard,I would have to reload the data table before it updates. I am using version 10.3.3.42.

Just to clearify my question.

I have a few queries that I've loaded from SQL servers to spotfire dahsboard. They all refresh except for one query. I can however refresh it manually by right-clicking the query and hitting reload data table. How come this specific query is not included in the refresh and what can I do toresolve it moving forward

Below is the sql query

SELECT DATEADD(wk, -1, DATEADD(DAY, 6-DATEPART(WEEKDAY, [****].[****].Timestamp), DATEDIFF(dd, 0, [****].[O****].Timestamp))) as 'FirstDayOfWeek'

,[****].[****].planned

,LEFT([****].[****r].FunctionalLocation, 9) as ****PadFloc

, [****].[****r].FunctionalLocation

, [****].[****].WellName

, datepart(wk, [****].[****].timestamp) as TimestampWeek

, datepart(yyyy, [****].[****].timestamp) as TimestampYear

, [****].[****].****Legacy

, [****].[****].Timestamp

, SUM(Variance) * -1 as 'Variance'

, [Where]

, Why

, (SUM(Variance) * -1) / AVG(a.TotalProduction) as 'PctLoss'

, [****].[****].FieldOperationsArea

, StatusActions

, PctTgt = Case [****].[****].****Legacy

WHEN 'Bakken' Then .035

WHEN 'Legacy' Then .115

END

FROM [****].[****]

LEFT JOIN [****].[****] ON [****].[O****].PraNumber = [****].[****].PraNumber

LEFT JOIN (SELECT SUM(Production) as TotalProduction

,[****].[O****].****Legacy

,Timestamp

FROM [****].[****]

LEFT JOIN [****].[****] ON [****].[****].PraNumber = [odr_nd].[****].PraNumber

WHERE Production > 0

AND [****].[****].Timestamp >= dateadd(d,-360,getdate())

GROUP BY [****].[****].****Legacy

,Timestamp)a ON [****Timestamp = a.Timestamp and [****].[****].****Legacy = a.****Legacy

WHERE [Where] IN (

'Pumping Unit'

)

AND WHY not in (

'Bottleneck'

,'3rd Party'

,'Obstruction'

)

AND [****].[O****].Timestamp >= dateadd(d,-360,getdate())

AND [****].[O****r].Status = 'PD - Producing'

AND Variance < 0

AND UpDown = 'D'

AND Why IS NOT NULL

GROUP BY [****].[O****].BakkenLegacy

, [****].[O****].timestamp

, [Where]

, Why

, [****].[****r].WellName

, LEFT([****].[O****].FunctionalLocation, 9)

, [****].[O****r].FieldOperationsArea

, StatusActions

, Planned

, [****].[O****].FunctionalLocation

[Shandilya Peddi]

From the Data Canvas section can you check if the data table's data loading settings is set to Always New Data or Stored Data,

https://docs.tibco.com/pub/sfire-analyst/11.1.0/doc/html/en-US/TIB_sfire...

If it is set to Stored Data then changed to Always New Data or NewData when Possible

[Iredia Osadolor]

Thanks for your answer. But it was already set to Always New Data. However, i changed it to NewData when Possible just to give it a try to see if it will work. I will have to see if it refresh this friday cause i set it to refresh every fridayson the query.