Empty date as default

333 views
Skip to first unread message

com...@vaquerotrading.com

unread,
Dec 28, 2017, 5:36:24 PM12/28/17
to Fujitsu RunMyProcess Developer Community
I have an array with one date column, these column may contains a value or not, but when the value is empty i have the next error
Expression arrayLote.fpago[P_index] is undefined on line 1, column 129 in Actualizar Lotes.

How can I put this value as null as default, Im try
arrayLote.fpago[P_index]?default(null) but get the same error

Prachi Chandak

unread,
Dec 29, 2017, 4:54:57 AM12/29/17
to com...@vaquerotrading.com, Fujitsu RunMyProcess Developer Community
Hello Sir,

If you want to keep the date column empty then you can check 'Initialize' option present in widget configuration and set it to empty value (Refer screenshot). This will allow you to submit the process/ or execute  the task without error.

Please refer the link for configuration information of date widget.

Kindly let us know the given solution is helpful to you or not.

Thanks & Regards,
Prachi Chandak
Fujitsu RunMyProcess Support


--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/e09ddc98-174b-4a48-8b23-3ce201efc59d%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

date_initailize_default.JPG

com...@vaquerotrading.com

unread,
Dec 29, 2017, 11:46:15 AM12/29/17
to Fujitsu RunMyProcess Developer Community, com...@vaquerotrading.com
Dear Pchandak

I'm try your fix but not work, i got the same error on the process, in the attach file arrayLote the column fpago doesnt exist, in the arrayLote process error it show the error

Thanks

arrayLote process error.PNG
arrayLote.PNG

Prachi Chandak

unread,
Dec 29, 2017, 12:30:57 PM12/29/17
to com...@vaquerotrading.com, Fujitsu RunMyProcess Developer Community
Hello,

Can you please share the array confirugation and process configuration so that we can understand it more clearly.
Also, please elaborate more as the given information is not representing complete scenario of the error you are getting.



Thanks & Regards,
Prachi Chandak
Fujitsu RunMyProcess Support

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.

com...@vaquerotrading.com

unread,
Dec 29, 2017, 2:18:37 PM12/29/17
to Fujitsu RunMyProcess Developer Community, com...@vaquerotrading.com
Im attach the arrayConf.png and process.png

On Thursday, 28 December 2017 15:36:24 UTC-7, com...@vaquerotrading.com wrote:

arrayConf.PNG
process.PNG

Ghanshyam Mule

unread,
Dec 29, 2017, 3:39:16 PM12/29/17
to Fujitsu RunMyProcess Developer Community, com...@vaquerotrading.com
Hello Sir,

We have checked screenshots & configuration of array widget provided by you last reply.

Can you please do configuration given in attached screenshot. It would be helpful to resolve your issue.

Please feel free to contact us for more information.

regards,
Ghanshyam
Fujitsu RunMyProcess Suppport



--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.
array_date_widget_configuration.JPG
process_config.JPG
web_interface.JPG
process_result.JPG
final_result.JPG

Ghanshyam Mule

unread,
Jan 1, 2018, 3:38:04 AM1/1/18
to Fujitsu RunMyProcess Developer Community, com...@vaquerotrading.com
Hello Sir,

Have you checked screenshot provided in the last post in order to debug your issue?

If not please check it & feel free to contact us for more information.

regards,
Ghanshyam


Prachi Chandak

unread,
Jan 3, 2018, 12:03:43 PM1/3/18
to com...@vaquerotrading.com, Fujitsu RunMyProcess Developer Community
Hello Sir,

Awaiting for your response.

Please revert us if you still need any help.

Thanks & Regards,
Prachi Chandak
Fujitsu RunMyProcess Support

com...@vaquerotrading.com

unread,
Jan 5, 2018, 6:42:31 PM1/5/18
to Fujitsu RunMyProcess Developer Community, com...@vaquerotrading.com
Sorry for the late
I have tested today but continue without work

On Thursday, 28 December 2017 15:36:24 UTC-7, com...@vaquerotrading.com wrote:

Prachi Chandak

unread,
Jan 11, 2018, 4:47:31 PM1/11/18
to com...@vaquerotrading.com, Fujitsu RunMyProcess Developer Community
Hello Sir,

I assume that you have some array widget on WI which contain some columns. And on submission of this form(WI) you are trying to access this array widget values into the process.
So as to access the array widget column into the process you  just need to initialize the array name in input parameter. (Refer screenshot).

If you want to iterate the row of array you can use loop in freemarker. No need to use [P_index] to access values one by one.
The above given configurations in post sent at 30/12/17 is correct and clear.

Please check and go step wise to resolve the error.
Kindly revert us for further query.


Thanks & Regards,
Prachi Chandak
Fujitsu RunMyProcess Support

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.
array.png

Prachi Chandak

unread,
Jan 15, 2018, 2:03:07 AM1/15/18
to com...@vaquerotrading.com, Fujitsu RunMyProcess Developer Community
Hello Sir,

We are waiting for your update.
Please let us know if you are still facing issues.

Thanks for contacting Fujitsu RunMyProcess Support.

Thanks & Regards,
Prachi Chandak
Fujitsu RunMyProcess Support

com...@vaquerotrading.com

unread,
Jan 15, 2018, 10:55:17 PM1/15/18
to Fujitsu RunMyProcess Developer Community, com...@vaquerotrading.com
Hello Pchandak

Yes all that you asume its right, but im try to leave the date column empty, but when submitted, fail in the process loop when try to access the value of array colum.

Thanks

On Thursday, 28 December 2017 15:36:24 UTC-7, com...@vaquerotrading.com wrote:

Prachi Chandak

unread,
Jan 15, 2018, 11:53:27 PM1/15/18
to com...@vaquerotrading.com, Fujitsu RunMyProcess Developer Community
Hello Sir,

In that case either I will recommend you to implement a simple WI having one array widget along with a attached process accessing the array value in as given below format.
Take input parameter in process and access it like - ${array_variable_name.col_variable_name}

Or we can have hangout session to resolve the error together.

Please let us know your availability accordingly. Do feel free to discuss any other issue.

Thanks & Regards,
Prachi Chandak
Fujitsu RunMyProcess Support

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.

Prachi Chandak

unread,
Jan 19, 2018, 2:30:19 AM1/19/18
to com...@vaquerotrading.com, Fujitsu RunMyProcess Developer Community
Hello Sir,

Awaiting for your response.
Can you please update the status of issue?

Regards,
Prachi

Thanks & Regards,
Prachi Chandak
Fujitsu RunMyProcess Support

Edgar Montoya

unread,
Jan 19, 2018, 2:57:52 AM1/19/18
to Prachi Chandak, Fujitsu RunMyProcess Developer Community
Hi prachi 
I have tested today and got the empty columns but when try to acces the data, the column show undefined value with JavaScript code on the process I need to access value by value for insert data in a database with a conector

To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.

To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.

Prachi Chandak

unread,
Jan 30, 2018, 7:40:21 AM1/30/18
to Edgar Montoya, Fujitsu RunMyProcess Developer Community
Hello Sir,

Sorry for inconvenience caused.

Can you please share the JS code you are using to access those array values in process so that we can test here and give some work around.

Please feel free to ask any further query if required.



Thanks & Regards,
Prachi Chandak
Fujitsu RunMyProcess Support

To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.

To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.

Prachi Chandak

unread,
Feb 1, 2018, 11:05:52 AM2/1/18
to Edgar Montoya, Fujitsu RunMyProcess Developer Community
Hi,

Awaiting for your feedback.


Thanks & Regards,
Prachi Chandak
Fujitsu RunMyProcess Support

com...@vaquerotrading.com

unread,
Feb 1, 2018, 1:50:24 PM2/1/18
to Fujitsu RunMyProcess Developer Community, com...@vaquerotrading.com
On Thursday, 28 December 2017 15:36:24 UTC-7, com...@vaquerotrading.com wrote:

My js code its:
TipoTrato=${arrayLote.tTrato[P_index]}&PPP=${arrayLote.pPunto[P_index]}&CondicionPago=${arrayLote.condicion[P_index]}&FecPago=${arrayLote.fpago[P_index]}

where arrayLote.fpago its the date string value

Zoho update rows.PNG

Prachi Chandak

unread,
Feb 12, 2018, 4:18:50 AM2/12/18
to Edgar Montoya, Fujitsu RunMyProcess Developer Community
Hello Sir,

Sorry for inconvenience caused.

Could you please remove [P_index] in the from code and try the given below - 

TipoTrato=${arrayLote.tTrato}&PPP=${arrayLote.pPunto}&CondicionPago=${arrayLote.condicion}&FecPago=${arrayLote.fpago}

I implement the same type of array as yours and I am able to access all the cell data rather empty or with some value (refer attachments).

I do not find any error of type undefined value with JavaScript. 

I will suggest you to please check the codes implemented properly. This could only help you resolve the issue.

Please write us back if you have any other query.

Thanks & Regards,
Prachi Chandak
Fujitsu RunMyProcess Support

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.
array_result.JPG
array_variable.JPG

com...@vaquerotrading.com

unread,
Feb 12, 2018, 4:25:04 PM2/12/18
to Fujitsu RunMyProcess Developer Community, com...@vaquerotrading.com
On Thursday, 28 December 2017 15:36:24 UTC-7, com...@vaquerotrading.com wrote:

I dont know how this help me to solve my issue without P_index, i need to inser value by value in a zoho reports database table row with matching criteria.

Ghanshyam Mule

unread,
Feb 12, 2018, 5:02:26 PM2/12/18
to Fujitsu RunMyProcess Developer Community, com...@vaquerotrading.com
Hello Sir,

You can use syntax mentioned in last post & accordingly pass all required values as input parameter to add row into Zoho report database table connector/web service .

Please try it & let us know if have any issue.

Thanks,
Ghanshyam




--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.

Ghanshyam Mule

unread,
Feb 18, 2018, 11:33:30 PM2/18/18
to Fujitsu RunMyProcess Developer Community, com...@vaquerotrading.com
Hello Sir,

Have you checked solution suggested in last reply?

We are waiting your reply.

regards,
Ghanshyam
Reply all
Reply to author
Forward
0 new messages