Hi!
It took me a lot of time and swearing to figure it out as well.
First of all, of course you have to allow Quick Search in Functionality profile. Then you have to create view table with advanced query in Spatial Manager (Create->View Table->Advanced). In there, you have to define MISQL query and use @ + name for an input.
For example, let's say, I have table named "/namedTables/points" and field called ID in there. To define query for users to search point with certain ID, I will write in MISQL box: Select * from "/namedTables/points" where ID=@input. Now, when I click button "Validate", there will be table with bound parameters, where I can define default value and description for this "input" parameter. After that I can name the view table and save it. Now, in Project Settings of SSA project where this table that I used for query is used, I can see this defined view table in Query tab "Assign admin defined queries" field. When I choose this query in there and hit save, I can see this query in Search bar.
Sorry, if this description is a little bit confusing but so is the process for defining those queries.
Hopefully this would help,
Edit: another thing that took me some time was that to let users to use this query, I had to give permission to role to execute this view table as well. That is quite obvious, but as I said, it took me some time to figure this out. There is some documentation about this process as well that helped me to figure this out, but as usual, it's quite impossible to find and unfortunately I didn't bookmark it.
------------------------------
Ott Koik
Ruumab OÛ
Tartu
------------------------------
Original Message:
Sent: 06-03-2020 20:53
From: Timothy Righetti
Subject: Admin Defined Queries in 2019.1
Hi All,
I've been unable to figure out how to add admin defined queries into Spectrum Spatial for 2019.1.
I'm aware of the previous knowledge base article:
https://support.pitneybowes.com/SearchArticles/VFP05_KnowledgeWithSidebarHowTo?id=kA11E000000D0aoSAC&popup=false&lang=en_US
Since the Admin Console was removed, I don't see a location to define these, and in particular I'm hoping to add these into the search bar using the 'Quick Search' feature.
Any help would be much appreciated!
------------------------------
Timothy Righetti
Senior Spatial IT Business Analyst
Nillumbik Shire Council
Greensborough VIC
------------------------------