英文:
Some columns in Interactive Grid didn't exported using apex_region.export_data APEX API function
问题
我使用以下SQL查询创建了一个交互式网格：
select
REGISTERATION_ID,
STUDENT_ID,
DRIVER_ID,
DELIVERY_TYPE,
PAYMENT_TYPE,
AMOUNT,
CURRENCY,
DISCOUNT_TYPE,
DISCOUNT_AMOUNT,
NET_AMOUNT,
START_DATE,
END_DATE,
PAID_AMOUNT,
UNPAID_AMOUNT
from myTable
现在我想使用apex_region.export_data API函数导出这个网格的数据：
l_export := apex_region.export_data (
p_format => apex_data_export.c_format_json,
p_as_clob => true,
p_page_id => 620,
p_region_id => no_of_region_id,
p_data_only => true);
v_clob_json_items := l_export.content_clob;
在v_clob_json_items中返回的JSON对象如下：
{
"items": [
{
"student_id": "student_name_of_select_list_item_with_value_id",
"start_date": "2023-05-30T00:00:00",
"end_date": "2023-07-12T00:00:00",
"driver_id": "driver_name_of_select_list_item",
"delivery_type": "ذهاب وإياب",
"net_amount": 12000,
"payment_type": "أسبوعي",
"paid_amount": 0,
"unpaid_amount": 12000
},
{
"student_id": "student_name_of_select_list_item_with_value_id",
"start_date": "2023-01-31T00:00:00",
"end_date": "2023-05-29T00:00:00",
"driver_id": "driver_name_of_select_list_item",
"delivery_type": "ذهاب وإياب",
"net_amount": 40000,
"payment_type": "شهري",
"paid_amount": 40000,
"unpaid_amount": 0
}
]
}
我期望CURRENCY列导出了一些值，其选择列表项包含货币的值和名称。有任何建议吗？
英文:
I created an interactive Grid using this SQL Query:
select
REGISTERATION_ID,
STUDENT_ID,
DRIVER_ID,
DELIVERY_TYPE,
PAYMENT_TYPE,
AMOUNT,
CURRENCY,
DISCOUNT_TYPE,
DISCOUNT_AMOUNT,
NET_AMOUNT,
START_DATE,
END_DATE,
PAID_AMOUNT,
UNPAID_AMOUNT
from myTable
Now I want to export data of this Grid using the apex_region.export_data API function:
l_export := apex_region.export_data (
p_format => apex_data_export.c_format_json,
p_as_clob => true,
p_page_id => 620,
p_region_id => no_of_region_id,
p_data_only => true);
v_clob_json_items := l_export.content_clob;
the json object returned in v_clob_json_items is the following:
{
"items": [
{
"student_id": "student_name_of_select_list_item_with_value_id",
"start_date": "2023-05-30T00:00:00",
"end_date": "2023-07-12T00:00:00",
"driver_id": "driver_name_of_select_list_item",
"delivery_type": "\u0630\u0647\u0627\u0628 \u0648\u0625\u064A\u0627\u0628",
"net_amount": 12000,
"payment_type": "\u0623\u0633\u0628\u0648\u0639\u064A",
"paid_amount": 0,
"unpaid_amount": 12000
},
{
"student_id": "student_name_of_select_list_item_with_value_id",
"start_date": "2023-01-31T00:00:00",
"end_date": "2023-05-29T00:00:00",
"driver_id": "driver_name_of_select_list_item",
"delivery_type": "\u0630\u0647\u0627\u0628 \u0648\u0625\u064A\u0627\u0628",
"net_amount": 40000,
"payment_type": "\u0634\u0647\u0631\u064A",
"paid_amount": 40000,
"unpaid_amount": 0
}
]
}
I expect that CURRENCY column exported some values, its select list item contain currencies values and names. any suggestions?
答案1
得分: 0
你确定要导出的列是否已启用了"包括在导出/打印中"的列属性？ 
英文:
Did you make sure that the column you'd like to be exported has the column attribute "Include in export/print" enabled?
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论