package com.dev.dao;

import com.dev.entity.ApiDashboardWidget;
import com.dev.entity.ApiLargeScreen;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import java.util.List;

public interface ApiLargeScreenDao  extends CrudRepository<ApiLargeScreen, Long>, JpaSpecificationExecutor<ApiLargeScreen> {

//    @Query(value = "select TITLE as title, REPORTCODE  as reportCode  from API_LARGE_SCREEN ", nativeQuery = true)
    public List<ApiLargeScreen> findAll();

      @Query(value = "select * from API_LARGE_SCREEN  where bsCode = ?1 ", nativeQuery = true)
      ApiLargeScreen getDataByBsCode(String bsCode);
}