Closed
Business Days calculation in Report definition using function alias
Hello Team,
We have tried using below code in Function Alias and referred in Report Definition. We are getting the attached error while running the Report definition.
{1} = from_date
{2} = to_date
select count(d::date) as d from generate_series({1}, {2}, '1 day'::interval) d where extract('dow' from d) not in (0, 6)
Thanks,
Niti
***Edited by Moderator Marissa to update Platform Capability tags****
To see attachments, please log in.
Posted: 3 years ago
Pegasystems Inc.
GB
From the screenshot the following error can be seen:
"A Rule Alias Function cannot reference a SQL function that performs a sub query. Function Businessdaycal contains valid syntax of SQL Select format."
But the SQL posted doesn't obviously contain any sub query.
Can you please run a TRACER to see if you can get more information about the issue.
Additionally: what DB vendor/version are you using here?