How to get the count of data loaded from multiple tables post-data conversion?
Do you have to get the data counts from multiple tables in an easy way? Have you reconciled data post data conversion? Read on to know more details.
All posts on Sample SQL Queries
How to get the Audit History of the changes done by a user?
Do you know how to access the audit history of table level changes done by a user? Read on to know more details.
How to get list of Fast Formulas used in HCM Extract?
Do you know how to get the Fast Formulas used in a HCM Extract? If there are multiple Data Groups and multiple Records, it will be tough to get the list manually? This SQL query comes as a saviour in those tough times to get the list easily. Read on to know more details.
How to extract the Sandbox, features enabled, and published status?
Do you know if there is a way to extract the sandbox details and what all sandboxes are published recently? Who published them? Read on to know more details.
How to fetch the Employee Degrees from the Skills and Qualifications screen?
Do you know how to fetch the Employee Educational details/degrees from the Talent Profile tables? Read on to know more details.
How to check the Approval Rule status using BI Report?
Do you know how to fetch the Approval Rule status using BI Report? Can we retrieve the list of all Approval rules that exist in the system? Read on to know more details.
How to get Dynamic Default for Payroll Period LOV based on the system date?
Do you know how to assign default values to a BI input parameter based on the system date? Read on to know more details.
How to extract the Element Eligibility Info from Element Config?
Do you know how to extract the element eligibility information and the criteria that has been defined as part of Element Config? Read on to know more detials.
How to fetch the Employee Social Insurance Calculation Card details for AE legislation?
Do you know how to fetch the Employee Social Insurance Calculation Card details for the AE Legislation using SQL Query? Read on to know more details.
How to get the list of all BI Reports from an instance?
Do you know how to extract list of BI Reports from an instance? Read on to know more details.