Search and filtering in No-Code - Step-by-Step Execution

Concept Flow - Search and filtering

Start with Data List

↓

Input Search Term

↓

Check Each Item

↓

Does Item Match?

No→Skip Item

Yes↓

Add Item to Results

↓

More Items?

Yes→Check Each Item

No↓

Show Filtered Results

The flow starts with a list of data, takes a search term, checks each item for a match, collects matching items, and finally shows the filtered results.

Execution Sample

No-Code

data = ['apple', 'banana', 'cherry', 'date']
search = 'a'
results = []
for item in data:
  if search in item:
    results.append(item)
print(results)

This code searches for items containing 'a' in a list and collects them into results.

Analysis Table

Step	Current Item	Condition (search in item)	Action	Results List
1	'apple'	True	Add 'apple'	['apple']
2	'banana'	True	Add 'banana'	['apple', 'banana']
3	'cherry'	False	Skip 'cherry'	['apple', 'banana']
4	'date'	True	Add 'date'	['apple', 'banana', 'date']
5	No more items	N/A	End loop	['apple', 'banana', 'date']

💡 All items checked, loop ends.

State Tracker

Variable	Start	After 1	After 2	After 3	After 4	Final
item	N/A	'apple'	'banana'	'cherry'	'date'	N/A
results	[]	['apple']	['apple', 'banana']	['apple', 'banana']	['apple', 'banana', 'date']	['apple', 'banana', 'date']

Key Insights - 2 Insights

Why is 'cherry' not added to the results even though it is in the list?

'cherry' does not contain the letter 'a', so the condition is False at step 3 in the execution_table, and it is skipped.

What happens if the search term is empty?

If the search term is empty, the condition 'search in item' is True for all items, so all items would be added to results.

Visual Quiz - 3 Questions

Look at the execution_table, what is the results list after step 2?

A ['banana']

B ['apple']

C ['apple', 'banana']

D []

💡 Hint

Check the Results List column at step 2 in the execution_table.

At which step does the condition become False?

A Step 1

B Step 3

C Step 4

D Step 5

💡 Hint

Look at the Condition column in the execution_table to find where it is False.

If the search term changed to 'e', which item would be added at step 1?

A 'apple'

B 'banana'

C 'cherry'

D 'date'

💡 Hint

Check which items contain 'e' and compare with the first item in the data list.

Concept Snapshot

Search and filtering:
- Start with a list of items.
- Input a search term.
- Check each item if it contains the term.
- Collect matching items.
- Show filtered results.

Full Transcript

This visual execution shows how search and filtering work by checking each item in a list against a search term. Items containing the term are added to the results list. The process repeats until all items are checked, then the filtered list is shown.

Practice

1. What is the main purpose of search in data handling?

easy

A. To find items by matching text or keywords

B. To sort items alphabetically

C. To delete unwanted items

D. To add new items to a list

Solution

1. Step 1: Understand the meaning of search

   Search means looking for something specific by matching text or keywords.

2. Step 2: Compare options with the definition

   Only To find items by matching text or keywords describes finding items by matching text or keywords, which matches the purpose of search.

3. Final Answer:

   To find items by matching text or keywords -> Option A

4. Quick Check:

   Search = find by keywords [OK]

Hint: Search means finding by matching words or text [OK]

Common Mistakes:

• Confusing search with sorting
• Thinking search adds or deletes items
• Mixing search with filtering

2. Which of the following is the correct way to filter a list of fruits to only show those starting with 'A'?

easy

A. Delete fruits not starting with 'A'

B. Sort fruits alphabetically

C. Select all fruits where name starts with 'A'

D. Add fruits starting with 'A' to the list

Solution

1. Step 1: Understand filtering

   Filtering means showing only items that meet a rule, like names starting with 'A'.

2. Step 2: Match options to filtering

   Select all fruits where name starts with 'A' correctly describes selecting items based on a condition. Other options describe sorting, deleting, or adding, which are not filtering.

3. Final Answer:

   Select all fruits where name starts with 'A' -> Option C

4. Quick Check:

   Filter = select by rule [OK]

Hint: Filtering means selecting items by a condition [OK]

Common Mistakes:

• Confusing filtering with sorting
• Thinking filtering deletes items
• Mixing filtering with adding items

3. Given a list of names: ["Anna", "Bob", "Alice", "Mark"], which result shows filtering names starting with 'A'?

medium

A. ["Bob", "Mark"]

B. ["Mark"]

C. ["Anna", "Bob", "Alice"]

D. ["Anna", "Alice"]

Solution

1. Step 1: Identify names starting with 'A'

   From the list, "Anna" and "Alice" start with 'A'.

2. Step 2: Check options for correct filtered list

   ["Anna", "Alice"] lists only "Anna" and "Alice", matching the filter condition.

3. Final Answer:

   ["Anna", "Alice"] -> Option D

4. Quick Check:

   Filter names starting 'A' = ["Anna", "Alice"] [OK]

Hint: Pick only items starting with 'A' [OK]

Common Mistakes:

• Including names not starting with 'A'
• Excluding valid names starting with 'A'
• Confusing filtering with sorting

4. You want to filter a list of products by category but the filter shows no results. What could be the problem?

medium

A. The search keyword is too broad

B. The category name used in filter does not match any product

C. The products were deleted

D. The list is sorted incorrectly

Solution

1. Step 1: Understand filtering by category

   Filtering shows items matching the category name exactly.

2. Step 2: Identify why no results appear

   If the category name does not match any product, no items will show. Sorting or deletion are unrelated to filtering results here.

3. Final Answer:

   The category name used in filter does not match any product -> Option B

4. Quick Check:

   Wrong category name = no results [OK]

Hint: Check filter category spelling matches data exactly [OK]

Common Mistakes:

• Assuming sorting affects filtering results
• Thinking products were deleted without checking
• Confusing search keyword with filter category

5. You have a list of books with titles and genres. You want to find all books with 'History' in the title and filter only those in the 'Non-fiction' genre. Which approach is best?

hard

A. First search titles for 'History', then filter results by 'Non-fiction' genre

B. Filter all books by 'Non-fiction' genre, then search titles for 'History'

C. Sort books by title, then filter by genre

D. Search all books for 'History' and ignore genre

Solution

1. Step 1: Understand combined search and filtering

   To find books with 'History' in title and genre 'Non-fiction', both conditions must be applied.

2. Step 2: Choose the best order

   Searching titles first narrows down to relevant books, then filtering by genre further narrows results efficiently. First search titles for 'History', then filter results by 'Non-fiction' genre describes this approach.

3. Final Answer:

   First search titles for 'History', then filter results by 'Non-fiction' genre -> Option A

4. Quick Check:

   Search then filter = best combined approach [OK]

Hint: Search first, then filter for best results [OK]

Common Mistakes:

• Filtering before searching may miss some matches
• Sorting does not help find or filter items
• Ignoring genre filter loses important results