ContributionsMost RecentMost LikesSolutionsRe: Extract_Data_System Thanks J Jones, it worked, appreciate the help ! Extract_Data_System I can extract data by using SQL in the System and Application Tables, but I don't know how to extract the Data from the System Tab -> Logging -> Logon Activity, Task Activity or Error Log. If I choo...SolvedInformation for the table fields XFW_OSD_Envtablesizes, XFW_OSD_Apptablesizes Hi Everyone, These tables house information about the Environment tables, and also the Application Tables. It would be ideal to have not only know information on the fileds in these 2 tables mainl...Re: Parameter for SQL Krishna, it worked, I don't understand the syntax '" & Date & "' Thanks so much for your help, I really appreciate it. Tom Re: Parameter for SQL I currently have the value hardcoded in the SQL, but wanted to create a parameter if possible. Thanks for your help, I really appreciate it. Re: Parameter for SQL Thanks Krisna, I was thinking of creating a parameter like "As of Date", and not a workflow parameter, and then bringing in my parameter into the SQL, right now SQL does not recognize the Parameter...Parameter for SQL When I have a BR, and need to pull in a parameter, I use the following statement or one similar, I create the parameter in a Dashboard. 'Dim scenario As String = BRApi.Dashboards.Parameters.GetLite...SolvedRe: SQL Query to External Table We are on version 6.8 and upgrading soon to 7.4 Re: SQL Query to External Table Snowflake DB, and here is the error I"m getting when running. Error processing Data Management Step 'Load_FDH_Employee_GL_Actuals'. Unable to execute Business Rule 'FDH_To_OS_Refresh'. ERROR [42000...Re: SQL Query to External Table Snowflake DB. Here is an error when enclosing in [] Error processing Data Management Step 'Load_FDH_Employee_GL_Actuals'. Unable to execute Business Rule 'FDH_To_OS_Refresh'. ERROR [42000] SQL co...
