Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

WeCMDB支持历史数据查询 #538

Closed
jordanzhangsz opened this issue Dec 17, 2019 · 3 comments
Closed

WeCMDB支持历史数据查询 #538

jordanzhangsz opened this issue Dec 17, 2019 · 3 comments
Assignees
@junchensz @ElliotShi
Labels
enhancement New feature or request

Comments

@jordanzhangsz
Copy link
Collaborator

jordanzhangsz commented Dec 17, 2019 •
edited
Loading

描述您的需求
为了满足用户对CMDB数据的多维度查询需求，需要增强我们的API接口，支持对历史数据的多功能查询，如可按某个fixed_date进行查询，查出该fixed_date当时的所有CI的状态，供API使用方进行按需展示

预期行为

  1. 输入指定fixed_date，可查单个CI的数据状态
  2. 输入指定fixed_date，可查多个CI(综合查询）的数据状态
@jordanzhangsz jordanzhangsz added the enhancement New feature or request label Dec 17, 2019
@junchensz junchensz self-assigned this Dec 18, 2019
@jordanzhangsz
Copy link
Collaborator Author

跟超哥对齐了一下，除了上面的1，2两点，根据fixed_date查CI外，还需支持：

  1. CMDB的数据查询接口，有一个参数控制查询：
    时间：查询条件增加update time < 时间。
    类型1: 返回r_guid一样的最新一条纪录。并在此基础上加过滤条件。
    类型2: 返回r_guid一样的最新一条confirm且非删除状态的的纪录，并在此基础上加过滤条件。（当前现实）
    类型3: 返回所有纪录，包括历史纪录。

对应前端，可以在查询和管理图形的上面增加一个“时间选择”和“查询类型选择”的条件输入框。并在后继的查询提示在右上角。

@jordanzhangsz jordanzhangsz changed the title CI数据支持按时间进行切片查询 WeCMDB支持历史数据查询 Dec 23, 2019
@jordanzhangsz
Copy link
Collaborator Author

类型名称：

  1. 最新
  2. 现实
  3. 所有

@ElliotShi ElliotShi self-assigned this Dec 24, 2019
@zhangsenfeng
Copy link
Contributor

示意图
image

ElliotShi added a commit that referenced this issue Dec 25, 2019
@ElliotShi
enhance #538 support to query CI data history. v0.1
cc6581b
xuxuzhesi added a commit that referenced this issue Dec 26, 2019
@xuxuzhesi
#538 Supports querying the latest ci data for the non-deleted status …
9660073 
…of confirm
xuxuzhesi added a commit that referenced this issue Dec 26, 2019
@xuxuzhesi
#538 Fix the query cidata for type 2
0f50821
jordanzhangsz added a commit that referenced this issue Dec 27, 2019
@jordanzhangsz
Merge pull request #587 from WeBankPartners/538_support_CI_data_histo…
02bd9a2 
…ry_query

#538 support ci data history query
ElliotShi added a commit that referenced this issue Dec 27, 2019
@ElliotShi
#538 bugfix on updated date format
bba1334
jordanzhangsz added a commit that referenced this issue Dec 27, 2019
@jordanzhangsz
Merge pull request #590 from WeBankPartners/538_support_CI_data_histo…
b425023 
…ry_query

#538 bugfix on updated date format
xuxuzhesi added a commit that referenced this issue Dec 27, 2019
@xuxuzhesi
#538 Fix the cidata query by fix date
c5ccbc9
xuxuzhesi added a commit that referenced this issue Dec 27, 2019
@xuxuzhesi
#538 Fix the cidata query by fixed date
a5bd8c3
ElliotShi added a commit that referenced this issue Dec 27, 2019
@ElliotShi
#538 enhance smart updated date
8da8949
jordanzhangsz added a commit that referenced this issue Dec 27, 2019
@jordanzhangsz
Merge pull request #594 from WeBankPartners/538_query_cidata_by_type
1debad5 
#538 Fix the cidata query by fix date
xuxuzhesi added a commit that referenced this issue Dec 28, 2019
@xuxuzhesi
#538 Fix the cidata query
5ab00c9
xuxuzhesi added a commit that referenced this issue Dec 28, 2019
@xuxuzhesi
#538 Canonical variable naming
d934e8e
jordanzhangsz added a commit that referenced this issue Dec 31, 2019
@jordanzhangsz
Merge pull request #596 from WeBankPartners/538_cidate_type_query
0d3146e 
#538 Fix the cidata query
xuxuzhesi added a commit that referenced this issue Jan 3, 2020
@xuxuzhesi
#538 Return empty when query result empty
62b009e
xuxuzhesi added a commit that referenced this issue Jan 3, 2020
@xuxuzhesi
#538 Fix the sql syntax
7645e36
jordanzhangsz added a commit that referenced this issue Jan 3, 2020
@jordanzhangsz
Merge pull request #608 from WeBankPartners/538_fix_sql_syntax
a349120 
#538 Return empty when query result empty
@xuxuzhesi xuxuzhesi mentioned this issue Jan 19, 2020
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@junchensz junchensz

@ElliotShi ElliotShi

Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@junchensz @ElliotShi @zhangsenfeng @jordanzhangsz