18
Views
11
Comments
Solved
Date Range Picker Reactive

Hi,


I have a table where I have a date type attribute

I am using this "demo" to search for dates.

https://www.outsystems.com/forge/component-overview/9758/date-range-picker-reactive

How do I connect the datapicker to my table?

And how do I change the date format to dd-mm-yyyy?


Thanks

Rank: #286
Solution

Hi SpiritFox,

I checked your OML and made some changes in GetTrocas2 aggregate, DateRangePickerComboSelectedDate action and also tried again to put DatePicker block by removing previously added(Now started showing dates).

 it is working fine now and also the SUM attribute is showing values as per the selected time intervals.

Checkout working demo on the following link, Hope this is what you want.

https://shweta-gedam.outsystemscloud.com/TrocasProdutos/Trocas

And also attached working OML herewith.

Hope it helps :)

TrocasProdutosv1.0.3.oml

mvp_badge
MVP
Rank: #17

Hi SpiritFox,

See the following screenshot:

You can set the DateFormat (hover on the DateFormat property to see all options).

You can set the StartDate and EndDate to attributes from an aggregate.

See attached module that demonstrates how to add/edit date ranges to an entity using the date range picker.

Regards,

Daniel

ReactiveDateRangePickerExample.oml

Rank: #2649

Hi, Daniel,


I am doing something wrong.

I only have a date attribute. In your example you have two


And i dont need a button to save

I would like to select the date, then automatically do the search

Thanks

Rank: #286

Hi SpiritFox,

Please find the attached OML and check if this is what you want . Please also check all the properties set in the date picker dropdown and filters added in aggregate. 

For custom, if you want to search for only one date, you need to select this date twice and then click outside the dropdown.

Here is the link given for your reference:

https://shweta-gedam.outsystemscloud.com/DatePickerSearch/DatePickerSearch?_ts=637450199121999147

Hope it helps, Thanks :)

DatePickerSearch.oml

Rank: #2649

Hi Shweta,

(I don't have access to my PC right now, I can't open your file)

I think that's what I want! Thanks


Tell me, I don't need this

It will work fine without this?


I think it is a bug; when I select the "custom" option I can't search the days before today. If you select another option and go back to "custom" it already gives

Thanks a lot for your help

Rank: #286

Hi SpiritFox,

1) You don't need to add following block, i  had added it just to insert some entries into the table for demo.

It will work without this :)


2) I think it is a bug; when I select the "custom" option I can't search the days before today. If you select another option and go back to "custom" it already gives 

     - Verify in your screenshot that you have December 2019 month calendar opened on the left and by default it is not allowing to select date before 31Dec2019. In this case, you can set a minimum date in 'MinDate' property of Date Picker as showed in below picture to allow the user to select dates from a defined MinDate.

 You can select dates before today in 2020 calender using '>' this icon.


Thanks, Happy Learning :)

Rank: #2649
Rank: #286

Please let me know if it works for you and if yes, please marked my answer as solution so that it would be helpful for others who came with same issue :)

Rank: #2649

I have a doubt...


I have a table where I have an expression that sum ..... When selecting a time interval it will only sum the values of that interval or will it sumeverything?

I will need you to do both situations but on different screens

https://www.outsystems.com/forums/discussion/67112/aggregate-a-column-into-a-single-value/


Rank: #2649

I'm doing something wrong and I can't understand what!

Can you check?

TrocasProdutosv1.0.3.oml

Rank: #286

Hi,

I can see in your date picker, I am getting something like below, Is it same happening with you?

Rank: #286
Solution

Hi SpiritFox,

I checked your OML and made some changes in GetTrocas2 aggregate, DateRangePickerComboSelectedDate action and also tried again to put DatePicker block by removing previously added(Now started showing dates).

 it is working fine now and also the SUM attribute is showing values as per the selected time intervals.

Checkout working demo on the following link, Hope this is what you want.

https://shweta-gedam.outsystemscloud.com/TrocasProdutos/Trocas

And also attached working OML herewith.

Hope it helps :)

TrocasProdutosv1.0.3.oml