Welcome!

This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!

1

1
Carlos Nogueira
Activé 24/09/2019 14:00

Hi,

I'll try to answer all your questions, but in a simple way, hope it helps:

Reindex scripts, no matter the final DB type (SQL, ORACLE, etc), are Genio generated with information based on the project definitions (tables, fields, relations).

There will be one script file with the information on formulas to be run (usually on WebAdmin) per type of operation. You can see all of them and what they do on the reindex subfolder of your WebAdmin solution.

In that folder there is a file "order2Exec.xml" that has the information about the order that will run all that are needed, according to the selections available on the WebAdmin application site. This orderings will follow pre-determined rules by Quidgest, that will grant the formulas dependencies (+, ++, U1, CT, SR, etc...). You can check it to get all your answers cleared.

I'm not sure what you mean by your second question where it states that some fields need to be saved on the system. The only ones that i can remember now are the default values, yes, those need to be ran in the solution, because that's the way records should enter the database (in normal conditions).

Different areas in DB are all just one table (each domain), and the formula that will run on the reindex scripts should be compatible no matter the area that runs it. This is to prevent that the results are not ambiguous to the same field.

This means that the result of the formula on area A must produce same result if it would ran through area B (or no formula at all will grant that the desired result will not be overwritten with some other value).

Recent Genio versions have this analysis on the "Validations" button:


That will alert you that you where it might be formulas for the same DB field that are possibly breaking the rule.






0
Maria Guedes
Activé 25/09/2019 15:59

About the second question let me give you an example:

I changed the formula to an arithmetic like in the picture below but when I reindex the Database even with complete option or Reset calculated fields my field is still NULL - only after changing/saving each record it changes.

  • Signaler

Is there any chance that one of those fields is null when reindex is being done?

Carlos Nogueira
le 30/09/2019 09:42

Yes they star as null? Do I have to put "not null" in order to force the calculation?

Maria Guedes
le 30/09/2019 09:58

If any field of that formula is null when the formula runs, it cannot compute correctly. Thats why within the application it works because the fields will have a "default" value.

Carlos Nogueira
le 02/10/2019 16:42

It has been a while but I still have doubts on this subject.

The thing is that even if I transform all fields in empty, when I reindex it doesn't calculate the field.

Only when I open the specific form it does calculate. Can you help me to force the calculation

Maria Guedes
le 28/01/2020 12:45

Keep Informed

About the Community

This platform is for beginners and experts willing to share their Genio knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers. Read Guidelines

Question tools

9 follower(s)

Stats

Asked: 23/09/2019 18:45
Seen: 1799 times
Last updated: 28/01/2020 14:17