JS
Hello,
We use MZ 1.01 since some months. Among other things we have created some history statistic MashUps with data from last year: day, week, month and other ranges.
The calendar functions are sparsely in MZ. Therefore we've created a little calendar source and a datafeed to work with it.
In fact I've just about to publicize this solution for all in this forum.
But suddenly there are some problems:
I connect my calendar Datafeed with select boxes. These are the filter for some charts a.s.o.
All works fine, we can select date ranges with current dates, day of the week....
But, if the GUI of the MashUp is on screen for some minutes and then you press "Refresh Data" -Button, the filter and selects are lost. The current date is shown in the select box, but empty parameters are going to the associated components. The red warnings are shown, because the datafeeds (webmethods IS SQL services) don't work with empty date parameters and the datafeeds are empty too.
You must set the select boxes again.
What happens with the lost selected settings after some time and if you press "Refresh.."?
Any idea, what happen?
Shall I post my solution (Test MashUp + DF) here?
with regards
Jörg
Hello Jörg,
based on the info you provide it is hard for me to reproduce the problem. However posting your MashApp is difficult, too, as your webMethods back end data source is not available to me.
MashZone offers two ways to filter for dates the
- date picker for year/quarter/month selections and
- date input filed to select days explicitly (when using this make sure its component properties are set to the proper data type)
.PNG)
I assume lost selection states after reloading occur just as one of the data feed results has changed. If there was a list of regions (North, East, West) where North has been selected and the underlying source updates to (East, West, South) the selected state will be lost.
Regards
Stephan
THX for your reply
I must admit that I didn't know the datepicker of the input field. But there are some reasons to create an own calendar:
- the default dates (today or range to the past) should on the screen without userinput
- no filter, because the SQL queries, that deliver the datafeeds should work as fast as possible (parameters with start and end date are pass to the services) and MZ data overflow lurks (over 10000 records) in a full range
- the day of the week should stay on the screen, it is important for the charts explanation to know weekend
I don't know, whether it's clever or not - but it works.
First I've create a Excel sheet with dummy data for one year backwards and an index field.
.png)
Then I've created a DF "Kalender".
First the Excel tab 1 with the described data is drilled. An "Information" field provide the today's date.
This is flowing into first column ("Replace Value").
Then "Move Date" is used with direction "Backward" and the Value "Abb" (second col) by day.
For a specified use the date col is copied and converted to data type text.
.png)
Our calendar should completed now with the day of week.
On web page of Manfred Wilzeck I've found some top tips to
calculate some important dates and other arithmetics.
On the link "http://manfred.wilzeck.de/Datum_berechnen.html"
there is on part (6) a "easy" calculation of "Day of the week" with the
help of today and some constants. This constants I've parking on tab2 of my Excel file.
.png)
This is the second source of my DF. The first source is splitted the date col into cols "Monat" "Jahr" "Tag" and convert it to data type number. The first and second source is combined to calculate the values and the constants. Now we can calculate the day of week and put it into a new col as number. I've add a little round correction, don't know why, but it works.
.png)
With a simple replace operation there is finally our day of week in the right col and row.
(0 = Sunday, 1 = Monday..)
How to use this feed now? First little example, Show Date, Time and Day of Week in a
headline of a mash with a refresh of < 1 Minute as a headline of my master view:
Second, to set an input for an interval I use, the DF with Selection boxes to filter charts
or pass parameters to data feeds for xml or SQL queries (passed by webmethods services).
.png)
"Abb" you can use the start ranges of select boxes. So, thats all!
regards Jörg
