topic Re: property expression: show the ID belong to "from zone nr"-zone in door property.... in Collaboration with other software

property expression: show the ID belong to "from zone nr"-zone in door property....

Anonymous — Fri, 12 Jul 2019 19:13:51 GMT

Hello to everybody ,

I need a property expression, which will show the element-ID of the zone, which belongs to the door via "from zone number"-property.

I need the element-ID for matching the doors and zones in an existing FM-system-database... - so I have to get the ID and not the zone-number for door propertys "from-zone-number" and "to-zone-number".

If anybody of you have an idea, how to realise this challenge - PLEASE let me know...

...if you have a better solution than using 'property expressions' - I am open minded to any method, which can grab the expected values...

I really hope you can help me,

Best regards from Vienna,
Klaus

Re: property expression: show the ID belong to "from zone nr"-zone in door property....

Anonymous — Sat, 13 Jul 2019 13:06:31 GMT

...in 'simple' SQL it would be something like:

SELECT 'element_id' FROM [zones] WHERE 'zone-number' = 'gs_zoneinside-number'

I hope this will describe a little better, what I need than my statement above ...

Best regards from rainy Vienna ,
Klaus

Re: property expression: show the ID belong to "from zone nr"-zone in door property....

fuzzytnth3 — Mon, 16 Sep 2019 14:05:51 GMT

There is a "Zone To" property

https://my.pcloud.com/publink/show?code=XZnU8HkZrG0t7fn3Abzy7cu5d0sbDpDMrOzX

Hope that helps