Is there a FieldFullTextSearchPredicate equivalent of SQL's freetext(*, 'MySearchString'), which searches across all the fields in a table's full text index?

Thanks. J.

You can take the FieldFullTextSearchPredicate sourcecode and create your own class and use it in your queries. Initially the fulltextsearch predicate searches on a field, as that's its purpose.

Full text search the way you want with ranking etc. isn't supported at the moment.

Any progress on this issue ? Is ranking now supported ?

Ranking isn't supported indeed. This is because the set returned by the select with the filter has to be used as a join to be sure ranking data is returned, and that construction isn't supported by llblgen pro.

Any progress on this issue ? Is ranking supported in 2.0?

hootie wrote:

Any progress on this issue ? Is ranking supported in 2.0?

No, sorry, ranking isn't supported.

any idea how to search and display result? This is my current code. I´m a newbe in LLBL so any help or idea would be great!

For Each field In user.Fields
                selectFilter.AddWithOr(New FieldFullTextSearchPredicate(field, FullTextSearchOperator.Freetext, find))
        Next
currentCustomer.User.MaxNumberOfItemsToReturn = 50
GridView1.DataSource = currentCustomer.GetMultiUser(True, selectFilter)
GridView1.DataBind()

if my search phrase are "<name> <company>"

I get two users as result. the first one is the one who match <company> the second one is the one who matches both <name> and <company>. I´d like to have them sorted on best hit score....

I guess that would be Ranking which is not supported.

A work around is to have your query in a database view, with a column for the Rank. And then map this query to an entity or a TypedView in LLBLGen Pro.

Walaa wrote:

I guess that would be Ranking which is not supported.

100% correct . The problem with the ranking is that it's fed back to the resultset, however it's cumbersome to make it usable as a field in the resultset or a way to sort on it, as no field is mapped onto the rank field in the resultset.

Thank you. I´ll try to make a view out of it.

Any move on this ranking support? or will it never be supported due to reasons mentioned?

Thanks, Matt

bentos wrote:

Any move on this ranking support? or will it never be supported due to reasons mentioned?

Thanks, Matt

v2.6 adds derived tables, which was one of the things which are required to get this working, so with derived tables this should be possible I think, though I've never tested it. As said: for entities etc., it's not really possible as the ranking field isn't in the resultset.