Need help by creating SQL Filter dataset ticker of employees birthday

Get Help
1

Dear Community,

Please can you help me with creating a SQL filter regarding dataset ticker.
I have the following columns: ID, Date, Birtday(layout).

The rows are as followed:
CURRENT WEEK–> Row 1: ID: 17, Date: 24-10-2023(Dutch time notation), Jarige:
With following filter i can show current week:WEEK(Datum, 1) = WEEK(CURDATE())

What i want is creating a filter that shows the layout by current date. Its for showing birtsdays layout.
Maybe using a dataset is not the right option. But what i want is that layouts are shown based on current day and that these are shown in the campaign. When current date is equel to date of the birthday of an employee it should be shown in the campaign, when not the normal campaign should loop.

Best Regards,

Tim

2

I have done with dataset in v3 not in v4 :worried:, see this link CMS 4.0.0-beta released - #33 by samsulbahri or you can see this video https://youtu.be/2WRBtZorj18

Xibo dev-team
Both of these things are road mapped for improvement in 4.1 towards the end of the year.

Best regard
Sam

3

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.