某些交互式网格中的列未使用apex_region.export_data APEX API函数导出。

huangapple
go评论80阅读模式
英文:

Some columns in Interactive Grid didn't exported using apex_region.export_data APEX API function

问题

我使用以下SQL查询创建了一个交互式网格：

  1. select
  2.     REGISTERATION_ID,
  3.     STUDENT_ID,
  4.     DRIVER_ID,
  5.     DELIVERY_TYPE,
  6.     PAYMENT_TYPE,
  7.     AMOUNT,
  8.     CURRENCY,
  9.     DISCOUNT_TYPE,
  10.     DISCOUNT_AMOUNT,
  11.     NET_AMOUNT,
  12.     START_DATE,
  13.     END_DATE,
  14.     PAID_AMOUNT,
  15.     UNPAID_AMOUNT
  16. from myTable

现在我想使用apex_region.export_data API函数导出这个网格的数据：

  1. l_export := apex_region.export_data (
  2.     p_format       => apex_data_export.c_format_json,
  3.     p_as_clob      => true,  
  4.     p_page_id      => 620,
  5.     p_region_id    => no_of_region_id,
  6.     p_data_only    => true);
  7. v_clob_json_items := l_export.content_clob;

在v_clob_json_items中返回的JSON对象如下：

  1. {
  2.     "items": [
  3.         {
  4.             "student_id": "student_name_of_select_list_item_with_value_id",
  5.             "start_date": "2023-05-30T00:00:00",
  6.             "end_date": "2023-07-12T00:00:00",
  7.             "driver_id": "driver_name_of_select_list_item",
  8.             "delivery_type": "ذهاب وإياب",
  9.             "net_amount": 12000,
  10.             "payment_type": "أسبوعي",
  11.             "paid_amount": 0,
  12.             "unpaid_amount": 12000
  13.         },
  14.         {
  15.             "student_id": "student_name_of_select_list_item_with_value_id",
  16.             "start_date": "2023-01-31T00:00:00",
  17.             "end_date": "2023-05-29T00:00:00",
  18.             "driver_id": "driver_name_of_select_list_item",
  19.             "delivery_type": "ذهاب وإياب",
  20.             "net_amount": 40000,
  21.             "payment_type": "شهري",
  22.             "paid_amount": 40000,
  23.             "unpaid_amount": 0
  24.         }
  25.     ]
  26. }

我期望CURRENCY列导出了一些值，其选择列表项包含货币的值和名称。有任何建议吗？

英文:

I created an interactive Grid using this SQL Query:

  1. select
  2.     REGISTERATION_ID,
  3.     STUDENT_ID,
  4.     DRIVER_ID,
  5.     DELIVERY_TYPE,
  6.     PAYMENT_TYPE,
  7.     AMOUNT,
  8.     CURRENCY,
  9.     DISCOUNT_TYPE,
  10.     DISCOUNT_AMOUNT,
  11.     NET_AMOUNT,
  12.     START_DATE,
  13.     END_DATE,
  14.     PAID_AMOUNT,
  15.     UNPAID_AMOUNT
  16. from myTable

Now I want to export data of this Grid using the apex_region.export_data API function:

  1. l_export := apex_region.export_data (
  2.     p_format       => apex_data_export.c_format_json,
  3.     p_as_clob      => true,  
  4.     p_page_id      => 620,
  5.     p_region_id    => no_of_region_id,
  6.     p_data_only    => true);
  7. v_clob_json_items := l_export.content_clob;

the json object returned in v_clob_json_items is the following:

  1. {
  2.     "items": [
  3.         {
  4.             "student_id": "student_name_of_select_list_item_with_value_id",
  5.             "start_date": "2023-05-30T00:00:00",
  6.             "end_date": "2023-07-12T00:00:00",
  7.             "driver_id": "driver_name_of_select_list_item",
  8.             "delivery_type": "\u0630\u0647\u0627\u0628 \u0648\u0625\u064A\u0627\u0628",
  9.             "net_amount": 12000,
  10.             "payment_type": "\u0623\u0633\u0628\u0648\u0639\u064A",
  11.             "paid_amount": 0,
  12.             "unpaid_amount": 12000
  13.         },
  14.         {
  15.             "student_id": "student_name_of_select_list_item_with_value_id",
  16.             "start_date": "2023-01-31T00:00:00",
  17.             "end_date": "2023-05-29T00:00:00",
  18.             "driver_id": "driver_name_of_select_list_item",
  19.             "delivery_type": "\u0630\u0647\u0627\u0628 \u0648\u0625\u064A\u0627\u0628",
  20.             "net_amount": 40000,
  21.             "payment_type": "\u0634\u0647\u0631\u064A",
  22.             "paid_amount": 40000,
  23.             "unpaid_amount": 0
  24.         }
  25.     ]
  26. }

I expect that CURRENCY column exported some values, its select list item contain currencies values and names. any suggestions?

答案1

得分: 0

你确定要导出的列是否已启用了"包括在导出/打印中"的列属性？ 某些交互式网格中的列未使用apex_region.export_data APEX API函数导出。

英文:

Did you make sure that the column you'd like to be exported has the column attribute "Include in export/print" enabled?某些交互式网格中的列未使用apex_region.export_data APEX API函数导出。

huangapple
  • 本文由 发表于 2023年8月9日 15:48:56
  • 转载请务必保留本文链接：https://go.coder-hub.com/76865641-2.html
  • oracle-apex
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定