Display data from data page.

[OleksandrB4906 (Oleksandr Bereza)]

I have case type, where i collect customer information (including fields like: first name, last name, dob, phone, email), and have data named “customer” where i save all this information.

Then i have stage, where customer want know birthdays of other customer by selecting from dropdown months, which i created by myself.

So, I don’t know, how to display data from that data page when user select for example April, how am i need to source my data page, if it was only “date only” type for DOB, but in dropdown list which i created i have 12 month named by myself.

Additional information: in the stage “birthday” i created process collect info about month, with field “Month” type: picklist. In the section collect info about month, i’ve used new property month, with ui control pxDropdown, with table type prompt list, and typed in prompt values all 12 months, so what i should do next? Am i need configure repeating dynamic layout, if yes, how should i source info in my data page records and how validate, when user selects in this picklist some month, and i want to display him all records that includes selected month by user.

[ShyjuValappil]

@OleksandrB4906

You can achieve the requirement as below,

1. In the prompt list you can give key as month number as 1,2,3,and Prompt value as Month name.

2. Source data page using Report Definition. Add parameter “Month” of type Integer for both Data Page and Report definition. Pass the selected Month number from dropdown to Data Page as parameter.

3. In the report definition apply the filter using function The month number of [Date Value]. Please see screenshots below.

4. You can use either Table or Repeating dynamic layout by sourcing Data Page.

[OleksandrB4906 (Oleksandr Bereza)]

@ShyjuValappil
So thankful for good explanation, Found this solution later in the night, but still thank you!