Announcement

REXYGEN forum has been moved. This one is closed.
Head over to the new REXYGEN Community Forum at https://forum.rexygen.com.

Looking forward to meeting you there!
 

#1 2016-08-26 17:04:39

ad_t
Member
Registered: 2016-05-09
Posts: 52

SQL query with variables

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

Offline

#2 2016-08-29 06:37:47

jaroslav_sobota
Administrator
Registered: 2015-10-27
Posts: 535

Re: SQL query with variables

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

Offline

#3 2016-08-30 18:20:08

ad_t
Member
Registered: 2016-05-09
Posts: 52

Re: SQL query with variables

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

Offline

#4 2016-09-02 11:04:44

jaroslav_sobota
Administrator
Registered: 2015-10-27
Posts: 535

Re: SQL query with variables

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

Jaroslav

Offline

Board footer

Powered by FluxBB