Forum

New model : Field T...
 
Notifications
Retirer tout

New model : Field Type and Quicksearch

3 Posts
2 Utilisateurs
0 Reactions
6,689 Vu
LEVA
 LEVA
(@leva)
Posts: 54
Trusted Member
Début du sujet
 
[#1201]

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


 
Posté : 10/06/2013 1:48 pm
(@babynus)
Posts: 14952
Membre Admin
 

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.


 
Posté : 10/06/2013 10:54 pm
LEVA
 LEVA
(@leva)
Posts: 54
Trusted Member
Début du sujet
 

Sure int are usefull but then QuickSearch won't search on them...
I personnaly think that is not good everytime...


 
Posté : 11/06/2013 10:32 am
Share:
Retour en haut