Bug #2106
closed
Feature #140: Technical Support, Bug Fixing and Services
Version #2098: Version 1.12
Able to update same ward number and house number for other existing house's ward number and house number
Added by Thara S Pillai over 2 years ago.
Updated over 2 years ago.
Description
1. Survey
2. View and Edit
3. View House Survey
4. Select Particular House and enter another existing ward number and house number
5. In this case we can able to update same ward number and house number
Please see the screen recording attached.
C-DAC requested a data level checking from UAT1 database for identifying this issue. The query to execute in UAT1 Database follows:
SELECT u.user_id AS id,u.employee_name AS employee_name,u.rank_name AS designation,ab.ashablock_id,
ab.ashablock_name,
ab.ward_id,wm.hospital_id,wm.basic_section_id,mh1.hospital_name AS hospital_name,mh1.hospital_type_id as hospital_type_id,mh2.hospital_name AS basic_section_name,mh2.hospital_type_id as basic_section_id,
ab.no_of_houses,
ab.no_of_members,mw.ward_name,mw.ward_code FROM users u, ph_ashablock_assign aba ph_ashablocks ab, ph_ward_mapping wm mas_hospital mh1, mas_hospital mh2, mas_ward mw where u.user_id=aba.user_id and aba.ashablock_id=ab.ashablock_id and ab.ward_id=wm.ward_id AND mh1.hospital_id=wm.hospital_id AND mh2.hospital_id=wm.basic_section_id AND mw.ward_id=ab.ward_id AND ab.ashablock_id IN(SELECT aba.ashablock_id FROM ph_ashablock_assign aba where
user_id IN)
- Status changed from New to Closed
- % Done changed from 0 to 100
Also available in: Atom
PDF