gistfile1.txt

    val toDataPathMap = getFacilityInfoMap(
        FacilityExchangeTable
            .innerJoin(
                otherTable = RoomExchangeTable,
                onColumn = { FacilityExchangeTable.facilityId },
                otherColumn = { RoomExchangeTable.facilityId })
            .innerJoin(
                otherTable = RiyosyaFcHeyaIdRelTable,
                onColumn = { RoomExchangeTable.fcHeyaId },
                otherColumn = { RiyosyaFcHeyaIdRelTable.fcHeyaId })
            .innerJoin(
                otherTable = RoundVitalTable,
                onColumn = { RiyosyaFcHeyaIdRelTable.riyosyaCode },
                otherColumn = { RoundVitalTable.riyosyaCode })
            .slice(
                FacilityExchangeTable.facilityId, FacilityExchangeTable.toDataPath, RoundVitalTable.riyosyaCode
            ).select {
                (RoomExchangeTable.enable eq true)
            }.withDistinct().orderBy(FacilityExchangeTable.toDataPath to SortOrder.ASC).map {
                mutableMapOf(
                    "facility_id" to it[FacilityExchangeTable.facilityId],
                    "to_data_path" to it[FacilityExchangeTable.toDataPath],
                    "riyosya_code" to it[RoundVitalTable.riyosyaCode]
                )
            }
    )