Filter orgs to return only those with an active state.

dragonpoo · dragonpoo · commit 5015a71fcc14 · 2025-06-18T14:56:27.000-04:00
diff --git a/server/api-service/lowcoder-domain/src/main/java/org/lowcoder/domain/organization/repository/OrganizationRepository.java b/server/api-service/lowcoder-domain/src/main/java/org/lowcoder/domain/organization/repository/OrganizationRepository.java
@@ -34,6 +34,6 @@ public interface OrganizationRepository extends ReactiveMongoRepository<Organiza
     Flux<Organization> findByOrganizationDomainIsNotNull();
     Mono<Boolean> existsBySlug(String slug);
 
-    Flux<Organization> findByIdInAndNameContainingIgnoreCase(List<String> ids, String name, Pageable pageable);
-    Mono<Long> countByIdInAndNameContainingIgnoreCase(List<String> ids, String name);
+    Flux<Organization> findByIdInAndNameContainingIgnoreCaseAndState(List<String> ids, String name, OrganizationState state, Pageable pageable);
+    Mono<Long> countByIdInAndNameContainingIgnoreCaseAndState(List<String> ids, String name, OrganizationState state);
 }
diff --git a/server/api-service/lowcoder-domain/src/main/java/org/lowcoder/domain/organization/service/OrganizationServiceImpl.java b/server/api-service/lowcoder-domain/src/main/java/org/lowcoder/domain/organization/service/OrganizationServiceImpl.java
@@ -330,7 +330,7 @@ public Flux<Organization> findUserOrgs(String userId, String orgName, Pageable p
                     if (orgIds.isEmpty()) {
                         return Flux.empty();
                     }
-                    return repository.findByIdInAndNameContainingIgnoreCase(orgIds, orgName, pageable);
+                    return repository.findByIdInAndNameContainingIgnoreCaseAndState(orgIds, orgName, ACTIVE, pageable);
                 });
     }
 
@@ -344,7 +344,7 @@ public Mono<Long> countUserOrgs(String userId, String orgName) {
                     if (orgIds.isEmpty()) {
                         return Mono.just(0L);
                     }
-                    return repository.countByIdInAndNameContainingIgnoreCase(orgIds, filter);
+                    return repository.countByIdInAndNameContainingIgnoreCaseAndState(orgIds, filter, ACTIVE);
                 });
     }
 }

Original file line number	Diff line number	Diff line change
`@@ -34,6 +34,6 @@ public interface OrganizationRepository extends ReactiveMongoRepository<Organiza`
`34`	`34`	`Flux<Organization> findByOrganizationDomainIsNotNull();`
`35`	`35`	`Mono<Boolean> existsBySlug(String slug);`
`36`	`36`
`37`		`- Flux<Organization> findByIdInAndNameContainingIgnoreCase(List<String> ids, String name, Pageable pageable);`
`38`		`- Mono<Long> countByIdInAndNameContainingIgnoreCase(List<String> ids, String name);`
	`37`	`+ Flux<Organization> findByIdInAndNameContainingIgnoreCaseAndState(List<String> ids, String name, OrganizationState state, Pageable pageable);`
	`38`	`+ Mono<Long> countByIdInAndNameContainingIgnoreCaseAndState(List<String> ids, String name, OrganizationState state);`
`39`	`39`	`}`
Original file line number	Diff line number	Diff line change
`@@ -330,7 +330,7 @@ public Flux<Organization> findUserOrgs(String userId, String orgName, Pageable p`
`330`	`330`	`if (orgIds.isEmpty()) {`
`331`	`331`	`return Flux.empty();`
`332`	`332`	`}`
`333`		`- return repository.findByIdInAndNameContainingIgnoreCase(orgIds, orgName, pageable);`
	`333`	`+ return repository.findByIdInAndNameContainingIgnoreCaseAndState(orgIds, orgName, ACTIVE, pageable);`
`334`	`334`	`});`
`335`	`335`	`}`
`336`	`336`
`@@ -344,7 +344,7 @@ public Mono<Long> countUserOrgs(String userId, String orgName) {`
`344`	`344`	`if (orgIds.isEmpty()) {`
`345`	`345`	`return Mono.just(0L);`
`346`	`346`	`}`
`347`		`- return repository.countByIdInAndNameContainingIgnoreCase(orgIds, filter);`
	`347`	`+ return repository.countByIdInAndNameContainingIgnoreCaseAndState(orgIds, filter, ACTIVE);`
`348`	`348`	`});`
`349`	`349`	`}`
`350`	`350`	`}`