Interface ITermValueSetConceptDao

    • Method Detail

      • countByTermValueSetId

        @Query("SELECT COUNT(*) FROM TermValueSetConcept vsc WHERE vsc.myValueSetPid = :pid")
        Integer countByTermValueSetId​(@Param("pid")
                                      Long theValueSetId)
      • deleteByTermValueSetId

        @Query("DELETE FROM TermValueSetConcept vsc WHERE vsc.myValueSetPid = :pid")
        @Modifying
        void deleteByTermValueSetId​(@Param("pid")
                                    Long theValueSetId)
      • findByValueSetResourcePidSystemAndCodeWithVersion

        @Query("SELECT vsc FROM TermValueSetConcept vsc WHERE vsc.myValueSet.myResourcePid = :resource_pid AND vsc.mySystem = :system_url AND vsc.mySystemVer = :system_version AND vsc.myCode = :codeval")
        Optional<TermValueSetConceptfindByValueSetResourcePidSystemAndCodeWithVersion​(@Param("resource_pid")
                                                                                        Long theValueSetId,
                                                                                        @Param("system_url")
                                                                                        String theSystem,
                                                                                        @Param("system_version")
                                                                                        String theSystemVersion,
                                                                                        @Param("codeval")
                                                                                        String theCode)
      • findIdsByTermValueSetId

        @Query("SELECT vsc.myId FROM TermValueSetConcept vsc WHERE vsc.myValueSetPid = :pid ORDER BY vsc.myId")
        List<LongfindIdsByTermValueSetId​(@Param("pid")
                                           Long theValueSetId)
      • updateOrderById

        @Query("UPDATE TermValueSetConcept vsc SET vsc.myOrder = :order WHERE vsc.myId = :pid")
        @Modifying
        void updateOrderById​(@Param("pid")
                             Long theId,
                             @Param("order")
                             int theOrder)