Requirement

This question is asked by consultant during Jerry’s supporting as dev angel.
Partner wants to develop some report in the backend to track which users have performed what kinds of Fiori group personlization but he didn’t know the corresponding database table which contains the needed information, or available API which can return the necessary information.

How to analyze this requirement

點(diǎn)擊Personalization icon：

創(chuàng)建一個(gè)新的group, 輸入title信息后回車，trigger一個(gè)send到后臺的OData request，成功執(zhí)行( status code 201 - created )

user 手動輸入的title信息作為request payload傳入后臺：

Solution

Based on backend debugging on the OData request handling displayed above, we can write the following two simple reports.
first report
This report will display the personalization guid with given time period for current user.

顯示輸出：

report source code:

REPORT ZGET_PERSONALIZATION.PARAMETERS: start TYPE WDY_CONF_USER-changedon OBLIGATORY default sy-datlo,end like start OBLIGATORY DEFAULT sy-datlo.DATA: lt_config TYPE TABLE OF wdy_conf_user,lt_text TYPE STANDARD TABLE OF WDY_CONF_USERt2,ls_text LIKE LINE OF lt_text.START-OF-SELECTION.SELECT * INTO TABLE lt_config FROM WDY_CONF_USER WHERE changedon BETWEEN START and endand changedby = sy-uname.IF sy-subrc <> 0.WRITE: / 'no configuration found for given time period'.RETURN.ENDIF.SELECT * INTO TABLE lt_text FROM WDY_CONF_USERt2 FOR ALL ENTRIES IN lt_configWHERE config_id = lt_config-config_id.LOOP AT lt_text INTO ls_text.WRITE: / 'id: ', ls_text-config_id, ' description: ' , ls_text-description.ENDLOOP.

the second report
將打印出的configuration guid 6BBE9D15576F539BA37A2C26D5E6D424抄下來，執(zhí)行另一個(gè)report。
該report能夠打印出此configuration guid對應(yīng)的configuration detail：

Source code:

REPORT ZREAD_WDY_CONF_USER. PARAMETERS: guid type WDY_CONF_USER-config_id OBLIGATORY. DATA: lt_config TYPE STANDARD TABLE OF WDY_CONF_USER. START-OF-SELECTION.SELECT * INTO TABLE lt_config FROM WDY_CONF_USER WHERE config_id = guidand changedby = sy-uname.

要獲取更多Jerry的原創(chuàng)文章，請關(guān)注公眾號"汪子熙":

總結(jié)

以上是生活随笔為你收集整理的打印某个user在指定时间段内做过的personalization detail的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。