Hayasaka Kenichi
Rank: #22057
23Views
7Comments
Is it possible to filter by Year and Month using Date picker
Discussion
Traditional Web
Application Type
Traditional Web

I have 4 Table Records in one web screen.I used date picker all of the tables. After all, want to filter by Year Combo box and Month Combo box. i.e want to retrieve data by searching 2021 Year  Jan  from all of the tables in one web screen.

Is it possible?

Hayaska

0
0
on 8th Feb
Copy link to comment
Sachin Waghmare
Rank: #311

Hi Hayasaka,

What I understand from your comments is that you want to populate the data into 4 Table Records based on the Year and Month Combo box. So, you need to add a filter condition into the aggregate by which you have bound the Table Records. Below is how you can add a filter condition and pass the Year/Month variables to filter the records.

Thanks & Kind Regards,

Sachin

1
0
on 8th Feb
Copy link to comment
Hayasaka Kenichi
Rank: #22057

Hi Sachin, thanks  for your advice.

I will try it  


0
0
on 8th Feb
Copy link to comment
Hayasaka Kenichi
Rank: #22057

Hi Sachin, Can I  receive checking my oml from you please?

SalesManagementtestforask.oml

0
0
on 9th Feb
Copy link to comment
Sachin Waghmare
Rank: #311

Replying to Hayasaka Kenichi's comment on 09 Feb 2021 04:28:22

Hi Hayasaka,

I have made some changes to the SaleDiffTableRecord screen and also to the Search action, but not able to publish and test due to some dependencies issues. 

Could you please try to test at your end and confirm, if you are able to achieve what you are looking for  :)

Thanks & Kind Regards,

Sachin

SalesManagementtestforaskSachin09.oml

1
0
on 9th Feb
Copy link to comment
Hayasaka Kenichi
Rank: #22057

Replying to Sachin Waghmare's comment on 09 Feb 2021 10:14:59

Hi Sachin, I checked updated oml.It's really worked. Thanks for your patient.

Hayaska

0
0
on 10th Feb
Copy link to comment
Tom Zhao
Rank: #297

Hi Hayasaka, 

Sorry, I do not understand your question.

Can you provide more detailed information?

What do you want to achieve? What is the problem?

Kind Regards,


0
0
on 9th Feb
Copy link to comment
Hayasaka Kenichi
Rank: #22057

Hi Tom Zhao, thanks for your attention.

I'm trying to filter with Year and Month in Search Action, but in one web screen , four table records in which I used Date Picker Widget in each record for input Date. For example,if I select 2021 from year combo box and Feb for month , want to show 2021 year Feb data from all of the tables below like screenshot.For that, I created in SaleDiffTableRecord Web screen and confusing for implementing Search Action.Can I receive checking my oml  from you? 

Thanks

Haysaka

SalesManagementtestforask.oml

0
0
on 9th Feb
Copy link to comment