Pamir Rahimzadeh Posted October 24, 2023 Share Posted October 24, 2023 I have added a custom query to a Spotfire Desktop analysis file, with the intention of reducing the data loaded into Spotfire, and as a result, making a dashboard quicker to open. The custom query is only visible to the custom query author, though. I see notes and help pages on making queries trusted by a "custom query author" in the Administration Manager tool, but that seems to be a Spotfire Server specific feature. How can I make it such that someone else opening my DXP file will be able to load in the data saved through Custom Queries? If a user goes into the queries and "verifies" them, they are then able to view the queries, but this "verification" seems to be tied to one user at a time (the last user to verify the queries and save the DXP file). Is there a way around this? Link to comment Share on other sites More sharing options...
Kirsten Smith (she/her) Posted October 24, 2023 Share Posted October 24, 2023 With Spotfire Desktop each person will have to verify the script manually, there isn't a way to trust them for all users. Link to comment Share on other sites More sharing options...
Pamir Rahimzadeh Posted October 24, 2023 Author Share Posted October 24, 2023 Hi Kirsten, thanks for the response. After verifying the custom query, is there a way for the dashboard to “remember” that trust for a user? If I set up the custom queries, then “Sally” opens up the DXP and verifies the queries, then clicks save on the DXP, then I again have to verify the queries. The system doesn’t seem to remember if a user has verified a custom query, essentially making the feature useless for shared Spotfire Desktop DXPs. Am I understanding this correctly? Link to comment Share on other sites More sharing options...
Pamir Rahimzadeh Posted October 24, 2023 Author Share Posted October 24, 2023 Also I noticed you said “script.” I am not talking about IronPython scripts, which have a clear method of trusting in Spotfire Desktop. I am referring to custom queries during data loading (import) from a database source. Link to comment Share on other sites More sharing options...
Solution Fredrik Rosell Posted October 27, 2023 Solution Share Posted October 27, 2023 Hello Pamir,For the use case you describe, allowing one user to "trust" the custom query for others, that does depend on functionality provided by using a Spotfire Analyst connected to a Spotfire Server/Library - it is not currently possible in Spotfire Desktop, which is more geared towards individual user and individual use cases. Supporting that use case as well sounds like a valid idea for the Ideas Portal - https://ideas.tibco.com/. I took a quick look and didn't find any existing idea for this so I recommend that you create one. Link to comment Share on other sites More sharing options...
Pamir Rahimzadeh Posted October 27, 2023 Author Share Posted October 27, 2023 Thank you Fredrik, I will submit to the ideas portal. Link to comment Share on other sites More sharing options...
Fredrik Rosell Posted October 30, 2023 Share Posted October 30, 2023 Great! I found your idea (https://ideas.tibco.com/ideas/TS-I-9460) and I have just voted for it.Best RegardsFredrik Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now