REXYGEN Community Forum

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

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

---

Monarco HAT for Raspberry Pi - Lightweight I/O for monitoring, archiving and control.
Raspberry Pi in industrial automation!

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

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

---

Monarco HAT for Raspberry Pi - Lightweight I/O for monitoring, archiving and control.
Raspberry Pi in industrial automation!