VOC support #2882
closed[OMH] Date request - Rate+allotment check 0112 & please check my request as below.
Description
Dear Team,
Good day!
I would like to request data below. Also, please include CC @Jungwon Yoon (Sophia) as well, as I could not check the email immediately between 12 Jan ~ 17 Jan.
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?
We would like to collect it by ASAP
Very appreciate for your help and assistance.
Thank you.
Best Regards,
Grace
Files
Updated by Mon Nguyen about 2 months ago
- File 2026-01-12-export-hotel-bookable-3-range.xlsx 2026-01-12-export-hotel-bookable-3-range.xlsx added
- File Script.sql Script.sql added
- Due date set to 01/13/2026
- Status changed from 신규(New) to QA test
- Assignee changed from Mon Nguyen to Tracy Tran
- Start date set to 01/12/2026
- % Done changed from 0 to 100
- Estimated time set to 9.00 h
- Build env. set to Prod
Dear Mrs. Tracy Tran
Please help me double check file on attachment
Thanks you
Updated by Tracy Tran about 2 months ago
- Status changed from QA test to 완료성공(Resolve)
- Assignee changed from Tracy Tran to Mon Nguyen
sent to Content
