Filter on 'Get All Sites'

[Alisha]

Hello,

I want to create a 'New location' field that uses the Get All Sites Data Query on a progressive capture. I would like to filter it based on the Site Type because I don't want all the sites to show. For example, if I don't want Private Property locations to show.

How can I do this please? I know there is a Filter option, but if I enter the Site Types that I want to use, it doesn't work.

Many thanks,
Alisha

[Conor]

Hi @Alisha

I have been through and tested this along with a couple of the developers here, and it is definitely a 'Default Value' field rather than a filter at the moment. This has been raised and the label will be changed ASAP.

However, in terms of your requirement for a custom filter, we are very much aware of how useful this will be to our customers and as such we are planning to build in this functionality. From what I understand we are currently deciding how to best introduce it to the system, so as and when we are able to work on this and we have an idea of timeframes we will post back here to let you know. 

Kind regards

Conor

[Alisha]

Hi @Conor,

I have another query regarding filtering on Sites.

I'm using the Get All Sites Data Query and would like to filter it on the site 'State'. How could I do that please?

Many thanks,
Alisha

[Gareth Cantrell]

Being able to use the "Filter Sites" field as a filter rather than a default value would really help us.

Right now, we have to use a custom field to hold the site (office location) and then transfer that value back into the Site field using a node in the BPM.