You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/11/16 02:01:23 UTC

[GitHub] [shardingsphere] tianshuainan opened a new issue, #22194: ShardingSphere-Encrypt: I query encrypted field with AssistedColumn，and it can't support predicate form

tianshuainan opened a new issue, #22194:
URL: https://github.com/apache/shardingsphere/issues/22194

   
   I  queryed encrypted field(such as :email) with Assisted query column and I used the method provided by JPA (findByEmail ()) to find the correct results. But using the following Predicate method fails. How to  solve this?I  will appreciate it very much and look forward to your reply.
   ` public ResponseEntity<?> getPaginatedRequestsByDsl(int page, int size, Predicate predicate) {
   
           Pageable paging = PageRequest.of(page, size, Sort.by(Sort.Direction.DESC, "createTime"));
           final Page<DsrRequest> pagedResult = dsrRequestRepositoryDao.findAll(predicate, paging);
   
           final DsrRequestInPaginatedResponse dsrRequestInPaginatedResponse = new DsrRequestInPaginatedResponse();
           if (pagedResult.hasContent()) {
               List<DsrRequestDto> listOfDsrRequests = pagedResult.stream()
                       .map(DsrRequestMapper.INSTANCE::entityToDto).collect(Collectors.toList());
   
               dsrRequestInPaginatedResponse.setRequests(listOfDsrRequests);
           } else {
               dsrRequestInPaginatedResponse.setRequests(Collections.emptyList());
           }`


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] RaigorJiang closed issue #22194: ShardingSphere-Encrypt: I query encrypted field with AssistedColumn，and it can't support predicate form

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #22194: ShardingSphere-Encrypt: I query encrypted field with AssistedColumn，and it can't support predicate form
URL: https://github.com/apache/shardingsphere/issues/22194


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] RaigorJiang commented on issue #22194: ShardingSphere-Encrypt: I query encrypted field with AssistedColumn，and it can't support predicate form

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #22194:
URL: https://github.com/apache/shardingsphere/issues/22194#issuecomment-1407268651

   Closed due to no response.
   If this problem persists, please reopen it or submit a new one.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] tuichenchuxin commented on issue #22194: ShardingSphere-Encrypt: I query encrypted field with AssistedColumn，and it can't support predicate form

Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #22194:
URL: https://github.com/apache/shardingsphere/issues/22194#issuecomment-1316395078

   Please investigate in detail the SQL used by the specific query and offer related configuration.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org