how to set a filter to an information link for yestarday

[Enkeled Kanaj]

Hi,

 

Anyone can help how to filter here in the information link a value for yesterday. in custom query sql of the syntax today(*)-1 is ok but in the IL which is the syntax?

 

Thank you!

 

[Vanessa Virginia Sucre Gonzalez]

Hi,

Assuming you have a column within your data table with "today's date" (ex. Now()), you can create a filter element as follow:



Where Today holds today's date.

Now, Add the filter to your information link:

 

[Enkeled Kanaj]

On 7/11/2024 at 11:08 PM, Olivier Keugue Tadaa said:

Thanks for your feedback. 

 

11 minutes ago, Vanessa Virginia Sucre Gonzalez said:

Hi,

Assuming you have a column within your data table with "today's date" (ex. Now()), you can create a filter element as follow:



Where Today holds today's date.

Now, Add the filter to your information link:

 

Hi Vanessa,

 

How can I create the today as filter because I do not have it?

This trick works for me but I do not like it:

SELECT
   D1."ERBS" AS "ERBS",
   D1."DATE_ID" AS "DATE"
FROM
   "DC_E_ERBS_EUTRANCELLFDD_DAY" D1
WHERE
   (date_id = today(*)-1)
   AND <conditions>

[Vanessa Virginia Sucre Gonzalez]

Hi,

Just go to the main panel, select filter

Now, add the column directly from the data source table:

You have to change the expression (1% is mandatory, it's your column's placeholder).
I see you are using Oracle, so the expression would be %1 - 1

 

Now you save the filter, and add it to your information link:

[Enkeled Kanaj]

Either this way works for me by taking your idea: