• Home
• io.mosip.pms
• pms-common
• 1.1.5.4
• source code
• MispRepository.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

io.mosip.pms.common.repository.MispRepository Maven / Gradle / Ivy

package io.mosip.pms.common.repository;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import io.mosip.pms.common.entity.Misp;

/**
 * Repository class for fetching and updating mispid.
 * @since 1.0.0
 * @author Nagarjuna K
 */
@Repository
public interface MispRepository extends JpaRepository {

	/**
	 * Method to fetch last updated mispid.
	 * 
	 * @return the entity.
	 */
	@Query(value = "select t.curr_seq_no,t.cr_by,t.cr_dtimes,t.upd_by,t.upd_dtimes FROM tspid_seq t where t.curr_seq_no=(select max(t.curr_seq_no) FROM tspid_seq t)", nativeQuery = true)
	Misp findLastMispId();

}