Project

General

Profile

Actions

VOC support #2882

closed

[OMH] Date request - Rate+allotment check 0112 & please check my request as below.

Added by Tracy Tran about 2 months ago. Updated about 2 months ago.

Status:
완료성공(Resolve)
Priority:
높음(High)
Assignee:
Target version:
Start date:
01/12/2026
Due date:
01/13/2026
% Done:

100%

Estimated time:
9.00 h
Spent time:
Part:
Build env.:
Prod

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

2026-01-12-export-hotel-bookable-3-range.xlsx (3.42 MB) 2026-01-12-export-hotel-bookable-3-range.xlsx Mon Nguyen, 01/13/2026 01:17 AM
Script.sql (3.1 KB) Script.sql Mon Nguyen, 01/13/2026 01:18 AM
Actions

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 50 MB)