Welcome!
This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!
How to filter an Order Field?
I'm creating a simple application to generate reference numbers for letters to be sent.
Each letter will have a reference and at moment it is working very well, however, the reference must generate an order for each company, and it is working by insertion order, regardless of company, since each company must generate this order separately.
Example:
At the moment it looks like this:
company-X-order001
emprasa-Y-order002
company-Z-order003
company-X-order004
It should be like:
company-X-order001
emprasa-Y-order001
company-Z-order001
company-X-order002
Tables:
My order Field:
The application:
You could use the pattern Prefix to be Unique. This pattern will create a identifier unique according the Prefix to be unique field.
If you have a sequential number in a child table, you could use the same number according to the father table.
In my example I have a Subject with different topics. Each topic has a number, but i want my topic has a unique number in each subject, so:
Subject 1
Topic 1
Topic 2
Topic 3
Subject 2
Topic 1
Topic 2
Topic 3
In your case, you could apply to the ORDER field the Unique Constraint, as well the CODEMPRE in the Prefix to be unique field.
Keep Informed
About the Community
Question tools
Stats
| Asked: 29/10/2022 19:11 |
| Seen: 1018 times |
| Last updated: 02/11/2022 15:14 |
It works...
Thank you, Sónia :)