View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - New model : Field Type and Quicksearch - ProjeQtOr

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

15 et 16 avril 2025 (9h-12h30)

14 et 15 mai 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

23 et 24 avril (9h-12h30)

20 et 21 mai (9h-12h30)

 

 

 

New model : Field Type and Quicksearch

More
10 Jui 2013 11:48 - 10 Jui 2013 11:59 #1 by LEVA
Hi,

I would like to point something I discovered.

If you intend to build your own new model, you should not use the type int for the number type field.
When performing a Quicksearch, Project'Or RIA first checks if the type of field in the Database is varchar and if it is not it does not include this field in the research.

My advice is to use only int when you are making a relationship with another table/model and varchar otherwise.

The problem is still there if you need a date.. I think jSonQuery should be updated.



BTW, Quicksearch does not find those link : for example, I have a model which is linked to status. If I search "Annulée" I cannot find anything.



cu
Last edit: 10 Jui 2013 11:59 by LEVA.
The topic has been locked.
More
10 Jui 2013 20:54 #2 by babynus
Hi,

Quick Search is devoted to find some string in text fields, such à name, description or result.
If you need to find items from status, you should use filters...

Also, setting field as int may be usefull, for instance to order or calculate from this field.

Babynus
Administrator of ProjeQtOr web site
The topic has been locked.
More
11 Jui 2013 08:32 #3 by LEVA
Sure int are usefull but then QuickSearch won't search on them...
I personnaly think that is not good everytime...
The topic has been locked.
Moderators: babynusprotion
Time to create page: 0.037 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.