VOC support #2604
closed[OMH] Date request - Rate+allotment check 1215 & please check my request as below.
Description
I would like to request data below. Rate+allotment check 1215
1. For 30 days: If there is rate & allotment below 10days , please mark it as "No bookable".
--> which mean we have 1/3 has no allotment/rate.
2. For 60days: From 31~60days, If there is rate & allotment below 10days , please mark it as "No bookable".
3. For 90days: From 61~90days, If there is rate & allotment below 10days , please mark it as "No bookable".
Could you please help divide the data into these time segments (0–30 days, 31–60 days, 61–90 days) accordingly?
Also, besides of adding the region/city, there are also duplicate hotels, which you mentioned before since is based on contract, is it possible to include the contract type as well?
Please check the example for 20251103 attached.
If possible, we would like to collect it by today.
Very appreciate for your help and assistance.
Thank you.
Best Regards,
Grace
Files
Updated by Mon Nguyen 3 months ago
- File 20251212-export-hotel-bookable-30-60-90.xlsx 20251212-export-hotel-bookable-30-60-90.xlsx added
- File Script.sql Script.sql added
- Due date set to 12/12/2025
- Status changed from 신규(New) to QA test
- Assignee changed from Mon Nguyen to Tracy Tran
- Start date set to 12/12/2025
- % Done changed from 0 to 100
- Estimated time set to 0.50 h
- Build env. set to Prod
Dear Mrs. Tracy Tran
Please help me double check data on file .xlsx attachment
Thank you
Updated by Tracy Truong 3 months ago
- Status changed from QA test to 완료성공(Resolve)
- Assignee changed from Tracy Tran to Mon Nguyen
Already sent bookable file to request person
Thank you!
