Need inputs to get the number of Payrolls between the Period start date and period end date — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need inputs to get the number of Payrolls between the Period start date and period end date

edited Aug 7, 2019 2:24PM in HCM Integrations 2 comments

Content

Hi All,

We have a requirement to find the number of payrolls in between the period start date and period end date through FF. 

Ex: Period start date :01-Aug-2019

Period End Date:31-Aug-2019

Payroll Name:XYZBIWeekly.

Expected Output:3

To achieve this requirement we are unable to find the DBI's from the FF so that we developed below SQL query to be used in a value set and call from FF but we are unable to use aggregate functions in value set.

Any inputs to achieve this requirement from DBI's in FF or through Value set.

SELECT a.abc

FROM

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!