Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

New model : Field T...
 
Notifications
Clear all

New model : Field Type and Quicksearch

3 Posts
2 Users
0 Reactions
6,723 Views
LEVA
 LEVA
(@leva)
Posts: 54
Active Member
Topic starter
 
[#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


 
Posted : 10 Jun 2013 13H48
babynus
(@babynus)
Posts: 14966
Main Contributor 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.


 
Posted : 10 Jun 2013 22H54
LEVA
 LEVA
(@leva)
Posts: 54
Active Member
Topic starter
 

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


 
Posted : 11 Jun 2013 10H32
Share:

Scroll to Top