Search found 0 matches

by Takis
Mon Jul 20, 2020 7:56 pm
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

; } } text = ""{ \""$or\"": ["" + text + ""] }""; //Added code //38.002788

by Takis
Mon Jul 20, 2020 7:56 pm
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

; } } text = ""{ \""$or\"": ["" + text + ""] }""; text1= '{ ""Location"" : { ""$nearSphere"" : [' + localStorage.getItem(""markerLng"") + '

by Takis
Mon Jul 20, 2020 1:17 pm
Forum: Moved from Get Satisfaction
Topic: Read array of local storage and parse it to use it in DB query where clause
Replies: 5
Views: 570

Read array of local storage and parse it to use it in DB query where clause

; } } text = ""{ \""$or\"": ["" + text + ""] }""; return text; ======================== this code goes to the JS button of the Service of the ""where"" value. NO mapping is required."

by Takis
Tue Nov 29, 2016 7:22 pm
Forum: Moved from Get Satisfaction
Topic: No header and footer
Replies: 2
Views: 494

No header and footer

Thanks!
Clever and beautiful!

by Takis
Tue Nov 29, 2016 4:41 pm
Forum: Moved from Get Satisfaction
Topic: No header and footer
Replies: 2
Views: 494

No header and footer

Hello

I select jquery template and one page is created.
How to remove/hide the header and footer ?

Thanks a lot

by Takis
Fri Nov 11, 2016 8:27 am
Forum: Moved from Get Satisfaction
Topic: API express change JSON result format
Replies: 10
Views: 1151

API express change JSON result format

I think I did not explain properly...

by Takis
Thu Nov 10, 2016 1:55 pm
Forum: Moved from Get Satisfaction
Topic: Help with collapsible set with list inside
Replies: 10
Views: 1016

Help with collapsible set with list inside

Dear team

Can you please update this thread with documentation links that work?
Many people are asking about building a two level menu.

Please assist

by Takis
Thu Nov 10, 2016 12:28 pm
Forum: Moved from Get Satisfaction
Topic: Create a database app with a Second Level
Replies: 9
Views: 778

Create a database app with a Second Level

And how I will keep any values that customer may selected before invocation?

by Takis
Wed Nov 09, 2016 9:28 pm
Forum: Moved from Get Satisfaction
Topic: API express change JSON result format
Replies: 10
Views: 1151

API express change JSON result format

Any feedback please. Should have been easy.

by Takis
Wed Nov 09, 2016 3:15 pm
Forum: Moved from Get Satisfaction
Topic: API express change JSON result format
Replies: 10
Views: 1151

API express change JSON result format

Or can by done in a Script component?

by Takis
Wed Nov 09, 2016 1:58 pm
Forum: Moved from Get Satisfaction
Topic: API express change JSON result format
Replies: 10
Views: 1151

API express change JSON result format

The result I want is (simplyfied)

Food
4, Fast Food
5, Mexican

Sport
3, Tenis

So using Mapping component, I would like to group the initial output by MenuName (Food, Sport)

by Takis
Wed Nov 09, 2016 1:56 pm
Forum: Moved from Get Satisfaction
Topic: API express change JSON result format
Replies: 10
Views: 1151

API express change JSON result format

What I want to do is take the output of the JSON (api express SQL component), change the grouping and then give the final changed JSON response.

Can be done by Mapping component? Image

by Takis
Wed Nov 09, 2016 11:25 am
Forum: Moved from Get Satisfaction
Topic: API express change JSON result format
Replies: 10
Views: 1151

API express change JSON result format

Hello I used API express, I connected to an external MYSQL, OK. I created the call OK and I get the below response, after executing my SQL query [{ "MenuName": "Food", "MenuSubID": 4, "MenuSubName": "Fast Food" }, { "MenuName": "Food&q...
by Takis
Wed May 25, 2016 2:04 pm
Forum: Moved from Get Satisfaction
Topic: Display different columns from DB Service, depending on the application language selected
Replies: 18
Views: 1428

Display different columns from DB Service, depending on the application language selected

Sorry is not very clear. I am trying to dynamically change the text of the Collapsblock header, to show either Greek or English, depending on a local variable. So I have the JS code in the top level as seen below, as you told me https://d2r1vs3d9006ap.cloudfront.net/s3_images/1422067/6_inline.gif?14...
by Takis
Tue May 24, 2016 1:45 pm
Forum: Moved from Get Satisfaction
Topic: Display different columns from DB Service, depending on the application language selected
Replies: 18
Views: 1428

Display different columns from DB Service, depending on the application language selected

Can you explain why the JS code has the effect shown in the last two pictures uploaded please?

Thanks.

by Takis
Tue May 24, 2016 11:51 am
Forum: Moved from Get Satisfaction
Topic: Display different columns from DB Service, depending on the application language selected
Replies: 18
Views: 1428

Display different columns from DB Service, depending on the application language selected

When I use the JS code, the result is the below https://d2r1vs3d9006ap.cloudfront.net/s3_images/1421399/5_inline.gif?1464090605 When I do the mapping without the JS code (not dynamic mapping) it is displayed properly https://d2r1vs3d9006ap.cloudfront.net/s3_images/1421400/4_inline.gif?1464090663 So ...
by Takis
Tue May 24, 2016 10:28 am
Forum: Moved from Get Satisfaction
Topic: Display different columns from DB Service, depending on the application language selected
Replies: 18
Views: 1428

Display different columns from DB Service, depending on the application language selected

Sorry, I am not sure I was clear I have Collapsible block header which maps to database column TopMenu1_en or TopMenu1_gr Inside the CollapsibleBlock I have checkboxes, which maps to database column SubMenu_en or SubMenu_gr When I choose language "en", I want to dynamically change the mapp...
by Takis
Mon May 23, 2016 9:14 am
Forum: Moved from Get Satisfaction
Topic: Display different columns from DB Service, depending on the application language selected
Replies: 18
Views: 1428

Display different columns from DB Service, depending on the application language selected

This command seems is not the correct one element.find('[name="InterestsColabsibleHeader"]').text(goalColumnValue); As currently the top menu is not displayed correctly. The mappings you told me to delete is related to the second level menu. Afterwards of course the second level, should be...
by Takis
Mon May 23, 2016 9:13 am
Forum: Moved from Get Satisfaction
Topic: Display different columns from DB Service, depending on the application language selected
Replies: 18
Views: 1428

Display different columns from DB Service, depending on the application language selected

I have a two level menu

One level with TopMenu_xx
and below each TopMenu_xx I have the SubMenu1_xxx

So the first level is not displayed correctly as a collapsible Header Image

by Takis
Mon May 23, 2016 7:01 am
Forum: Moved from Get Satisfaction
Topic: Can't save my project and test does not work
Replies: 15
Views: 1356

Can't save my project and test does not work

So if a project does NOT have any CSS is OK?

by Takis
Fri May 20, 2016 11:43 am
Forum: Moved from Get Satisfaction
Topic: Display different columns from DB Service, depending on the application language selected
Replies: 18
Views: 1428

Display different columns from DB Service, depending on the application language selected

When I run it I see this

Image

So text is shown in Greek correctly, but the text does not go in the

InterestsColabsibleHeader text, in order to be able to see it as a checkbox, as it should

by Takis
Fri May 20, 2016 11:40 am
Forum: Moved from Get Satisfaction
Topic: Display different columns from DB Service, depending on the application language selected
Replies: 18
Views: 1428

Display different columns from DB Service, depending on the application language selected

Hi I used the below code for testing ================================= var currentLanguage = "gr"; //localStorage.getItem("mylangSelection"); //Link message to collumn name. var langColumnMapping = { "en": "TopMenu_en", "gr": "TopMenu_gr" }...
by Takis
Fri May 20, 2016 10:36 am
Forum: Moved from Get Satisfaction
Topic: Can't save my project and test does not work
Replies: 15
Views: 1356

Can't save my project and test does not work

I think I solve it, by deleting all CSS.
Seems they were corrupted.

Is it mandatory to have one CSS per project?

by Takis
Fri May 20, 2016 9:25 am
Forum: Moved from Get Satisfaction
Topic: Can't save my project and test does not work
Replies: 15
Views: 1356

Can't save my project and test does not work

What do you mean actualize?
I did not had these problems before creation of _Perix
I did not do anything special, just used one of your themes.

by Takis
Fri May 20, 2016 8:39 am
Forum: Moved from Get Satisfaction
Topic: Can't save my project and test does not work
Replies: 15
Views: 1356

Can't save my project and test does not work

Hi

The functionality works now, but is something wrong with the interface/themes.
Please see attached picture Image

by Takis
Wed May 18, 2016 9:20 am
Forum: Moved from Get Satisfaction
Topic: Can't save my project and test does not work
Replies: 15
Views: 1356

Can't save my project and test does not work

I tried this and 99% of the time I get the same error (first screenshot as uploaded before)
I also tried deleting the contents of the theme "winter" and then make the delete of the theme, but again the same error

Are you able to delete the themes?
I shared it again.

Thanks.

by Takis
Tue May 17, 2016 12:22 pm
Forum: Moved from Get Satisfaction
Topic: Can't save my project and test does not work
Replies: 15
Views: 1356

Can't save my project and test does not work

Hi

I just share it.
Name is "Perix"

by Takis
Tue May 17, 2016 11:32 am
Forum: Moved from Get Satisfaction
Topic: Can't save my project and test does not work
Replies: 15
Views: 1356

Can't save my project and test does not work

Hi

In the last days I can not save my project anymore and test also does not work.
I thought it was a temporary server problem, but the issue persists.

Please assist.

by Takis
Fri Apr 22, 2016 2:01 pm
Forum: Moved from Get Satisfaction
Topic: Display different columns from DB Service, depending on the application language selected
Replies: 18
Views: 1428

Display different columns from DB Service, depending on the application language selected

I have the above current mapping.

How is your previous code applies to this case?
Should I remove all mappings and leave only the top one?

I would like to have, TopMenu and SubMenu (gr, en) selection based on what the user selected.

by Takis
Fri Apr 22, 2016 1:58 pm
Forum: Moved from Get Satisfaction
Topic: Display different columns from DB Service, depending on the application language selected
Replies: 18
Views: 1428

Display different columns from DB Service, depending on the application language selected

Previous reply from you was =================== EMPLOYEE Yurii Orishchuk (Employee) 1 year ago Hi Panagiotis, Here is a brief plan: 1 Make link from $ object to table. To iterate it. http://prntscr.com/57h3zn/direct 2 Click on "JS" on this link. 3 Populate it with following JS code: http:/...
by Takis
Fri Apr 22, 2016 12:55 pm
Forum: Moved from Get Satisfaction
Topic: Display different columns from DB Service, depending on the application language selected
Replies: 18
Views: 1428

Display different columns from DB Service, depending on the application language selected

Hello I have an app that displays a menu (check boxes) of selections on the first page. The labels of the check boxes are stored on the database. I created a service that get these values from database and works fine. I want to create another column in the database, that will contain the same labels...
by Takis
Wed Mar 11, 2015 6:35 pm
Forum: Moved from Get Satisfaction
Topic: Incorrect JSON array [longitude, latitude] value: [-86.633965;41.896216]
Replies: 4
Views: 417

Incorrect JSON array [longitude, latitude] value: [-86.633965;41.896216]

Bruce, YOU ARE RIGHT!
I used the ";" which is wrong.
When put "," is fine.

Thanks!

by Takis
Wed Mar 11, 2015 4:24 pm
Forum: Moved from Get Satisfaction
Topic: Incorrect JSON array [longitude, latitude] value: [-86.633965;41.896216]
Replies: 4
Views: 417

Incorrect JSON array [longitude, latitude] value: [-86.633965;41.896216]

Hi all For the adresses I used for Greece, for example [23.793436,38.004065] works fine no issue. In this case the number are the way around lat=23.793436 long=38.004065 For the address I use in USA [-86.633965;41.896216] I get Incorrect JSON array [longitude, latitude] value Why, what is the correc...
by Takis
Sat Nov 22, 2014 8:08 pm
Forum: Moved from Get Satisfaction
Topic: Grid with labels, loop to get the values
Replies: 8
Views: 573

Grid with labels, loop to get the values

In one page, I am trying to get all the checkboxes that I created dynamically, that are checked and get its values. I got up to this point of code code var items = jQuery('[name="mobilecheckbox_157"]'); alert ( "how many chbx:" + jQuery('[name="mobilecheckbox_157"]')&am...
by Takis
Sat Nov 22, 2014 5:22 pm
Forum: Moved from Get Satisfaction
Topic: Sub menu of check boxes
Replies: 26
Views: 2123

Sub menu of check boxes

Well looks not so complex, I just do not know yet the proper code.
I need to iterate in each collpasbleset, iterate through checkboxes, then move to next collapasbleset and do the same...

by Takis
Fri Nov 21, 2014 10:34 am
Forum: Moved from Get Satisfaction
Topic: Sub menu of check boxes
Replies: 26
Views: 2123

Sub menu of check boxes

Well, I now simplified my structure, no grids. Is like this now Settings mobilecontainer/ mobilecollapsibleset_146 /mobilecollapsblock_147 /mobilecollapsblockcontent_149 / mobilecheckboxgroup_156 /mobilecheckbox_157 I use the code: code var index; var text; var mobilecheckboxgroup = Apperyio("m...
by Takis
Thu Nov 20, 2014 8:32 am
Forum: Moved from Get Satisfaction
Topic: Sub menu of check boxes
Replies: 26
Views: 2123

Sub menu of check boxes

Do I have to do something to see the console log?

I used alert and I get "checked items =0"

I does not seem to go in to the code of "mobilecheckboxgroup.each(function(){"

by Takis
Wed Nov 19, 2014 8:28 pm
Forum: Moved from Get Satisfaction
Topic: Sub menu of check boxes
Replies: 26
Views: 2123

Sub menu of check boxes

The construct I have is like this "Settings mobilecontainer / mobilegrid_130/ mobilegridcell_131 /mobilecollapsblock_135 / mobilecollapsblockcontent_137 / mobilegrid_138 /mobilegridcell_139 / mobilecheckboxgroup_143/ mobilecheckbox_144" and I am trying to iterate and collect all the checkb...
by Takis
Wed Nov 19, 2014 7:21 pm
Forum: Moved from Get Satisfaction
Topic: Sub menu of check boxes
Replies: 26
Views: 2123

Sub menu of check boxes

EXACTLY it works!
Many thanks!

For the benefit of others, code used in the mapping of second level grid (checkboxes)
code
var stringValue = String(value).trim().split("@");
if (stringValue[1] == "false") {
element.hide();
}
/code

by Takis
Wed Nov 19, 2014 9:42 am
Forum: Moved from Get Satisfaction
Topic: Sub menu of check boxes
Replies: 26
Views: 2123

Sub menu of check boxes

I have a grid, to put first level of collabsibleset
and then another grid inside the content arear of collapsibleset, where I put the checkbox.

You have same configuration?

Thanks.

by Takis
Wed Nov 19, 2014 8:10 am
Forum: Moved from Get Satisfaction
Topic: Sub menu of check boxes
Replies: 26
Views: 2123

Sub menu of check boxes

The space appear for the item that value of Visible is false. Do you have similar links as mine, shown in mine previous screenshot? Do you have items that you set somehow dynamically the Visible to false I take the value of visible as you proposed code var stringValue = String(value).trim()&...
by Takis
Tue Nov 18, 2014 2:59 pm
Forum: Moved from Get Satisfaction
Topic: Sub menu of check boxes
Replies: 26
Views: 2123

Sub menu of check boxes

Or how can I prevent item that has "@false" not to be initially returned from the query?

Image

by Takis
Tue Nov 18, 2014 9:45 am
Forum: Moved from Get Satisfaction
Topic: Sub menu of check boxes
Replies: 26
Views: 2123

Sub menu of check boxes

many thanks! got it. By this approach I have the below spaces problem https://d2r1vs3d9006ap.cloudfront.net/s3_images/1121661/spaces_inline.gif?1416303750 Can this be fixed, no to have spaces between? The spaces appear when there is false in the array, like "Food2@false" How I can prevent ...
by Takis
Mon Nov 17, 2014 12:56 pm
Forum: Moved from Get Satisfaction
Topic: Sub menu of check boxes
Replies: 26
Views: 2123

Sub menu of check boxes

I figure it out. In order for what you proposed to work, I need to create a column of type array in my DB for the SubMenu https://d2r1vs3d9006ap.cloudfront.net/s3_images/1121227/dbtable_inline.gif?1416228740 That woks fine. Now I thought I can go another step and include in the array if the SubMenu ...
by Takis
Mon Nov 17, 2014 10:17 am
Forum: Moved from Get Satisfaction
Topic: Return specific column based on language selected
Replies: 3
Views: 299

Return specific column based on language selected

Hi Evgene The fist option looks it would use unwanted resources and data, but is an option of course. For the second option, I read but I could understand how this can be done. Can you give me a simple example/screen shot please? Lets say I have local storage variable "mylangSelection" ,a ...
by Takis
Mon Nov 17, 2014 8:02 am
Forum: Moved from Get Satisfaction
Topic: Sub menu of check boxes
Replies: 26
Views: 2123

Sub menu of check boxes

Thanks

Can I have the thread?
As I do not understand completely the two level rest service approach.
In your example what is friends[], what data does it holds?

by Takis
Mon Nov 17, 2014 7:56 am
Forum: Moved from Get Satisfaction
Topic: Return specific column based on language selected
Replies: 3
Views: 299

Return specific column based on language selected

Hi team Suppose I have a table with Offers and has columns that displays the offers in different languages, like Offer_gr, Offer_fr, Offer_eg, Offer_it Lets say that user selects a language from a "settings" page and I store the value to a local storage variable. Then I want to create a qu...
by Takis
Sun Nov 16, 2014 10:51 am
Forum: Moved from Get Satisfaction
Topic: Prevent Duplicate Records
Replies: 5
Views: 359

Prevent Duplicate Records

An example please?

by Takis
Sat Nov 15, 2014 8:39 am
Forum: Moved from Get Satisfaction
Topic: Sub menu of check boxes
Replies: 26
Views: 2123

Sub menu of check boxes

https://d2r1vs3d9006ap.cloudfront.net/s3_images/1120677/pp_inline.png?1416040212 What I would like to create is, a menu with submenus of checkboxes, which are created dynamically from a DB table. I know and can create the top menu with a query service What is the best way forward? Use check boxes ?...
by Takis
Fri Nov 14, 2014 9:05 am
Forum: Moved from Get Satisfaction
Topic: Sub menu of check boxes
Replies: 26
Views: 2123

Sub menu of check boxes

Thanks What about collapsableSet? This is my main concern, how to put under each section the proper entries. I have a table with two columns, one with first level menu text (menu) and another column (submenu) with submenus of each menu text. I can populate the first level of collapsableSet, dynamica...
by Takis
Thu Nov 13, 2014 2:06 pm
Forum: Moved from Get Satisfaction
Topic: Sub menu of check boxes
Replies: 26
Views: 2123

Sub menu of check boxes

Hi team I have created a dynamic menu of check boxes which gets its values from a DB table. Can I create a dynamic sub menu for each initial menu item? For example : If someone checks Food, then I would like a sub menu of check boxes to appear so a selection is made. I would like the whole structure...
by Takis
Thu Nov 13, 2014 12:46 pm
Forum: Moved from Get Satisfaction
Topic: Refresh Query service definition after change in db table
Replies: 2
Views: 225

Refresh Query service definition after change in db table

Hi I a have a DB table I create a query service I import it to a page, use it and all works fine. Later I add a column to that table or I change the definition of a column. Do I have to delete the service, recreate and re-import to the page? Is there a way to "refresh" the service so it ta...
by Takis
Thu Nov 13, 2014 9:58 am
Forum: Moved from Get Satisfaction
Topic: Custom web interface for the database
Replies: 7
Views: 428

Custom web interface for the database

Yes I want to build a custom web site for my "customers". I want them to be able to login and make basic actions on their records only, so I will not have to do anything. Only charged them :-) !!! So lets say, I build view,update,delete, save functionality onrecords of a table in your back...
by Takis
Wed Nov 12, 2014 7:24 pm
Forum: Moved from Get Satisfaction
Topic: Custom web interface for the database
Replies: 7
Views: 428

Custom web interface for the database

Hi Sorry I am new to this. For example I would like to build a WEB site (not mobile app), where my customer can log in, and view, update, delete rows on a database table, which is stored in your back end. Can this be done? A simple example, of displaying the data of a table? Can I somehow use the so...
by Takis
Wed Nov 12, 2014 8:43 am
Forum: Moved from Get Satisfaction
Topic: Google map multiple markers works on test and not on Android
Replies: 20
Views: 1321

Google map multiple markers works on test and not on Android

The question is, how do I put a line break in the text of the info window that will be displayed.

infowindow.setContent('Content of ' + linebreak + data.location + ''); ????

Thanks!

by Takis
Wed Nov 12, 2014 8:19 am
Forum: Moved from Get Satisfaction
Topic: Paging
Replies: 8
Views: 726

Paging

Sorry disregard previous question about list of tutorials.

by Takis
Wed Nov 12, 2014 8:18 am
Forum: Moved from Get Satisfaction
Topic: Paging
Replies: 8
Views: 726

Paging

Thanks I will look on it!

by Takis
Wed Nov 12, 2014 8:17 am
Forum: Moved from Get Satisfaction
Topic: Paging
Replies: 8
Views: 726

Paging

Thanks I will on it!

I do not know if is already exists, but it would be good if we can have a link with ALL the available tutorials and brief description.

by Takis
Tue Nov 11, 2014 6:51 pm
Forum: Moved from Get Satisfaction
Topic: Google map multiple markers works on test and not on Android
Replies: 20
Views: 1321

Google map multiple markers works on test and not on Android

Does "push" means specific command, like?

self.markersArray.push(marker);

If yes, what should I do ?
I want to put a break in the text of the info window.

Thanks!

by Takis
Tue Nov 11, 2014 3:01 pm
Forum: Moved from Get Satisfaction
Topic: How to check if current date/time is within a date/time range
Replies: 4
Views: 352

How to check if current date/time is within a date/time range

When I use this code in button var d = new Date(); d.setDate(d.getDate()); var dateStr = d.toISOString(); alert (dateStr); I get 2 hours time difference. Do I need to setup time zone? Is the date not taken from the system, mobile timezone? https://d2r1vs3d9006ap.cloudfront.net/s3_images/1119111/date...
by Takis
Tue Nov 11, 2014 2:41 pm
Forum: Moved from Get Satisfaction
Topic: How to check if current date/time is within a date/time range
Replies: 4
Views: 352

How to check if current date/time is within a date/time range

This seems to work I will check further var d = new Date(); d.setDate(d.getDate()); var dateStr = d.toISOString(); return '{"DateStart":{"$gte":"'+ dateStr +'"}}'; Example {$and: [{ "ValidFrom": {$lte: "2014-11-11T00:00:00.000Z"} },{ "ValidTo&qu...
by Takis
Tue Nov 11, 2014 10:30 am
Forum: Moved from Get Satisfaction
Topic: How to check if current date/time is within a date/time range
Replies: 4
Views: 352

How to check if current date/time is within a date/time range

Hi

I want to construct a dynamic where clause to check current date/time is within a date/time range (start, end).
Can I do the same with a +1 or -1 hour range?

Thanks.

by Takis
Tue Nov 11, 2014 8:46 am
Forum: Moved from Get Satisfaction
Topic: Determine if two geolocation cycles intersect
Replies: 14
Views: 794

Determine if two geolocation cycles intersect

Thanks Yurii

This is what I finally did.
I could not find another way to do it in one step.

by Takis
Tue Nov 11, 2014 7:39 am
Forum: Moved from Get Satisfaction
Topic: Google map multiple markers works on test and not on Android
Replies: 20
Views: 1321

Google map multiple markers works on test and not on Android

Thanks I will try it.

I tried code<br>/code, in my below code

codeCreateMarker({lat: cords_latlng[0], long: cords_latlng[1], location: customer + " <br>" +locations });/code
or

with escape character before < and

but does not work.

by Takis
Tue Nov 11, 2014 7:14 am
Forum: Moved from Get Satisfaction
Topic: Paging
Replies: 8
Views: 726

Paging

Hi Ευγενιε The documentation says "To limit the number of objects you get, use the limit parameter." I do not want to just limit my application to return the first 20 (based on my example above). I want to retrieve the first 20 then press a button and return the next 20, and next...until I...
by Takis
Mon Nov 10, 2014 8:54 pm
Forum: Moved from Get Satisfaction
Topic: Paging
Replies: 8
Views: 726

Paging

Hi

Can you explain a bit more?
What do you mean on which index to start?
Let say I have a table with 1000 rows.
I make a query with some criteria and it returns 500 rows, for example.

How I create paging of 20 records at a time, implementing next page, next page...?

Thanks!.

by Takis
Mon Nov 10, 2014 8:12 pm
Forum: Moved from Get Satisfaction
Topic: Google map multiple markers works on test and not on Android
Replies: 20
Views: 1321

Google map multiple markers works on test and not on Android

Hi If I put this code, then the code is not executed if(!self.markersArray) self.markersArray(); I used your code without the above and self.markersArray.push(marker); Can you explain why is not working? Is there an issue if it do not include the above lines of code? How can I put a line break on th...
by Takis
Mon Nov 10, 2014 7:56 pm
Forum: Moved from Get Satisfaction
Topic: Determine if two geolocation cycles intersect
Replies: 14
Views: 794

Determine if two geolocation cycles intersect

Thanks. Finally what I want is to : find points within the cycle of mobile user these points have a radius where there are "visible" then I calculate the distance between the mobile and each point if the distance - radius the records returned with the function and create final list. Is the...
by Takis
Mon Nov 10, 2014 7:45 pm
Forum: Moved from Get Satisfaction
Topic: Custom web interface for the database
Replies: 7
Views: 428

Custom web interface for the database

To be sure

I would like to build my own web interface, lets say with php, so a customer of mine
can log in, view, update, delete rows stored in your back end database.

Can you give a very simple example on how this can be done?

Thanks!

by Takis
Mon Nov 10, 2014 9:17 am
Forum: Moved from Get Satisfaction
Topic: Custom web interface for the database
Replies: 7
Views: 428

Custom web interface for the database

Hi

is there a way to build a custom web interface, that will access your back end database, so they can log in and change their records, the way they like?

Thanks a lot.

by Takis
Fri Nov 07, 2014 2:03 pm
Forum: Moved from Get Satisfaction
Topic: Determine if two geolocation cycles intersect
Replies: 14
Views: 794

Determine if two geolocation cycles intersect

So what is the most advisable way? run 1st pass query and store in local variable array based on this array re-run the query, so to make the 2nd pass and filter the records or else? Is there a way to avoid running the query two times? What is an array limit, how many data can store ? Thanks.
by Takis
Fri Nov 07, 2014 12:41 pm
Forum: Moved from Get Satisfaction
Topic: Determine if two geolocation cycles intersect
Replies: 14
Views: 794

Determine if two geolocation cycles intersect

Hi Evgene Thanks, I know how to do this, I have done it already. My problem is how to return records where (for example) type is Food or Drink and the function distance(lat1, lon1, lat2, lon2, rad1, rad2) returns a value. Input values are taken from DB table. So does this query must be done in more ...
by Takis
Fri Nov 07, 2014 11:03 am
Forum: Moved from Get Satisfaction
Topic: Determine if two geolocation cycles intersect
Replies: 14
Views: 794

Determine if two geolocation cycles intersect

I have created a new Javascript in the project, gave a name and inside I created the function function distance(lat1, lon1, lat2, lon2, rad1, rad2) which returns rad2, based on some criteria Then I want use and test it in the Test tab of my query service. The below does not work (I put example value...
by Takis
Fri Nov 07, 2014 10:31 am
Forum: Moved from Get Satisfaction
Topic: Determine if two geolocation cycles intersect
Replies: 14
Views: 794

Determine if two geolocation cycles intersect

Thanks aslo I have this constructed dynamically ================= { "$and": [ {"$or": [{"Type": "Food"},{"Type": "Dance"}]}, { "Location": {"$nearSphere": [23.791376,38.002788], "$maxDistanceInKilometers": 0.5}...
by Takis
Fri Nov 07, 2014 9:44 am
Forum: Moved from Get Satisfaction
Topic: Determine if two geolocation cycles intersect
Replies: 14
Views: 794

Determine if two geolocation cycles intersect

Thanks! The below optimized code that I found, works fine. Is the below. ===================================== var R = 6371; // Radius of the earth in km var dist; var lat1=38.003934; var lon1=23.793436; var lat2=39.003934; var lon2=22.793436; var dLat = (lat2 - lat1) * Math.PI / 180; // deg2rad bel...
by Takis
Fri Nov 07, 2014 8:09 am
Forum: Moved from Get Satisfaction
Topic: Determine if two geolocation cycles intersect
Replies: 14
Views: 794

Determine if two geolocation cycles intersect

Or if the distance between the two points is less than the sum of the radius1 + radius2, then cycles intersect.

So another option is if there is function that returns the distance between two geopoints.
Is there such a function ?

by Takis
Fri Nov 07, 2014 7:27 am
Forum: Moved from Get Satisfaction
Topic: Determine if two geolocation cycles intersect
Replies: 14
Views: 794

Determine if two geolocation cycles intersect

Hi Suppose I have an app with a geoloaction service "Point1", which gives me lat1,lng1 And I have another point "Point2" in the map with lat2,lng2. I want a function to be able to determine if a cycle with center Point1 and radius radius1, INTERSECTS with a cycle with center Poin...
by Takis
Fri Nov 07, 2014 7:19 am
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

Thanks

This seems to work for my case

{ "$and": [ {"$or": [{"Type": "Food"},{"Type": "Dance"}]}, {"Location": {"$nearSphere": [23.791376,38.002788], "$maxDistanceInKilometers": 0.5}} ] }

by Takis
Thu Nov 06, 2014 7:00 am
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

The nearSphere function is working, after I renamed the column to "Location" !!! Now I am just asking of what is the correct "where" syntax for the below which I will construct dynamically If I put the below in the "where" in the Test tab, of the Query Service =========...
by Takis
Wed Nov 05, 2014 8:03 pm
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

So the remaining question {"$or": [{"Type": "Food"},{"Type": "Drink"}]} and {"Location": {"$nearSphere": [23.791376,38.002788], "$maxDistanceInKilometers": 1}} works with no error, but does not return what I want. ======...
by Takis
Wed Nov 05, 2014 7:54 pm
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

I CAN NOT BELIEVE IT !!!!!!!

4 days trying to find why is not working and the solution is .....?

Drop geopoint column CustomerGeoPoint1 and then create a NEW geopoint column with name Location.
I tried other column names and it did not work!

Why so many hours lost ?

by Takis
Wed Nov 05, 2014 7:35 pm
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

In my last update I say that I ue {"CustomerGeoPoint1": {"$nearSphere": [23.791376,38.002788], "$maxDistanceInMiles": 1}} Can someone make a simple test? -One table with one geopoint column and put same test values. -A database query service for this table -Then go to t...
by Takis
Wed Nov 05, 2014 1:56 pm
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

I am sure that at the end, the solution will be very simple....
Hope I be true !!!

by Takis
Wed Nov 05, 2014 1:51 pm
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

I just want to create an index on a geopoint column. See the picture above. I press OK and it is supposed to be created, I do not get any error. I am asking, if after creating the index, I should see in the DB GUI under the name of the column something like this ================== (geopoint),idx ===...
by Takis
Wed Nov 05, 2014 12:50 pm
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

One more info
I went in the DB on the geopoint column and I just typed inside the
[23.793436,38.004065] as you see it here.

Is this OK or I should insert the values in some other way?

by Takis
Wed Nov 05, 2014 9:14 am
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

Appery team can you please assist ?

Is the index created or not?
Should I see the ",idx" part in column where I created the index?

by Takis
Wed Nov 05, 2014 7:25 am
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

Well, I looked at some other threads and I see that in the DB table columns if there is an index in geopoint it appears as (columnName),idx This does not appear in my DB, even after recreating the index several times. I even tried to another column, but again the ",idx" part did not appear...
by Takis
Tue Nov 04, 2014 7:32 pm
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

I was missing a dot in the cords values So again.... I created the index on CustomerGeopoint1 Should I recreate the service ? In test I put {"CustomerGeoPoint1": {"$nearSphere": [23.791376,38.002788], "$maxDistanceInMiles": 1}} and the result is { "status":400...
by Takis
Tue Nov 04, 2014 5:50 pm
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

I created the index on CustomerGeopoint1 Should I recreate the service ? In test I put {"CustomerGeoPoint1": {"$nearSphere": [23.791376,38002788], "$maxDistanceInMiles": 1}} and the result is { "status":400, "uri":" https://api.appery.io/rest/1/...
by Takis
Tue Nov 04, 2014 3:19 pm
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

I have created no index. I have 5 records in the DB, to make my tests. Yes long, lat format. I even changed the values from {"CustomerGeoPoint1": {"$nearSphere": [23.791376,38002788], "$maxDistanceInMiles": 1}} to {"CustomerGeoPoint1": {"$nearSphere"...
by Takis
Tue Nov 04, 2014 12:16 pm
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

I did another test with just the geopoint where part ================================= {"CustomerGeoPoint1": {"$nearSphere": [23.791376,38002788], "$maxDistanceInMiles": 1}} ================================= and I get the error ================================= { "...
by Takis
Tue Nov 04, 2014 8:50 am
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

Yes I created a new column "CustomerGeoPoint1" of type Geopoint, in order no to mess any of my work done so far. I went service to test and I put in where the value: ================== {"$or": [{"Type":"Food"}] } AND {"CustomerGeoPoint1": {"$nea...
by Takis
Mon Nov 03, 2014 7:35 pm
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

Bruce many thanks for replying! It seems that I am missing some basics.... I have very few records, as I am currently in implementation phase. I just created the CustomerGeopoint column and added by typing the values. This is not correct? If not what is the correct way to insert values in the Custom...
by Takis
Mon Nov 03, 2014 4:09 pm
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

Are we using the correct syntax for the nearSphere ?

http://docs.mongodb.org/manual/refere...

by Takis
Mon Nov 03, 2014 2:11 pm
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

Is it because in my DB CustomerGeoPoint is a "string" type and not "Geopoint"?
If this is the case, can I work with "sting" type?
How should I save values in Geopoint ? copy/paste cords as it appears in Google maps?

by Takis
Mon Nov 03, 2014 12:31 pm
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

Many thanks!!!

I will try it!

by Takis
Sun Nov 02, 2014 2:46 pm
Forum: Moved from Get Satisfaction
Topic: Find if a map cords are withing a cycle
Replies: 39
Views: 3496

Find if a map cords are withing a cycle

Hi I have a DB where I store the lat and lng in one field with format "23.0000,89.0000" I want to return records from my DB service only if are inside a map cycle, with center my current location. I want the radius of the cycle to be configurable (100 meters, 1 km, etc). I am able to retur...
by Takis
Sun Nov 02, 2014 2:32 pm
Forum: Moved from Get Satisfaction
Topic: Grid with labels, loop to get the values
Replies: 8
Views: 573

Grid with labels, loop to get the values

Hi Suppose that I have a grid with 6 labels "Lable1"..."Lable6" , with text populated by DB service Can I loop from all labels in a record and store its values in a multi dimension array? Like an expansion of the above code you gave me. For exampe: record1= array[1] record2=array...
by Takis
Sat Nov 01, 2014 9:18 pm
Forum: Moved from Get Satisfaction
Topic: Show multiple GPS coordinates on map
Replies: 12
Views: 729

Show multiple GPS coordinates on map

Thanks
How can I center the map and zoom one of the locations, based on the above code?

by Takis
Thu Oct 30, 2014 5:12 pm
Forum: Moved from Get Satisfaction
Topic: Show multiple GPS coordinates on map
Replies: 12
Views: 729

Show multiple GPS coordinates on map

Hi

After the above is executed, I would like to

  • get my mobile location,

  • put a marker on the map

  • center the map on my location

    Can you help me?

    Thanks!

by Takis
Wed Oct 29, 2014 3:55 pm
Forum: Moved from Get Satisfaction
Topic: Google map multiple markers works on test and not on Android
Replies: 20
Views: 1321

Google map multiple markers works on test and not on Android

I get an error on build ======================================== Map.js:line 155:column 85:missing name after . operator position: new google.maps.LatLng(data.lat, data.long), Map.js:line 156:column 37:syntax error map: map, Map.js:line 157:column 43:syntax error draggable: true, Map.js:line 158:col...
by Takis
Wed Oct 29, 2014 9:10 am
Forum: Moved from Get Satisfaction
Topic: Google map multiple markers works on test and not on Android
Replies: 20
Views: 1321

Google map multiple markers works on test and not on Android

Many thanks I will try it out and let you know! In the above example, I hust need to put inside a page a Google map object, nothing else? Of course I get the lat, lng from DB. Can you reply on these also please? -Why it did not work for target 4.2.x? -Will 4.4.x be supported, as I do not see it in t...
by Takis
Tue Oct 28, 2014 10:40 am
Forum: Moved from Get Satisfaction
Topic: Google map multiple markers works on test and not on Android
Replies: 20
Views: 1321

Google map multiple markers works on test and not on Android

Can I have a sample code so I can put markers in google_map, with title, description and small photo, but just using Lat and Lng values?

How can I clear all markers before showing on map, the new set of markers?

Thanks!

by Takis
Tue Oct 28, 2014 10:38 am
Forum: Moved from Get Satisfaction
Topic: Google map multiple markers works on test and not on Android
Replies: 20
Views: 1321

Google map multiple markers works on test and not on Android

Solved

I changed the target SDK version to 4.1.x from 4.2.x.
I have Galaxy S4 with 4.4.2

Why it did not work for target 4.2.x?
Will 4.4.x be supported, as I do not see it in the list of target SDK?

Thanks.

by Takis
Tue Oct 28, 2014 7:59 am
Forum: Moved from Get Satisfaction
Topic: Google map multiple markers works on test and not on Android
Replies: 20
Views: 1321

Google map multiple markers works on test and not on Android

I also created a more simple test case. One input field, one button. on button click code var locations1 = []; locations1 = Apperyio('marker_location')&#46;val()&#46;split(","); alert (locations1); for (var i=0;i<locations1&#46;length;i++) { Srv_convert_address&#46;execute(...
by Takis
Tue Oct 28, 2014 7:18 am
Forum: Moved from Get Satisfaction
Topic: Google map multiple markers works on test and not on Android
Replies: 20
Views: 1321

Google map multiple markers works on test and not on Android

On Srv_convert_address service this code is executed on success code var markerLatLng = new google&#46;maps&#46;LatLng(localStorage&#46;getItem('markerLat'), localStorage&#46;getItem('markerLng')); var marker = new google&#46;maps&#46;Marker({ position: markerLatLng, map: map...
by Takis
Tue Oct 28, 2014 7:08 am
Forum: Moved from Get Satisfaction
Topic: Google map multiple markers works on test and not on Android
Replies: 20
Views: 1321

Google map multiple markers works on test and not on Android

Hi Yurii I put some alerts as you said code for (var i=0;i<locations&#46;length;i++) { alert("run convert addres"); <--------------- alert(locations );<--------------- Srv_convert_address&#46;execute({ 'data' : { 'address' : locations , 'sensor' : false } }); } /code Even on mobile...
by Takis
Mon Oct 27, 2014 8:45 pm
Forum: Moved from Get Satisfaction
Topic: Google map multiple markers works on test and not on Android
Replies: 20
Views: 1321

Google map multiple markers works on test and not on Android

The issue does not happen at the test console. Only when you install it on my Samsung Galaxy S4 Android 4.4.2 The strange thing is that the direction from to works fine and markers are displayed. The script that I run when clicking on a button is code var locations = []; var values = $('[name="...
by Takis
Mon Oct 27, 2014 3:59 pm
Forum: Moved from Get Satisfaction
Topic: Google map multiple markers works on test and not on Android
Replies: 20
Views: 1321

Google map multiple markers works on test and not on Android

Hi

I followed the tutorial
http://devcenter.appery.io/tutorials/...

and while in test all work fine, in Samsung Galaxy S4, when I click "Place marker" it does not update the map. When I click on show directions it works.

Can you help?
Thanks.

by Takis
Mon Oct 27, 2014 12:11 pm
Forum: Moved from Get Satisfaction
Topic: Grid with labels, loop to get the values
Replies: 8
Views: 573

Grid with labels, loop to get the values

I love you! Works thanks. A general suggestion, if I may. It would be good to be in documented examples how to do this with dynamically build grids that contains labels, buttons, checkboxes, etc, as I see many people use this approach. I mean how to get or set properties of objects in such cases. If...
by Takis
Mon Oct 27, 2014 8:09 am
Forum: Moved from Get Satisfaction
Topic: Grid with labels, loop to get the values
Replies: 8
Views: 573

Grid with labels, loop to get the values

Hi team I have a grid which contains only labels. I get the values of the labels from a DB service, which work fine. One of the labels in the grid contains an address. But as many records returned from DB, I get of course many address labels. The label in the grid that holds the address is called Re...
by Takis
Fri Oct 24, 2014 4:00 pm
Forum: Moved from Get Satisfaction
Topic: Read array of local storage and parse it to use it in DB query where clause
Replies: 5
Views: 570

Read array of local storage and parse it to use it in DB query where clause

-- the dot in ".map" is correct?
the comma in two first lines are correct?

I have issues with the code and I want to use it inside the mapping of the query service Image

by Takis
Fri Oct 24, 2014 11:32 am
Forum: Moved from Get Satisfaction
Topic: Read array of local storage and parse it to use it in DB query where clause
Replies: 5
Views: 570

Read array of local storage and parse it to use it in DB query where clause

Hi I have the below JS for a DB service where clause return '{"Type":"' + localStorage.getItem("lclStg_par1") + '"}'; where lclStg_par1 is a local storage parameter, where I store an array of dynamically created check boxes. If I have one value in lclStg_par1, like Food...
by Takis
Fri Oct 24, 2014 8:29 am
Forum: Moved from Get Satisfaction
Topic: Store data in Database per user
Replies: 7
Views: 734

Store data in Database per user

Hi
Can you give us an example of we can make a "silent" mobile user registration for an app ?

by Takis
Fri Oct 24, 2014 7:24 am
Forum: Moved from Get Satisfaction
Topic: Get text from dynamically created checkboxes (text is populated from database)
Replies: 14
Views: 1494

Get text from dynamically created checkboxes (text is populated from database)

Another question if I may.

How can I store these selections as the user settings/preferences ?
So the next time he opens the application the last selections are still there?

Thanks.

by Takis
Fri Oct 24, 2014 7:22 am
Forum: Moved from Get Satisfaction
Topic: Get text from dynamically created checkboxes (text is populated from database)
Replies: 14
Views: 1494

Get text from dynamically created checkboxes (text is populated from database)

Hi Evgene (=Ευγένιε means polite person) Sorry my wrong, you are right ! Also your code works ---------------------------------- var checked = Appery('chkBox_Interests') .find(':checked') .map(function() { return this.value; }).get(); localStorage.setItem("lclStg_par1", checked); ---------...
by Takis
Thu Oct 23, 2014 12:54 pm
Forum: Moved from Get Satisfaction
Topic: Get text from dynamically created checkboxes (text is populated from database)
Replies: 14
Views: 1494

Get text from dynamically created checkboxes (text is populated from database)

code
var checked = Appery('mobilecheckboxgroup_16')
&#46;find(':checked')
&#46;map(function() {
return this&#46;value;
})&#46;get();
localStorage&#46;setItem("lclStg_par1", checked);
/code

by Takis
Thu Oct 23, 2014 12:37 pm
Forum: Moved from Get Satisfaction
Topic: Get text from dynamically created checkboxes (text is populated from database)
Replies: 14
Views: 1494

Get text from dynamically created checkboxes (text is populated from database)

The one you posted, stangly does not work. Nothing is written in the label.

var checked = Appery('mobilecheckboxgroup_16')
.find(':checked')
.map(function() {
return this.value;
}).get();
localStorage.setItem("lclStg_par1", checked);

by Takis
Thu Oct 23, 2014 12:36 pm
Forum: Moved from Get Satisfaction
Topic: Get text from dynamically created checkboxes (text is populated from database)
Replies: 14
Views: 1494

Get text from dynamically created checkboxes (text is populated from database)

Code 2 - Works fine

code

var mobilecheckboxgroup = Apperyio("chkBox_Interests")&#46;find(":checked");
var arr = [];
mobilecheckboxgroup&#46;each(function(){
arr&#46;push($(this)&#46;attr("value"));

/code

by Takis
Thu Oct 23, 2014 8:58 am
Forum: Moved from Get Satisfaction
Topic: Get text from dynamically created checkboxes (text is populated from database)
Replies: 14
Views: 1494

Get text from dynamically created checkboxes (text is populated from database)

SORRY Correct Code 2 is the below Code 2--------------------------------- var mobilecheckboxgroup = Apperyio("chkBox_Interests").find(":checked"); var arr = []; mobilecheckboxgroup.each(function(){ arr.push($(this).attr("value")); }); localStorage.setItem("lclStg_p...
by Takis
Thu Oct 23, 2014 8:42 am
Forum: Moved from Get Satisfaction
Topic: Get text from dynamically created checkboxes (text is populated from database)
Replies: 14
Views: 1494

Get text from dynamically created checkboxes (text is populated from database)

Hi Katerina I have the dynamic check boxes created fine. When I put the below code in a button Code 1-------------------------------------------------- var checked = Appery('mobilecheckboxgroup_16') .find(':checked') .map(function() { return this.value; }); localStorage.setItem("lclStg_par1&quo...
by Takis
Wed Oct 22, 2014 5:10 pm
Forum: Moved from Get Satisfaction
Topic: Get text from dynamically created checkboxes (text is populated from database)
Replies: 14
Views: 1494

Get text from dynamically created checkboxes (text is populated from database)

Hi all I have check boxes created by a DB Service. The DB has a table with one column, from where I get the text that will be displayed for the check box. This works fine. Now, I have a button. When I click on the button, I want a javascript to iterate through the checked check boxes and get its tex...