This function runs an existing report, using its report_id obtained from the get_reports function.<\/p>\n
http:\/\/www.myserver.com\/evj\/ExtraView\/ev_api.action? \n 1.\u00a0 1.\u00a0 2.\u00a0 3.\u00a0 4.\u00a0 For\u00a0 For\u00a0 Note: you need to have the parameter\u00a0 5.\u00a0 For\u00a0 For\u00a0 For other display types, you need to specify the database values<\/p>\n 6.\u00a0 This function runs an existing report, using its report_id obtained from the get_reports function. SYNTAX http:\/\/www.myserver.com\/evj\/ExtraView\/ev_api.action? user_id=username &password=password\u00a0OR\u00a0[&access_token=token-value] &statevar=run_report [&username_display=ID | LAST | FIRST] [&api_reverse_lookup=NO | YES] &report_id=nnnn &page_length=100 &record_start=1 &record_count=120 \u200b[&p_output_type=MS_EXCEL | MS_WORD | PDF | TEXT] [&persist_handle=xxx] [&exclude_data_images=no | yes] [&field1=value1] [&field2=value2] [&fieldn=valuen] NOTES This command runs a report from the available list…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"","_lmt_disable":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"class_list":["post-22450","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"\n
\nuser_id=username
\n&password=password<\/span>\u00a0OR\u00a0[&access_token=token-value]
\n&statevar=run_report
\n[&username_display=ID | LAST | FIRST]
\n[&api_reverse_lookup=NO | YES]
\n&report_id=nnnn
\n&page_length=100
\n&record_start=1
\n&record_count=120 \u200b[&p_output_type=MS_EXCEL | MS_WORD | PDF | TEXT]
\n[&persist_handle=xxx] [&exclude_data_images=no | yes]
\n[&field1=value1] [&field2=value2] [&fieldn=valuen]<\/span><\/p>\nNOTES<\/h3>\n
\n
p_output_type\u00a0<\/code>parameter.\u00a0 You may output the report to Microsoft Excel, Microsoft Word, Adobe PDF or text.\u00a0 If the parameter is not provided, the report will output to XML<\/li>\n\n
\n
\n
DATE_CREATED<\/code>\u00a0– Date Created<\/li>\nTIMESTAMP\u00a0<\/code>– Last Modified<\/li>\nPRIORITY\u00a0<\/code>– Priority<\/li>\n<\/ul>\n<\/li>\nuser_id=xx&password=xx
\n&statevar=run_report
\n&page_length=100
\n&record_start=1
\n&username_display=LAST
\n&report_id=1234
\n&api_reverse_lookup=YES
\n&p_ql_search_mode=ADVANCED
\n&p_fset=0
\n&p_fieldName=DATE_CREATED
\n&p_operator=between
\n&p_value1_EVDISPLAY=09\/01\/2017
\n&p_mvalue1=09\/01\/2017
\n&p_value2=09\/30\/2017
\n&p_fset=0
\n&p_fieldName=TIMESTAMP
\n&p_operator=>
\n&p_value1_EVDISPLAY=09\/08\/2017
\n&p_mvalue1=09\/08\/2017
\n&p_fset=0
\n&p_fieldName=PRIORITY
\n&p_operator==
\n&p_value1_EVDISPLAY=P 2
\n&p_mvalue1=<\/code><\/li>\np_fset<\/code>
\n2.\u00a0p_fieldName<\/code>
\n3.\u00a0p_operator<\/code>
\n4.\u00a0p_value1_EVDISPLAY<\/code>
\n5.\u00a0p_mvalue1<\/code>
\n6.\u00a0p_value2<\/code><\/li>\np_fset<\/code>\u00a0–\u00a0p_fset<\/code>\u00a0is always set to\u00a00<\/code>, like\u00a0p_fset=0<\/code><\/p>\np_fieldName<\/code>\u00a0–\u00a0p_fieldName<\/code>\u00a0is the Data Dictionary name, such as\u00a0p_fieldName=DATE_CREATED<\/code>,\u00a0p_fieldName=TIMESTAMP<\/code>, and\u00a0p_fieldName=PRIORITY<\/code><\/p>\np_operator<\/code>\u00a0–\u00a0p_operator\u00a0<\/code>is one of the following values but depends on the display type of the field, the same as in the desktop user interface<\/p>\n\u00a0\u00a0\u00a0\u00a0\u00a0 =<\/code>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 ><\/code>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 <<\/code>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 <><\/code>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 <=<\/code>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 >=<\/code>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 contains<\/code>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 not_empty<\/code>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 empty<\/code>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 between<\/code><\/p>\np_value1_EVDISPLAY<\/code>\u00a0– for\u00a0POPUP<\/code>,\u00a0DATE\u00a0<\/code>and\u00a0DAY\u00a0<\/code>display type fields, you need to specify this value<\/p>\nDATE\u00a0<\/code>and\u00a0DAY\u00a0<\/code>fields,\u00a0 an example is\u00a0p_value1_EVDISPLAY=09\/08\/2017<\/code><\/p>\nPOPUP\u00a0<\/code>fields an example is\u00a0p_value1_EVDISPLAY=P 2<\/code><\/p>\napi_reverse_lookup=YES\u00a0<\/code>to enable the reverse lookup of list fields using their title rather than their name or the database UDF_LIST_ID.<\/p>\np_mvalue1<\/code>\u00a0– All display types, except\u00a0POPUP<\/code>\u00a0need to specify the database values<\/p>\nDATE\u00a0<\/code>and\u00a0DAY<\/code>\u00a0fields, you need to specify the same value of\u00a0p_value1_EVDISPLAY<\/code>, for example\u00a0p_mvalue1=09\/08\/2017<\/code><\/p>\nPOPUP<\/code>\u00a0fields, you don’t need to specify any parameter if\u00a0api_reverse_lookup=YES<\/code><\/p>\np_value2<\/code>\u00a0–\u00a0p_value2<\/code>\u00a0is only used for\u00a0DATE\u00a0<\/code>and\u00a0DAY\u00a0<\/code>fields when you using the\u00a0between<\/code>\u00a0operator, for example\u00a0p_value2=09\/30\/2017<\/code><\/li>\n<\/ul>\n<\/li>\naccess_token<\/code>\u00a0parameter allows you to use a valid OAuth2 token obtained with the\u00a0get_token<\/code>\u00a0command.\u00a0 If you provide the\u00a0access_token<\/code>\u00a0parameter, then the\u00a0user_id<\/code>\u00a0and\u00a0password<\/code>\u00a0parameters should not be provided.\u00a0 This prevents the password being sent in clear text over your network connection<\/li>\nsearch\u00a0<\/code>API command.\u00a0 The\u00a0search\u00a0<\/code>API command has more flexibility in this case<\/li>\nexclude_data_images<\/code>\u00a0will inhibit images embedded within HTML Area fields from being output, if set to a value of\u00a0yes<\/code><\/li>\n