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

Announcements
Qlik Unveils New Agentic Capabilities Across Analytics, Data Engineering, and Trust: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

Filtering within the migration tool

Hey guys, 

We are using the migration too to migrate QSEoW to cloud but struggling to find an easy way of selecting the apps required. There are approx. 2000 apps, all done by approx. 15 different owners. We are reviewing and migrating apps an owner at a time, some owners have 100+ apps and some have only 2 or 3. 

Can anyone tell me if there is a way of filtering the apps by owner within the app selection area of the migration plan..

 

I've attached a screenshot of what i mean. 

There is an 'Enable Batch Retrieval' check box, and when checked, a filter input box appear. You're supposed to be able to use syntax in that input box like..

name eq 'John' or userId sw 'svc'

changing these to values that exist does not filter anything.

Does anyone have any ideas? 

Thanks

 

 

 

Labels (2)
1 Solution

Accepted Solutions
VictorGonzalezFaria

Hello @hopkinsc,

Yes, there are two ways to achieve this, on the selection and on the table.

The attached video shows both:

00:01: Setup no Apps have been selected

00:05: Scrolling show that there are multiple App owners. The first several Apps owned by warren.poole, then christopher.newman (the ones we want to select, 00:09)

00:16: The filter bar of the selection tool filters the records to those including "newman" (179 Apps). This filter applies to any text in the row (App name, domain, user, etc.).

00:29: Selecting all possible makes this the selection

00:32: Clicking on "Add 179 Apps" moves them to the table

00:35: The 179 Apps owned by christopher.newman have been added to the table

00:47: End of option 1. All Apps removed from the table to try option 2

00:57: All Apps are added to the table, no filters applied

01:03: There are Apps in the table from multiple owners

01:07: Changed to Client-managed mode, to locate users by client-managed userids. The filtering could also be done in Cloud mode, by email

01:13: Filter Apps by owner "christopher.newman", to confirm count (179)

01:25: Clear table again, to make real selection

01:34: Filter by owner again. This time, select all, and remove "christopher.newman". Note: Selecting the one (or few) to remove can also be done by the filter at the top of the dialog if there are too many values, then, the check box can be cleared and when clicking "Filter", the selection is "all-but christopher.newman"

01:46: All visible Apps (those not owned by christopher.newman) are selected and using the "Actions" are removed form the table

01:55: After removing the filter, the desired Apps (owned by christopher.newman) reappear (179)

 

Note that it is possible to have all the Apps in the Plan, so the rules, naming, ownership, etc. are configured only once. Then, in the "Migrate Applications" task of the Job, the selection can be refined. Multiple jobs can be created from the same Plan, each for a user in your use case. The tasks from each job can be filtered further from the original selection in the Plan, achieving the required precision. This allows having a single, consistent set of "high-level" rules in the plan, and refined selections in each job.

 

Hope this helps,

 

VG

View solution in original post

2 Replies
VictorGonzalezFaria

Hello @hopkinsc,

Yes, there are two ways to achieve this, on the selection and on the table.

The attached video shows both:

00:01: Setup no Apps have been selected

00:05: Scrolling show that there are multiple App owners. The first several Apps owned by warren.poole, then christopher.newman (the ones we want to select, 00:09)

00:16: The filter bar of the selection tool filters the records to those including "newman" (179 Apps). This filter applies to any text in the row (App name, domain, user, etc.).

00:29: Selecting all possible makes this the selection

00:32: Clicking on "Add 179 Apps" moves them to the table

00:35: The 179 Apps owned by christopher.newman have been added to the table

00:47: End of option 1. All Apps removed from the table to try option 2

00:57: All Apps are added to the table, no filters applied

01:03: There are Apps in the table from multiple owners

01:07: Changed to Client-managed mode, to locate users by client-managed userids. The filtering could also be done in Cloud mode, by email

01:13: Filter Apps by owner "christopher.newman", to confirm count (179)

01:25: Clear table again, to make real selection

01:34: Filter by owner again. This time, select all, and remove "christopher.newman". Note: Selecting the one (or few) to remove can also be done by the filter at the top of the dialog if there are too many values, then, the check box can be cleared and when clicking "Filter", the selection is "all-but christopher.newman"

01:46: All visible Apps (those not owned by christopher.newman) are selected and using the "Actions" are removed form the table

01:55: After removing the filter, the desired Apps (owned by christopher.newman) reappear (179)

 

Note that it is possible to have all the Apps in the Plan, so the rules, naming, ownership, etc. are configured only once. Then, in the "Migrate Applications" task of the Job, the selection can be refined. Multiple jobs can be created from the same Plan, each for a user in your use case. The tasks from each job can be filtered further from the original selection in the Plan, achieving the required precision. This allows having a single, consistent set of "high-level" rules in the plan, and refined selections in each job.

 

Hope this helps,

 

VG

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

This was very helpful, thanks @VictorGonzalezFaria 

I couldn't use the 1st option as this only seems to select apps in my personal stream for some reason. the 2nd option took slightly longer to do but is still a lot faster than the way i was doing it before! 

Thanks again