There is no limit for the string length defined.
It is also possible to use a query string with a list of several thousands dp elements. Some time ago I have made a test with 300.000 elements in the FROM clause and it worked.
If you are using a dpQuery with a TIMERANGE condition the query is answered by the data manager. The event manager does not do anything in that case with the query.
Which type of query have you been using when the event manager was blocking?
How did the query string look like?
Best Regards
Leopold Knipp
Senior Support Speclaist
How do i get the changes of all datapoints that I have in a dyn_string over a specific period of time
- leoknipp
- Posts:2928
- Joined: Tue Aug 24, 2010 7:28 pm
Re: How do i get the changes of all datapoints that I have in a dyn_string over a specific period of time
- RudiKreiner
- Posts:198
- Joined: Mon May 16, 2011 2:10 pm
Re: How do i get the changes of all datapoints that I have in a dyn_string over a specific period of time
I retried the query with FROM 'DPGROUP(_DpGroup00018_Public)' because 18 is the number of MyGroup. It works now, thanks Leopold 
My query command looks basically like this, only the comma separated list of datapoints in the FROM parameter gets a lot longer of course:
dyn_dyn_anytype tab;
dpQuery("SELECT ALL '_original.._stime', '_online.._value' FROM '{ExtCox001.MelDrv001.SpdActTg_Stt,ExtCox001.MelDrv001.SpdClnStt,ExtCox001.MelDrv001.SpdJogStt,ExtCox001.MelDrv001.SpdSetMaxStt,ExtCox001.MelDrv001.SpdSetMinStt,ExtCox001.MelDrv001.SpdSetStt}' TIMERANGE(\\"2017.03.13 12:49:00\\",\\"2017.03.13 12:49:00\\",1,1)", tab);
I didn't want to play around with the command too much because others are working on the project to and they get irritated if I keep hanging up the event manager
If you have any tips on what I should try or watch out for I can do that on another server where hanging, crashing, killing and restarting doesn't bother any else.
My query command looks basically like this, only the comma separated list of datapoints in the FROM parameter gets a lot longer of course:
dyn_dyn_anytype tab;
dpQuery("SELECT ALL '_original.._stime', '_online.._value' FROM '{ExtCox001.MelDrv001.SpdActTg_Stt,ExtCox001.MelDrv001.SpdClnStt,ExtCox001.MelDrv001.SpdJogStt,ExtCox001.MelDrv001.SpdSetMaxStt,ExtCox001.MelDrv001.SpdSetMinStt,ExtCox001.MelDrv001.SpdSetStt}' TIMERANGE(\\"2017.03.13 12:49:00\\",\\"2017.03.13 12:49:00\\",1,1)", tab);
I didn't want to play around with the command too much because others are working on the project to and they get irritated if I keep hanging up the event manager
If you have any tips on what I should try or watch out for I can do that on another server where hanging, crashing, killing and restarting doesn't bother any else.