C’est une base POSTGRESQL.
J’ai un résultat si je saisis ‘IRN-XXXXX’ ou ‘-XXXXX’ et rien si je saisis seulement ‘XXXXX’.
La requête générée avec ‘XXXXX’ est la suivante
SELECT idx_ukey, idx_object, idx_row_id, idx_ukey, idx_all, CAST(to_tsvector('simple',idx_ukey) @@ to_tsquery('60347:*') as integer)*10 + CAST(to_tsvector('simple',idx_all) @@ to_tsquery('60347:*') as integer) as score FROM m_index WHERE (to_tsvector('simple',idx_ukey) @@ to_tsquery('60347:*') or to_tsvector('simple',idx_all) @@ to_tsquery('60347:*')) AND idx_object IN ('Action','Adapter','Agenda','BPMActivity','BPMAlert','BPMAlertContent','BPMData','BPMHelp','BPMProcess','BPMRecipient','BPMState','BPMStateTransition','ConstraintObject','CronTable','Crosstab','DataMap','Disposition','DocIndex','DocIndexField','DocMIME','DocumentSystem','Domain','Field','FieldList','FieldListValue','FieldStyle','Function','Group','ISOCountry','ISOCtyGrp','Link','ListOfValue','Map','ModelTemplate','Module','ObjectCtxHelp','ObjectExternal','ObjectFieldArea','ObjectFieldSystem','ObjectInternal','ObjectSystem','PlaceMap','PrintTemplate','Profile','RciAppDomain','RciApplication','RciApplicationType','RciBceDomain','RciData','RciDbms','RciDomain','RciFlowModality','RciFunctDomain','RciLDAP','RciMacroprocess','RciNetworking','RciProvider','RciResponsibleEntity','RciRetentionTime','RciSecurityAuth','RciSecurityPolicy','RciSecurityProtocol','RciStorageType','RciSubsidiary','RciTag','RciTransmissionType','RciUser','Research','Resource','Responsability','Script','ShortCut','SystemParam','Template','Theme','TranslateAction','TranslateActivity','TranslateCrosstab','TranslateDocIndex','TranslateDomain','TranslateExternal','TranslateField','TranslateFieldArea','TranslateFieldType','TranslateGroup','TranslateObject','TranslateObjectField','TranslateProcess','TranslateResearch','TranslateShortcut','TranslateTreeView','TranslateView','TreeView','User','View') ORDER BY score desc, idx_ukey LIMIT 50 OFFSET 0 Hosts=