What all i learnt today

 Simply in the recording controller, choose type as "JAVA", setting is isn very down section of recording controller

  What is RSAT? How to donwnload/Install and use of the same what is DMF What is oData How to get the tables names of any form How to get DB Creds How to Connect to DB and Write SQL Commands How to Create Users How to Add Roles to Users What is perosn/Employee how it is linked t a store/warehouse etc. how to use advanced find filter in CRM

  for dates simply pass date without any quotes $filter=Birthday eq 2017-12-31 for any special type of data use its entity property: like 'Microsoft.Dynamics.DataEntities.NoYes' Find the Entity type and pass it From <https://learn.microsoft.com/en-us/odata/webapi/date-timeofday-with-entity-framework>  https:/XYZ/data/SystemUsers?$top=1&$filter=IsRetail eq Microsoft.Dynamics.DataEntities.NoYes'No'

In order to group the data with 10 minutes bucket of date, use following SQL: Group by 10 Minutes SQL Server select count(*), DATEADD(MINUTE, DATEDIFF(MINUTE, '2000', SUBMITTEDDATETIME) / 10 * 10, '2000')  AS [date_truncated] from ThawTable where  cast(ThawingDate  as date) = cast('2022-03-21' as date) and THAWQTY <> 0  group by status,DATEDIFF(MINUTE, '2000', SUBMITTEDDATETIME) / 10 order by 1 desc;