Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
AKN
Partner - Contributor III
Partner - Contributor III

How to filter by sheet show condition in js?

resim.png

As you can see I'm hiding the sheet setting show condition to 0.

Using this I can get the sheets but this returns all of them.

'/qrs/app/object/full?xrfKey=' + xrfKey + '&filter=(objectType eq "sheet")'

 

How can I filter out the sheets that are hidden?

Labels (3)
13 Replies
alex_colombo
Employee
Employee

As mentioned, are you closing the websocket as soon as you have the sheet condition?

An idea could be to just show the streams and the apps, then when a user select the apps, you will open the app and get the sheets list, instead of getting all the sheets from all the apps. Could this work?

AKN
Partner - Contributor III
Partner - Contributor III
Author

No I'm not closing the websocket because I'm not sure how to do that...

And yeah that's what I'm doing right now! However, there is a searchbar and it searches through all streams apps and sheets. When user searches for a sheet, it doesn't show up since sheets are not loaded yet.

alex_colombo
Employee
Employee

Try closing the web socket in this way and let me know if this solve the issue.

AKN
Partner - Contributor III
Partner - Contributor III
Author

Oh, this. Yes I've tried it before. It works for like half of the apps and then gives error, cannot connect to the server.