J.M.

[javiermm...@gmail.com]

Hi,



I'm experimenting a very weird behaviuor querying a collection. Let me explain:

I have a collection populated with some records like this (in spanish):
[
{
estado: "Demanda",
numTarjeta: "123456789",
subestado: "Transmitido",
fechaActualizacion: "02/10/2016",
numSeguimiento: "100",
entrega: "sucursal"
},
{
estado: "Demanda",
numTarjeta: "987654321",
subestado: "Transmitido",
fechaActualizacion: "02/10/2016",
numSeguimiento: "101",
entrega: "sucursal"
},
{
estado: "Producción",
numTarjeta: "123654789",
subestado: "Entregado a mensajería",
fechaActualizacion: "02/10/2016",
numSeguimiento: "102",
entrega: "sucursal"
},
.
.
.
]

And I'm trying to query from a Web Interface using the field 'numSeguimiento'. In my script JS I have the following:

function load_ok(result) {
//some more stuff
}


function load_ko(result) {
alert("ko \n " + JSON.stringify(result));
}

function list_ok_test(result) {
console.log("ok=" + JSON.stringify(result));
}

function list_ko_test(result) {
alert("ko=" + JSON.stringify(result));
}

function load_item(numSeguimiento) {
var my_pattern = {};
my_pattern.numSeguimiento = numSeguimiento;
console.log(my_pattern);
col_tarjetas.loadCallback(my_pattern,{},list_ok_test,list_ko_test);
col_tarjetas.listCallback(my_pattern, {}, load_ok, load_ko);
}


The function load_item(numSeguimiento) is executed when a button is cliked.

The behaviour is the following:
if I write in a textfield a value that does not exist in the collection as a value of the field numSeguimiento, an error message is shown in the WI, and the console.log shows an empty result.
if I write in a textfield a value that exists in the collection as a value of the field numSeguimiento, the rest of the values are shown in the WI and the console.log shows the record correctly...
...almost...
At the moment, I have 21 records (the value of the field numSeguimiento is 100, 101, 102, ..., 120 for each record), Well the query, works for all of them excepts for the record with value 100 (written above), and the record with value 106, which looks like this:
{
estado: "Demanda",
numTarjeta: "312645978",
subestado: "Solicitado",
fechaActualizacion: "04/10/2016",
numSeguimiento: "106",
entrega: "sucursal"
},

Besides, if I make the query with listCallback function and pattern = {} the result returns ALL objects.
I have tried to write in plain text the content of the collection searching, maybe a rare character but It seems it's correct.
I have tried to remove the data and insert it again, even deleting the collection and creating it again, but the result is the same.

What's happening??? How can I solve the problem?



Thaks again and regards.

[Pankaj Kumar]

Hi Javier,

Please share the error details when you give "numSeguimiento" value 100 or 106 to fetch the data from collection. Also please test ListCallBack method setting the pattern ("numSeguimiento" : 100 or 106), is this method also gives the same error? Please attach the screen-print of the error you are getting for more understanding of the error.

Thank you,

Pankaj Kumar

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/1700c3a5-0e0a-4e8f-ba8f-14ddca2fa5d1%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[J.M.]

Hi Pankaj,

The problem is... there is no error. Simply the result of the query is empty as if the query does not find the record.

And yes, I've tried both function (list and load) and the behaviour is the same.

However, I've notice something.

I insert the records reading a file from a process (see this post: https://groups.google.com/a/runmyprocess.com/forum/?hl=en&fromgroups=#!topic/supportforum/LLbaex4WS9o [and thank you Pankaj])

After reading, for each line of the file I create an object with the info and insert it into the collection. The point is the records that are not being found, are the first record (first line in the files) bein inserted each time. That is, I made the insertion twice. Fisrt time 100-105, and the second one 106-120. And the record failing are 100 and 106.

This confuse me a lot. Am I doing something wrong iwhile reading the file? (My code is copy-apste from the linked post)



Thanks again and regards.


P.S: Sorry for the title, I missmatch with the 'By' field and now I cannot edit it.

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

[Pankaj Kumar]

Hi Javier,

Since you are not getting any error, one possibility is, query using pattern "numSeguimiento" : 100 or 106 is not returning any object, while listCallBack method with empty pattern giving all the result.

As for debug, you can export full collection data from RunMyProcess IDE to analysis the data in the collection and check the values, also you can try to make query on other column on collection to to see those object properties.

Thank you,

Pankaj Kumar

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/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/c1e0b594-e69e-45ad-ac4c-9748c41bc2c6%40runmyprocess.com.

[javiermm...@gmail.com]

Hi Pankaj,

On Tuesday, October 18, 2016 at 1:05:25 PM UTC+2, Pankaj Kumar wrote:
> Hi Javier,
>
>

> Since you are not getting any error, one possibility is, query using pattern "numSeguimiento" : 100 or 106 is not returning any object, while listCallBack method with empty pattern giving all the result.

That's exactly what is happening, but why is the query not returning a value? The record exists and has the value I'm looking for.

> As for debug, you can export full collection data from RunMyProcess IDE to analysis the data in the collection and check the values, also you can try to make query on other column on collection to to see those object properties.

Yes, I know. I've checked these records (100 and 106), but I cannot see any difference with the other ones. Regarding to make a query on other column, I need to make it by numSeguimiento as a requirement.


Thank you and regards.

[Murali]

Hi Javier,

Were you able to find the solution?
Please explore the application data and queries used to find the root-cause.

For additional assistance, we can setup the support contract and have screen-share call arranged.
Awaiting for your feedback.

Regards,
Murali
Fujitsu RunMyProcess Support

[Javier Martín]

The issue is still there. The first record of each load for the collection is not found.

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to a topic in the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/KQWIt7e7Ve4/unsubscribe.
To unsubscribe from this group and all its topics, 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/87d4f69b-002c-47de-910a-66516674276d%40runmyprocess.com.