I would like to change the search "path" from a dropdown list.
I've given another try at the Asset filter search function. By creating the dropdown lists manually, there is no delay or freezing anymore. I would still like to find a way for the dropdown list to default at the first value but it is still totally workable.
Can you provide more information on what you would like your spreadsheet to do? What are you trying to search for: AF Elements/Attributes or PI Tags?
Is the end result to find the attributes for a given element for a changeable search root path?
My AF Structure represents houses in which there are rooms that contain devices. Each of these levels are represented by AF Elements, defined on templates. The end result is a spreadsheet that will show the devices attributes (some of which are PiPoints). I would like the user to select the houses/rooms/devices from 3 different dropdown lists. I am looking for ways to make the dropdown lists' content dynamic. For example, the number of rooms and their names can change from a house to another. Accordingly, the rooms dropdown list content should change according to which house is selected.
I have tried to use the "Asset filter search". For the first list, I am looking for houses based on their element template. The output is used as the root path of the second list, that searches for rooms, based on their template. I've selected the drop-down list and function array options. It basically works but has two drawbacks. First the update of the second list is not automatically launched when I change selection in the first one. Secondly, the update time is awful, even with the "limit to root level" is enabled. My AF structure only has several items yet and it takes over a minute to update.
I was looking to use the search function instead which seems more responsive. However, the use of the search box is much more involving than 3 drop down lists. That could change if I could call it as an excel fonction.
I'm glad to hear it! I was still testing and trying to find ways to get what you are after. I'm glad that Asset Search was able to provide what you need!
Retrieving data ...