Mittelheisser
Posts: 0
Joined: Sat Dec 27, 2014 5:59 pm

Navigate to database

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

Maryna Brodina
Posts: 0
Joined: Thu Apr 05, 2012 7:27 am

Navigate to database

Hello!

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

Mittelheisser
Posts: 0
Joined: Sat Dec 27, 2014 5:59 pm

Navigate to database

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

Yurii Orishchuk
Posts: 0
Joined: Fri Feb 14, 2014 8:20 am

Navigate to database

Hello,

It seems you need the same as described here:

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

Please pass this tutorial.

Regards.

Mittelheisser
Posts: 0
Joined: Sat Dec 27, 2014 5:59 pm

Navigate to database

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

Ihor Didevych
Posts: 0
Joined: Wed Nov 19, 2014 7:55 pm

Navigate to database

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"}

Mittelheisser
Posts: 0
Joined: Sat Dec 27, 2014 5:59 pm

Navigate to database

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

Illya Stepanov
Posts: 0
Joined: Mon Mar 18, 2013 8:48 am

Navigate to database

Hi -

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

Mittelheisser
Posts: 0
Joined: Sat Dec 27, 2014 5:59 pm

Navigate to database

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

Maryna Brodina
Posts: 0
Joined: Thu Apr 05, 2012 7:27 am

Navigate to database

Hello!

Please check are there any errors in console?

Return to “Issues”