REXYGEN Community Forum / SQL query with variables

Re: SQL query with variables

2016-09-02T10:04:44Z

Hi Adam,
it will be weeks. A single-digit number of weeks.

Jaroslav

Re: SQL query with variables

2016-08-30T17:20:08Z

Hi Jaroslav,

Are you able to give me rough idea on a timeline for the new version; i.e. weeks or months? It would be good to know whether I should use a workaround for now, or just wait till the new release?

Cheers,

Adam

Re: SQL query with variables

2016-08-29T05:37:47Z

Hi Adam,
very good question! This is not possible in the current version. The good news is that it is already implemented in the new version which we are finalizing.

Jaroslav

SQL query with variables

2016-08-26T16:04:39Z

Hi,

If I want to run the MSSQL query below to pull data from a database, but for example have 'room_id' and 'function_status_id' defined from within a task (i.e. have a CNI block within the task to assign room_id), is that possible, and if so how?

SELECT COUNT(*) as Occupied FROM ev_functions WHERE room_id = 6 and DATEADD(HOUR,-3,GETDATE()) > from_date_time and GETDATE() < to_date_time and function_status_id = 6

Cheers,

Adam