Page 1 of 1

Navigate to database

Posted: Tue Jan 13, 2015 11:16 pm
by Mittelheisser

Bonjour,

Je suis débutant dans les applications et avec javascript.

J'ai créé une application selon le tutoriel "http://devcenter.appery.io/tutorials/...".
Elle fonctionne parfaitement.

Dans cette application, j'ai rajouté un panel sur la page avec une liste non relié à la base de donnée. j'aimerai pouvoir naviguer vers la pages avec cette liste.

Par exemple, j'ai une base de donnée avec deux colonnes. La première colonne contient un texte simple comme A, B, C, D, E. Dans le panel de ma page, j'ai la liste A, B, C, D.... Donc quel est le code qui me permet d'afficher la page E quand je clic sur la liste E ?

J'espère que je suis assez clair et désolé pour mon anglais.

Merci d'avance

Cordialement


Navigate to database

Posted: Wed Jan 14, 2015 1:49 pm
by Maryna Brodina

Hello!

I am sorry, could you please repeat your question in English?


Navigate to database

Posted: Wed Jan 14, 2015 7:23 pm
by Mittelheisser

Hello,

I AM SORRY ...:-)

I am a beginner in applications and javascript.

I created an application according to the tutorial "http: //devcenter.appery.io/tutorials / ...".
It works perfectly.

In this application, I added a panel on the page with a list not connected to the database. I wish I could navigate to pages that list.

For example, I have a database with two columns. The first column contains a single text as A, B, C, D, E. In panel of my page, I list A, B, C, D .... So what is the code that allows me to 'I view the page when I click on the E list?

I hope I am clear enough and sorry for my English.

Thank you in advance

Best Regards


Navigate to database

Posted: Thu Jan 15, 2015 4:06 am
by Yurii Orishchuk

Hello,

It seems you need the same as described here:

http://devcenter.appery.io/tutorials/...

Please pass this tutorial.

Regards.


Navigate to database

Posted: Thu Jan 15, 2015 9:48 am
by Mittelheisser

Hello,

I've watched this tutorial, I'm not in the same situation.

I do not have a clickable list from the database. I created a list without relationship, I would have to find a function - javascript - that allows me to display the data I want from a list or an unrelated button.

I tried with the following javascript function:
localStorage.setItem ("Article", "CO01");
get_prverp.execute ({});

"Article" is the column name, "CO01" data into the column.
It does not work.

What works for now is:
localStorage.setItem ('skip', 5);
get_prverp.execute ({});

and I change skip number (5, 6, 7...345..;)

Regards


Navigate to database

Posted: Fri Jan 16, 2015 7:38 pm
by Ihor Didevych

Hello,

1) Your get_prverp service should be query service
2) There should be "where" parameter
3) Please open your service test tab and update "where" parameter {"Article": "CO01"}

You should have right result.
Then you can add this service to the page, but don't forget that your parameter should be formed like: {"COLL_NAME": "SERACHING_VALUE"}


Navigate to database

Posted: Fri Jan 16, 2015 11:30 pm
by Mittelheisser

Hello,

Thank you for your reply, it changes the answers ... tutorial solutions.

I added the setting "where"
The result is good with {"article", "CO01"}

But how do I add the service in my page? I added to my list of javascript, but I have no result.
code:
localStorage.setItem ('where', {"Article": "CO01"});
get_prverp.execute ({});

thank you

Best Regards


Navigate to database

Posted: Sat Jan 17, 2015 7:46 am
by Illya Stepanov

Hi -

You will need to pass parameters to your service like shown here: http://devcenter.appery.io/documentat...


Navigate to database

Posted: Mon Jan 19, 2015 9:17 am
by Mittelheisser

Hello,

I managed to add the function and I have a good result.

But the final function is not good:

My application is an "app with data pagination" (http://devcenter.appery.io/tutorials/...)
I have two problems:

  1. link only works if I'm on the first page. If I navigate to the pages, if I'm on page 3 of the pagination and I click on my link, the page is blank.

  2. If I call on page 3 of my pagination from the button and I click the next button, it shows on page 2.

    Any idea?

    thank you

    Best Regards


Navigate to database

Posted: Mon Jan 19, 2015 12:14 pm
by Maryna Brodina

Hello!

Please check are there any errors in console?