# audit_2025_05_29

timestamp: 2025-05-29T07:00:19.489Z
level: debug
metadata: {}
message:
Knex query response: {"command":"SELECT","rowCount":1,"oid":null,"rows":[{"?column?":1}],"fields":[{"name":"?column?","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"dataTypeModifier":-1,"format":"text"}],"_Parsers":[null],"_Types":{"_types":{"arrayParser":{},"builtins":{"BOOL":16,"BYTEA":17,"CHAR":18,"INT8":20,"INT2":21,"INT4":23,"REGPROC":24,"TEXT":25,"OID":26,"TID":27,"XID":28,"CID":29,"JSON":114,"XML":142,"PG_NODE_TREE":194,"SMGR":210,"PATH":602,"POLYGON":604,"CIDR":650,"FLOAT4":700,"FLOAT8":701,"ABSTIME":702,"RELTIME":703,"TINTERVAL":704,"CIRCLE":718,"MACADDR8":774,"MONEY":790,"MACADDR":829,"INET":869,"ACLITEM":1033,"BPCHAR":1042,"VARCHAR":1043,"DATE":1082,"TIME":1083,"TIMESTAMP":1114,"TIMESTAMPTZ":1184,"INTERVAL":1186,"TIMETZ":1266,"BIT":1560,"VARBIT":1562,"NUMERIC":1700,"REFCURSOR":1790,"REGPROCEDURE":2202,"REGOPER":2203,"REGOPERATOR":2204,"REGCLASS":2205,"REGTYPE":2206,"UUID":2950,"TXID_SNAPSHOT":2970,"PG_LSN":3220,"PG_NDISTINCT":3361,"PG_DEPENDENCIES":3402,"TSVECTOR":3614,"TSQUERY":3615,"GTSVECTOR":3642,"REGCONFIG":3734,"REGDICTIONARY":3769,"JSONB":3802,"REGNAMESPACE":4089,"REGROLE":4096}},"text":{},"binary":{}},"RowCtor":null,"rowAsArray":false,"_PrebuiltEmptyResultObject":{"?column?":null}}


timestamp: 2025-05-29T07:00:21.065Z
level: debug
metadata: {}
message:
Knex query: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id"


timestamp: 2025-05-29T07:00:21.131Z
level: error
metadata: {}
message:
Knex query error: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id" - column "application_work_details.department_details_id" must appear in the GROUP BY clause or be used in an aggregate function


timestamp: 2025-05-29T07:01:28.616Z
level: debug
metadata: {}
message:
Knex query: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id", "application_work_details"."department_details_id"


timestamp: 2025-05-29T07:01:28.686Z
level: debug
metadata: {}
message:
Knex query response: [{"applicationId":"1","applicationTxId":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","applicationNo":"AR-1065481","applicationEntryType":"WEBAPP","firstName":"Srinivasa Reddy","lastName":"Alla","dateOfBirth":"1995-05-06T07:00:00.000Z","email":"srinireddy.alla@gmail.com","aadharNo":"547825809632","applicantUserId":"56d824c3-783a-4910-9d22-4d0b9461df64","phoneNo":"8885219211","applicationStatus":1,"isDraft":true,"departmentDetailsId":"1","departmentDetailsUuid":"783a5da4-bddd-4b7d-82b3-cd44507735ca","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","departmentId":1,"recruitmentType":1,"designationId":"1","joiningDate":"2025-05-06T07:00:00.000Z","address":"BRP ROAD, BESIDE H.P.O., VIJAYAWADA, ANDHRA PRADESH - 520 001","officeDistrictId":1,"officeStateId":1,"officeMandalId":1,"officeVillageId":1,"placeOfWork":"Vijayawada","workStateId":1,"workDistrictId":1,"workMandalId":1,"workVillageId":1,"workPinCode":"52007"}]


timestamp: 2025-05-29T07:16:13.876Z
level: debug
metadata: {}
message:
Knex query: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id", "application_family_details"."family_details_id", "application_family_details"."family_details_uuid", "application_family_details"."application_uuid", "application_family_details"."father_name", "application_family_details"."father_sur_name", "application_family_details"."mother_name", "application_family_details"."mother_sur_name", "application_family_details"."guardian_name", "application_family_details"."guardian_sur_name", "application_family_details"."spouse_name", "application_family_details"."spouse_sur_name", "application_family_details"."father_nationality_id", "application_family_details"."mother_nationality_id", "application_family_details"."spouse_nationality_id", "application_family_details"."guardian_nationality_id", "application_address_details"."address_details_id", "application_address_details"."address_details_uuid", "application_address_details"."application_uuid", "application_address_details"."house_no", "application_address_details"."street_name", "application_address_details"."district_id", "application_address_details"."state_id", "application_address_details"."mandal_id", "application_address_details"."village_name", "application_address_details"."pin_code", "application_address_details"."police_station_id", "application_address_details"."police_station_name", "application_address_details"."is_current_is_permanent", "application_address_details"."perm_house_no", "application_address_details"."perm_street_name", "application_address_details"."perm_district_id", "application_address_details"."perm_state_id", "application_address_details"."perm_mandal_id", "application_address_details"."perm_village_name", "application_address_details"."perm_pin_code", "application_address_details"."perm_police_station_id", "application_address_details"."perm_police_station_name", "application_address_details"."land_mark", "application_address_details"."perm_lannd_mark" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "verification"."application_family_details" on "applicant_details"."application_tx_id" = "application_family_details"."application_uuid" inner join "verification"."application_address_details" on "applicant_details"."application_tx_id" = "application_address_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."castes" as "subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."nationalities" on "nationalities"."nationality_id" = "application_basic_details"."nationality_id" inner join "master"."villages" as "birth_villages" on "villages"."village_id" = "birth_place" inner join "master"."mandals" as "birth_mandals" on "mandals"."mandal_id" = "birth_mandal_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" inner join "master"."countries" on "countries"."country_id" = "application_basic_details"."nationality_id" inner join "master"."religions" as "father_religions" on "religions"."religion_id" = "application_family_details"."father_nationality_id" inner join "master"."religions" as "mother_religions" on "religions"."religion_id" = "application_family_details"."mother_nationality_id" inner join "master"."religions" as "spouse_religions" on "religions"."religion_id" = "application_family_details"."spouse_nationality_id" inner join "master"."religions" as "guardian_religions" on "religions"."religion_id" = "application_family_details"."guardian_nationality_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 and "application_basic_details"."is_active" = $5 and "application_family_details"."is_active" = $6 and "application_address_details"."is_active" = $7 group by "applicant_details"."application_id", "application_work_details"."department_details_id"


timestamp: 2025-05-29T07:16:13.948Z
level: error
metadata: {}
message:
Knex query error: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id", "application_family_details"."family_details_id", "application_family_details"."family_details_uuid", "application_family_details"."application_uuid", "application_family_details"."father_name", "application_family_details"."father_sur_name", "application_family_details"."mother_name", "application_family_details"."mother_sur_name", "application_family_details"."guardian_name", "application_family_details"."guardian_sur_name", "application_family_details"."spouse_name", "application_family_details"."spouse_sur_name", "application_family_details"."father_nationality_id", "application_family_details"."mother_nationality_id", "application_family_details"."spouse_nationality_id", "application_family_details"."guardian_nationality_id", "application_address_details"."address_details_id", "application_address_details"."address_details_uuid", "application_address_details"."application_uuid", "application_address_details"."house_no", "application_address_details"."street_name", "application_address_details"."district_id", "application_address_details"."state_id", "application_address_details"."mandal_id", "application_address_details"."village_name", "application_address_details"."pin_code", "application_address_details"."police_station_id", "application_address_details"."police_station_name", "application_address_details"."is_current_is_permanent", "application_address_details"."perm_house_no", "application_address_details"."perm_street_name", "application_address_details"."perm_district_id", "application_address_details"."perm_state_id", "application_address_details"."perm_mandal_id", "application_address_details"."perm_village_name", "application_address_details"."perm_pin_code", "application_address_details"."perm_police_station_id", "application_address_details"."perm_police_station_name", "application_address_details"."land_mark", "application_address_details"."perm_lannd_mark" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "verification"."application_family_details" on "applicant_details"."application_tx_id" = "application_family_details"."application_uuid" inner join "verification"."application_address_details" on "applicant_details"."application_tx_id" = "application_address_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."castes" as "subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."nationalities" on "nationalities"."nationality_id" = "application_basic_details"."nationality_id" inner join "master"."villages" as "birth_villages" on "villages"."village_id" = "birth_place" inner join "master"."mandals" as "birth_mandals" on "mandals"."mandal_id" = "birth_mandal_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" inner join "master"."countries" on "countries"."country_id" = "application_basic_details"."nationality_id" inner join "master"."religions" as "father_religions" on "religions"."religion_id" = "application_family_details"."father_nationality_id" inner join "master"."religions" as "mother_religions" on "religions"."religion_id" = "application_family_details"."mother_nationality_id" inner join "master"."religions" as "spouse_religions" on "religions"."religion_id" = "application_family_details"."spouse_nationality_id" inner join "master"."religions" as "guardian_religions" on "religions"."religion_id" = "application_family_details"."guardian_nationality_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 and "application_basic_details"."is_active" = $5 and "application_family_details"."is_active" = $6 and "application_address_details"."is_active" = $7 group by "applicant_details"."application_id", "application_work_details"."department_details_id" - column religions.religion_id does not exist


timestamp: 2025-05-29T07:16:52.774Z
level: error
metadata: {}
message:
Knex query error: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id", "application_family_details"."family_details_id", "application_family_details"."family_details_uuid", "application_family_details"."application_uuid", "application_family_details"."father_name", "application_family_details"."father_sur_name", "application_family_details"."mother_name", "application_family_details"."mother_sur_name", "application_family_details"."guardian_name", "application_family_details"."guardian_sur_name", "application_family_details"."spouse_name", "application_family_details"."spouse_sur_name", "application_family_details"."father_nationality_id", "application_family_details"."mother_nationality_id", "application_family_details"."spouse_nationality_id", "application_family_details"."guardian_nationality_id", "application_address_details"."address_details_id", "application_address_details"."address_details_uuid", "application_address_details"."application_uuid", "application_address_details"."house_no", "application_address_details"."street_name", "application_address_details"."district_id", "application_address_details"."state_id", "application_address_details"."mandal_id", "application_address_details"."village_name", "application_address_details"."pin_code", "application_address_details"."police_station_id", "application_address_details"."police_station_name", "application_address_details"."is_current_is_permanent", "application_address_details"."perm_house_no", "application_address_details"."perm_street_name", "application_address_details"."perm_district_id", "application_address_details"."perm_state_id", "application_address_details"."perm_mandal_id", "application_address_details"."perm_village_name", "application_address_details"."perm_pin_code", "application_address_details"."perm_police_station_id", "application_address_details"."perm_police_station_name", "application_address_details"."land_mark", "application_address_details"."perm_lannd_mark" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "verification"."application_family_details" on "applicant_details"."application_tx_id" = "application_family_details"."application_uuid" inner join "verification"."application_address_details" on "applicant_details"."application_tx_id" = "application_address_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."castes" as "subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."nationalities" on "nationalities"."nationality_id" = "application_basic_details"."nationality_id" inner join "master"."villages" as "birth_villages" on "villages"."village_id" = "birth_place" inner join "master"."mandals" as "birth_mandals" on "mandals"."mandal_id" = "birth_mandal_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" inner join "master"."countries" on "countries"."country_id" = "application_basic_details"."nationality_id" inner join "master"."religions" as "father_religions" on "religions"."religion_id" = "application_family_details"."father_nationality_id" inner join "master"."religions" as "mother_religions" on "religions"."religion_id" = "application_family_details"."mother_nationality_id" inner join "master"."religions" as "spouse_religions" on "religions"."religion_id" = "application_family_details"."spouse_nationality_id" inner join "master"."religions" as "guardian_religions" on "religions"."religion_id" = "application_family_details"."guardian_nationality_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 and "application_basic_details"."is_active" = $5 and "application_family_details"."is_active" = $6 and "application_address_details"."is_active" = $7 group by "applicant_details"."application_id", "application_work_details"."department_details_id" - operator does not exist: uuid = character varying


timestamp: 2025-05-30T01:36:01.562Z
level: debug
metadata: {}
message:
Knex query: select "user_id", "username", "email", "email_verified", "password_hash", "password_salt", "first_name", "last_name", "phone_number", "phone_verified", "last_login", "last_login_ip", "failed_login_attempts", "timezone", "locale", "user_type", "is_active", "is_system" from "identity"."users" where "username" = $1 and "user_type" in ($2, $3) and "is_active" = $4 limit $5


timestamp: 2025-05-30T01:36:22.934Z
level: debug
metadata: {}
message:
Knex query response: {"userId":"56d824c3-783a-4910-9d22-4d0b9461df64","username":"user@mail.com","email":"user@mail.com","emailVerified":true,"passwordHash":"0b29258890e5394c7f94f8e00e2d","passwordSalt":{"iv":"412d27f21268bf7c4573e2a73771899e","tag":"f44591e18f74108e15d3329e60c69461"},"firstName":"User","lastName":"Name","phoneNumber":null,"phoneVerified":true,"lastLogin":"2025-05-29T01:51:06.935Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"APPLICANT","isActive":true,"isSystem":true}


timestamp: 2025-05-30T01:36:23.002Z
level: debug
metadata: {}
message:
Knex query: update "identity"."users" set "failed_login_attempts" = $1, "last_login" = $2, "last_login_ip" = $3 where "user_id" = $4


timestamp: 2025-05-30T01:36:23.071Z
level: debug
metadata: {}
message:
Knex query: select "user_roles"."role_id", "roles"."name", "roles"."code" from "core"."user_roles" inner join "core"."roles" on "roles"."role_id" = "user_roles"."role_id" where "user_roles"."user_id" = $1 and "user_roles"."is_active" = $2 and "core"."roles"."is_active" = $3


timestamp: 2025-05-30T01:36:23.130Z
level: debug
metadata: {}
message:
Knex query: select "useraccessprofile"."accessprofileid", "access_profiles"."name" from "core"."useraccessprofile" inner join "core"."access_profiles" on "access_profiles"."profile_id" = "useraccessprofile"."accessprofileid" where "useraccessprofile"."userid" = $1 and "access_profiles"."is_active" = $2


timestamp: 2025-05-30T01:37:44.363Z
level: debug
metadata: {}
message:
Knex query: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id", "application_family_details"."family_details_id", "application_family_details"."family_details_uuid", "application_family_details"."application_uuid", "application_family_details"."father_name", "application_family_details"."father_sur_name", "application_family_details"."mother_name", "application_family_details"."mother_sur_name", "application_family_details"."guardian_name", "application_family_details"."guardian_sur_name", "application_family_details"."spouse_name", "application_family_details"."spouse_sur_name", "application_family_details"."father_nationality_id", "application_family_details"."mother_nationality_id", "application_family_details"."spouse_nationality_id", "application_family_details"."guardian_nationality_id", "application_address_details"."address_details_id", "application_address_details"."address_details_uuid", "application_address_details"."application_uuid", "application_address_details"."house_no", "application_address_details"."street_name", "application_address_details"."district_id", "application_address_details"."state_id", "application_address_details"."mandal_id", "application_address_details"."village_name", "application_address_details"."pin_code", "application_address_details"."police_station_id", "application_address_details"."police_station_name", "application_address_details"."is_current_is_permanent", "application_address_details"."perm_house_no", "application_address_details"."perm_street_name", "application_address_details"."perm_district_id", "application_address_details"."perm_state_id", "application_address_details"."perm_mandal_id", "application_address_details"."perm_village_name", "application_address_details"."perm_pin_code", "application_address_details"."perm_police_station_id", "application_address_details"."perm_police_station_name", "application_address_details"."land_mark", "application_address_details"."perm_lannd_mark" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" left join "verification"."application_family_details" on "applicant_details"."application_tx_id" = "application_family_details"."application_uuid" left join "verification"."application_address_details" on "applicant_details"."application_tx_id" = "application_address_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."castes" as "subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."nationalities" on "nationalities"."nationality_id" = "application_basic_details"."nationality_id" inner join "master"."villages" as "birth_villages" on "villages"."village_id" = "birth_place" inner join "master"."mandals" as "birth_mandals" on "mandals"."mandal_id" = "birth_mandal_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" inner join "master"."countries" on "countries"."country_id" = "application_basic_details"."nationality_id" left join "master"."religions" as "father_religions" on "religions"."religion_id" = "application_family_details"."father_nationality_id" left join "master"."religions" as "mother_religions" on "religions"."religion_id" = "application_family_details"."mother_nationality_id" left join "master"."religions" as "spouse_religions" on "religions"."religion_id" = "application_family_details"."spouse_nationality_id" left join "master"."religions" as "guardian_religions" on "religions"."religion_id" = "application_family_details"."guardian_nationality_id" left join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" left join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" left join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" left join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 and "application_basic_details"."is_active" = $5 and "application_family_details"."is_active" = $6 and "application_address_details"."is_active" = $7 group by "applicant_details"."application_id", "application_work_details"."department_details_id"


timestamp: 2025-05-30T01:37:44.428Z
level: error
metadata: {}
message:
Knex query error: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id", "application_family_details"."family_details_id", "application_family_details"."family_details_uuid", "application_family_details"."application_uuid", "application_family_details"."father_name", "application_family_details"."father_sur_name", "application_family_details"."mother_name", "application_family_details"."mother_sur_name", "application_family_details"."guardian_name", "application_family_details"."guardian_sur_name", "application_family_details"."spouse_name", "application_family_details"."spouse_sur_name", "application_family_details"."father_nationality_id", "application_family_details"."mother_nationality_id", "application_family_details"."spouse_nationality_id", "application_family_details"."guardian_nationality_id", "application_address_details"."address_details_id", "application_address_details"."address_details_uuid", "application_address_details"."application_uuid", "application_address_details"."house_no", "application_address_details"."street_name", "application_address_details"."district_id", "application_address_details"."state_id", "application_address_details"."mandal_id", "application_address_details"."village_name", "application_address_details"."pin_code", "application_address_details"."police_station_id", "application_address_details"."police_station_name", "application_address_details"."is_current_is_permanent", "application_address_details"."perm_house_no", "application_address_details"."perm_street_name", "application_address_details"."perm_district_id", "application_address_details"."perm_state_id", "application_address_details"."perm_mandal_id", "application_address_details"."perm_village_name", "application_address_details"."perm_pin_code", "application_address_details"."perm_police_station_id", "application_address_details"."perm_police_station_name", "application_address_details"."land_mark", "application_address_details"."perm_lannd_mark" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" left join "verification"."application_family_details" on "applicant_details"."application_tx_id" = "application_family_details"."application_uuid" left join "verification"."application_address_details" on "applicant_details"."application_tx_id" = "application_address_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."castes" as "subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."nationalities" on "nationalities"."nationality_id" = "application_basic_details"."nationality_id" inner join "master"."villages" as "birth_villages" on "villages"."village_id" = "birth_place" inner join "master"."mandals" as "birth_mandals" on "mandals"."mandal_id" = "birth_mandal_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" inner join "master"."countries" on "countries"."country_id" = "application_basic_details"."nationality_id" left join "master"."religions" as "father_religions" on "religions"."religion_id" = "application_family_details"."father_nationality_id" left join "master"."religions" as "mother_religions" on "religions"."religion_id" = "application_family_details"."mother_nationality_id" left join "master"."religions" as "spouse_religions" on "religions"."religion_id" = "application_family_details"."spouse_nationality_id" left join "master"."religions" as "guardian_religions" on "religions"."religion_id" = "application_family_details"."guardian_nationality_id" left join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" left join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" left join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" left join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 and "application_basic_details"."is_active" = $5 and "application_family_details"."is_active" = $6 and "application_address_details"."is_active" = $7 group by "applicant_details"."application_id", "application_work_details"."department_details_id" - operator does not exist: uuid = character varying


timestamp: 2025-05-30T01:40:17.159Z
level: debug
metadata: {}
message:
Knex query: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."castes" as "subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."nationalities" on "nationalities"."nationality_id" = "application_basic_details"."nationality_id" inner join "master"."villages" as "birth_villages" on "villages"."village_id" = "birth_place" inner join "master"."mandals" as "birth_mandals" on "mandals"."mandal_id" = "birth_mandal_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" inner join "master"."countries" on "countries"."country_id" = "application_basic_details"."nationality_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 and "application_basic_details"."is_active" = $5 and "application_family_details"."is_active" = $6 and "application_address_details"."is_active" = $7 group by "applicant_details"."application_id", "application_work_details"."department_details_id"


timestamp: 2025-05-30T01:40:17.221Z
level: error
metadata: {}
message:
Knex query error: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."castes" as "subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."nationalities" on "nationalities"."nationality_id" = "application_basic_details"."nationality_id" inner join "master"."villages" as "birth_villages" on "villages"."village_id" = "birth_place" inner join "master"."mandals" as "birth_mandals" on "mandals"."mandal_id" = "birth_mandal_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" inner join "master"."countries" on "countries"."country_id" = "application_basic_details"."nationality_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 and "application_basic_details"."is_active" = $5 and "application_family_details"."is_active" = $6 and "application_address_details"."is_active" = $7 group by "applicant_details"."application_id", "application_work_details"."department_details_id" - operator does not exist: uuid = character varying


timestamp: 2025-05-30T01:47:38.670Z
level: error
metadata: {}
message:
Knex query error: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."castes" as "subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."nationalities" on "nationalities"."nationality_id" = "application_basic_details"."nationality_id" inner join "master"."villages" as "birth_villages" on "villages"."village_id" = "birth_place" inner join "master"."mandals" as "birth_mandals" on "mandals"."mandal_id" = "birth_mandal_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" inner join "master"."countries" on "countries"."country_id" = "application_basic_details"."nationality_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 and "application_basic_details"."is_active" = $5 and "application_family_details"."is_active" = $6 and "application_address_details"."is_active" = $7 group by "applicant_details"."application_id", "application_work_details"."department_details_id" - column subcastes.sub_caste_id does not exist


timestamp: 2025-05-30T05:22:55.965Z
level: debug
metadata: {}
message:
Knex query: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."countries" on "countries"."id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."castes" as "subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."nationalities" on "nationalities"."nationality_id" = "application_basic_details"."nationality_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" inner join "master"."countries" on "countries"."country_id" = "application_basic_details"."nationality_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 and "application_basic_details"."is_active" = $5 and "application_family_details"."is_active" = $6 and "application_address_details"."is_active" = $7 group by "applicant_details"."application_id", "application_work_details"."department_details_id"


timestamp: 2025-05-30T05:22:56.021Z
level: error
metadata: {}
message:
Knex query error: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."countries" on "countries"."id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."castes" as "subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."nationalities" on "nationalities"."nationality_id" = "application_basic_details"."nationality_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" inner join "master"."countries" on "countries"."country_id" = "application_basic_details"."nationality_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 and "application_basic_details"."is_active" = $5 and "application_family_details"."is_active" = $6 and "application_address_details"."is_active" = $7 group by "applicant_details"."application_id", "application_work_details"."department_details_id" - column subcastes.sub_caste_id does not exist


timestamp: 2025-05-30T05:28:00.713Z
level: error
metadata: {}
message:
Knex query error: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."countries" on "countries"."id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."castes" as "subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."nationalities" on "nationalities"."nationality_id" = "application_basic_details"."nationality_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" inner join "master"."countries" on "countries"."country_id" = "application_basic_details"."nationality_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 and "application_basic_details"."is_active" = $5 and "application_family_details"."is_active" = $6 and "application_address_details"."is_active" = $7 group by "applicant_details"."application_id", "application_work_details"."department_details_id" - column castes.caste_id does not exist


timestamp: 2025-05-30T05:31:41.429Z
level: debug
metadata: {}
message:
Knex query: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."countries" on "countries"."id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."nationalities" on "nationalities"."nationality_id" = "application_basic_details"."nationality_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" inner join "master"."countries" on "countries"."country_id" = "application_basic_details"."nationality_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id", "application_work_details"."department_details_id"


timestamp: 2025-05-30T05:31:41.491Z
level: error
metadata: {}
message:
Knex query error: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."countries" on "countries"."id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."nationalities" on "nationalities"."nationality_id" = "application_basic_details"."nationality_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" inner join "master"."countries" on "countries"."country_id" = "application_basic_details"."nationality_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id", "application_work_details"."department_details_id" - column castes.caste_id does not exist


timestamp: 2025-05-30T05:32:05.736Z
level: error
metadata: {}
message:
Knex query error: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."countries" on "countries"."id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."nationalities" on "nationalities"."nationality_id" = "application_basic_details"."nationality_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" inner join "master"."countries" on "countries"."country_id" = "application_basic_details"."nationality_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id", "application_work_details"."department_details_id" - column application_basic_details.sub_caste_id does not exist


timestamp: 2025-05-30T05:33:24.772Z
level: error
metadata: {}
message:
Knex query error: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."countries" on "countries"."id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."nationalities" on "nationalities"."nationality_id" = "application_basic_details"."nationality_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" inner join "master"."countries" on "countries"."country_id" = "application_basic_details"."nationality_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id", "application_work_details"."department_details_id" - relation "master.nationalities" does not exist


timestamp: 2025-05-30T05:43:05.524Z
level: debug
metadata: {}
message:
Knex query: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."countries" on "countries"."id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."countries" on "countries"."nationality_id" = "application_basic_details"."nationality_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" inner join "master"."countries" on "countries"."country_id" = "application_basic_details"."nationality_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id", "application_work_details"."department_details_id"


timestamp: 2025-05-30T05:43:05.591Z
level: error
metadata: {}
message:
Knex query error: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."countries" on "countries"."id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."countries" on "countries"."nationality_id" = "application_basic_details"."nationality_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" inner join "master"."countries" on "countries"."country_id" = "application_basic_details"."nationality_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id", "application_work_details"."department_details_id" - table name "countries" specified more than once


timestamp: 2025-05-30T05:44:12.059Z
level: debug
metadata: {}
message:
Knex query: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."religions" on "religions"."id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."countries" on "countries"."nationality_id" = "application_basic_details"."nationality_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id", "application_work_details"."department_details_id"


timestamp: 2025-05-30T05:44:12.113Z
level: error
metadata: {}
message:
Knex query error: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."religions" on "religions"."id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."countries" on "countries"."nationality_id" = "application_basic_details"."nationality_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id", "application_work_details"."department_details_id" - column religions.id does not exist


timestamp: 2025-05-30T05:45:03.209Z
level: debug
metadata: {}
message:
Knex query: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."countries" on "countries"."nationality_id" = "application_basic_details"."nationality_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id", "application_work_details"."department_details_id"


timestamp: 2025-05-30T05:45:03.270Z
level: error
metadata: {}
message:
Knex query error: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."countries" on "countries"."nationality_id" = "application_basic_details"."nationality_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id", "application_work_details"."department_details_id" - column countries.nationality_id does not exist


timestamp: 2025-05-30T05:46:08.539Z
level: debug
metadata: {}
message:
Knex query: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."countries" on "countries"."id" = "application_basic_details"."nationality_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id", "application_work_details"."department_details_id"


timestamp: 2025-05-30T05:46:08.595Z
level: error
metadata: {}
message:
Knex query error: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."countries" on "countries"."id" = "application_basic_details"."nationality_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id", "application_work_details"."department_details_id" - column "application_basic_details.basic_details_id" must appear in the GROUP BY clause or be used in an aggregate function


timestamp: 2025-05-30T05:46:39.211Z
level: debug
metadata: {}
message:
Knex query: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."countries" on "countries"."id" = "application_basic_details"."nationality_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id", "application_work_details"."department_details_id", "application_basic_details"."basic_details_id"


timestamp: 2025-05-30T05:46:39.270Z
level: error
metadata: {}
message:
Knex query error: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."countries" on "countries"."id" = "application_basic_details"."nationality_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id", "application_work_details"."department_details_id", "application_basic_details"."basic_details_id" - column "application_basic_details.basic_details_uuid" must appear in the GROUP BY clause or be used in an aggregate function


timestamp: 2025-05-30T05:47:09.133Z
level: debug
metadata: {}
message:
Knex query: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."villages" on "villages"."village_id" = "work_village_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" inner join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" inner join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" inner join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" inner join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" inner join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" inner join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" inner join "master"."countries" on "countries"."id" = "application_basic_details"."nationality_id" inner join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" inner join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4


timestamp: 2025-05-30T06:39:43.122Z
level: debug
metadata: {}
message:
Knex query: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" left join "master"."states" on "states"."state_id" = "work_state_id" left join "master"."districts" on "districts"."district_id" = "work_district_id" left join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" left join "master"."villages" on "villages"."village_id" = "work_village_id" left join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" left join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" left join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" left join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" left join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" left join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" left join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" left join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" left join "master"."countries" on "countries"."id" = "application_basic_details"."nationality_id" left join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" left join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id", "application_work_details"."department_details_id", "application_basic_details"."basic_details_id"


timestamp: 2025-05-30T06:39:43.178Z
level: error
metadata: {}
message:
Knex query error: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" left join "master"."states" on "states"."state_id" = "work_state_id" left join "master"."districts" on "districts"."district_id" = "work_district_id" left join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" left join "master"."villages" on "villages"."village_id" = "work_village_id" left join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" left join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" left join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" left join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" left join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" left join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" left join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" left join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" left join "master"."countries" on "countries"."id" = "application_basic_details"."nationality_id" left join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" left join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id", "application_work_details"."department_details_id", "application_basic_details"."basic_details_id" - column "application_basic_details.basic_details_uuid" must appear in the GROUP BY clause or be used in an aggregate function


timestamp: 2025-05-30T06:40:21.976Z
level: debug
metadata: {}
message:
Knex query: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" left join "master"."states" on "states"."state_id" = "work_state_id" left join "master"."districts" on "districts"."district_id" = "work_district_id" left join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" left join "master"."villages" on "villages"."village_id" = "work_village_id" left join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" left join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" left join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" left join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" left join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" left join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" left join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" left join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" left join "master"."countries" on "countries"."id" = "application_basic_details"."nationality_id" left join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" left join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id", "application_work_details"."department_details_id", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid"


timestamp: 2025-05-30T06:40:22.068Z
level: error
metadata: {}
message:
Knex query error: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" left join "master"."states" on "states"."state_id" = "work_state_id" left join "master"."districts" on "districts"."district_id" = "work_district_id" left join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" left join "master"."villages" on "villages"."village_id" = "work_village_id" left join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" left join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" left join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" left join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" left join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" left join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" left join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" left join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" left join "master"."countries" on "countries"."id" = "application_basic_details"."nationality_id" left join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" left join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id", "application_work_details"."department_details_id", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid" - column "application_basic_details.application_uuid" must appear in the GROUP BY clause or be used in an aggregate function


timestamp: 2025-05-30T06:40:49.845Z
level: debug
metadata: {}
message:
Knex query: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" left join "master"."states" on "states"."state_id" = "work_state_id" left join "master"."districts" on "districts"."district_id" = "work_district_id" left join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" left join "master"."villages" on "villages"."village_id" = "work_village_id" left join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" left join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" left join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" left join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" left join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" left join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" left join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" left join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" left join "master"."countries" on "countries"."id" = "application_basic_details"."nationality_id" left join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" left join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id", "application_work_details"."department_details_id", "application_basic_details"."basic_details_id", "application_basic_details"."application_uuid", "application_basic_details"."basic_details_uuid"


timestamp: 2025-05-30T06:40:49.915Z
level: error
metadata: {}
message:
Knex query error: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."office_district_id", "application_work_details"."office_state_id", "application_work_details"."office_mandal_id", "application_work_details"."office_village_id", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_village_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id" from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" inner join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" left join "master"."states" on "states"."state_id" = "work_state_id" left join "master"."districts" on "districts"."district_id" = "work_district_id" left join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" left join "master"."villages" on "villages"."village_id" = "work_village_id" left join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "office_mandal_id" left join "master"."villages" as "office_villages" on "villages"."village_id" = "office_village_id" left join "master"."states" as "office_states" on "states"."state_id" = "office_state_id" left join "master"."districts" as "office_districts" on "districts"."district_id" = "office_district_id" left join "master"."departments" on "departments"."department_id" = "application_work_details"."department_id" left join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" left join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" left join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" left join "master"."countries" on "countries"."id" = "application_basic_details"."nationality_id" left join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_distrcit_id" left join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 and "application_work_details"."is_active" = $4 group by "applicant_details"."application_id", "application_work_details"."department_details_id", "application_basic_details"."basic_details_id", "application_basic_details"."application_uuid", "application_basic_details"."basic_details_uuid" - column "application_basic_details.secondary_phone_no" must appear in the GROUP BY clause or be used in an aggregate function


