Adding related objects to a particular object

Data Service
1

I can’t add objects to my new list!

Recently, I have been trying to add objects to a new list in the data console but I have spotted a problem which does not allow me to add all the object I need on that list. Since I have too many objects now, everytime I pass to the next page and update the list, the selected objects which are not on the actual page are removed from the list. I took screenshots to explain myself easier:

  1. ComboSub is the list in which I want to add the new objects PRODUCTOS that I have recently created.
    https://mail.google.com/mail/u/0/?ui=2&ik=fe76007834&view=fimg&th=14c427b4590ab3c8&attid=0.3&disp=emb&realattid=ii_14c3f45cc99b39f2&attbid=ANGjdJ8SGA5XQ2XlSNpFP-RVDNigjuVDcPrVlDG8jZ3zrbpFnwxHDf3FrF7PJOwFgsCY_o6Ov-xU4WFAgDF6L1hBrr3P_mO0NsuJ2dLEXUpiAR-LlyJpZpgkZXP9JcA&sz=w824-h242&ats=1427047236608&rm=14c427b4590ab3c8&zw&atsh=1</img>

  2. Here I select the new objects I want to add to the list. This is a list which already has some other objects.
    https://mail.google.com/mail/u/0/?ui=2&ik=fe76007834&view=fimg&th=14c427b4590ab3c8&attid=0.1&disp=emb&realattid=ii_14c3f4a3dcde2919&attbid=ANGjdJ9nIaoUZh2yg4OVpU1DfFllmBh-Uvb1lTqZQ0GWo5fnxnQdfxSIQeJaORmwioBI8nOuD08i0yQo4dz8aYn-9lKdp4pv_84FxCBK8c7_ewKcJH3yzGoe_F1v3wg&sz=w694-h824&ats=1427047236608&rm=14c427b4590ab3c8&zw&atsh=1</img>

  3. As soon as I change the page, the “Record Selected” counter restarts and only shows the items that I selected in the actual page (Seems like the other items are not selected anymore).
    https://mail.google.com/mail/u/0/?ui=2&ik=fe76007834&view=fimg&th=14c427b4590ab3c8&attid=0.2&disp=emb&realattid=ii_14c4270211a48014&attbid=ANGjdJ-J223hgxjC5IIeIzu7XFKIm0BJ0HxpzyI9rxVzefPzDSNcFUGPbi2ZGIp9RfNF8eDFNz5a8Xwf5RaBys5hl9bZJ_iiA287tZRYmX4tzQfSXcWZ7192E44jMRM&sz=w864-h1028&ats=1427047236608&rm=14c427b4590ab3c8&zw&atsh=1</img>

  4. The new objects are added.

https://mail.google.com/mail/u/0/?ui=2&ik=fe76007834&view=fimg&th=14c427b4590ab3c8&attid=0.4&disp=emb&realattid=ii_14c4274d926e4342&attbid=ANGjdJ_Rkl-vE-KNJsH8NZLC6hDmZQqqurqLlsrTEePuEwLH0iG67dg30rJYez29OcA_6ZQ-iq3J8xWFvzIi5FpZTlSFQ06_yCmzmIjhl3GP5aWBgL2oFVqHB126xpk&sz=w808-h188&ats=1427047236608&rm=14c427b4590ab3c8&zw&atsh=1</img>

  1. As shown in step 1, these items were previously selected are they are no longer selected. I do need to add several items that are not seen on the main page. As I try to add new items, the previous items are removed so it is really difficult to group them all within a list.
    https://mail.google.com/mail/u/0/?ui=2&ik=fe76007834&view=fimg&th=14c427b4590ab3c8&attid=0.5&disp=emb&realattid=ii_14c42781b8677d26&attbid=ANGjdJ_BtV8ELeEOOVDwXmFEtgGOPY5wDweUefVVThphbLykya7bMjmH4qkD6FIdf3BLdQ6QkOnGVBAiHpN4syZLo6YRmCcPwNWir0m1Az5LZD46x35oN-nT4ZVV2vI&sz=w864-h1028&ats=1427047236608&rm=14c427b4590ab3c8&zw&atsh=1</img>

Hope this clears everything much more. I would appreciate some help with this.

Thank you!

2

Hello Nicolas,

I’ve came along this problem just now and had an easy work around idea.

you can for now query all the objects you want so they appear in one list and then select all of them then update your relation.

Just tick the SQL Search toggle button to [ON], write down the [names] of the objects you want to add then use the below code:

objectName1=value1 OR objectName2=value2 OR objectName3=value3 OR objectName4=value4 OR etc…

If your objects have a common value it would be easier.

Best Regards.

3

Hello Omar,

Sounds great as a short term solution. However, I might be doing something wrong since the SQL Search is not working properly. My object has several attributes, but the one I can easily identify is the name attribute, which is a string.

I’ve tried the following command: name=apple OR name = pear
The red borderline appears as if I am not declaring the object properly.

I also tried using “apple” instead of apple or even “Apple” to see if it was case sensitive por something but still doesn’t work.

Hope the attachment helps to explain the problem if it is not clear enough

Thanks in advance

Captura de pantalla 2015-04-16 a las 10.43.09 a.m..png