search

pnp / graph-connectors-samples

Microsoft Graph Connector samples
https://aka.ms/gc/samples
MIT License
47 stars 35 forks source link

Order results not working... #35

Closed gretchunkim closed 11 months ago

gretchunkim commented 11 months ago

I can't order/sort the result (highlighted issue in the snapshot, 2 showing first then 1) using the MS SQL Connector despite of being defined in SQL query to do so. I have not tried custom built connector at this time, but I do see that from screenshots that the results are in random in its display pattern.

I'll appreciate any tips to overcome the issue. image

Thanks,

waldekmastykarz commented 11 months ago

Hey @gretchunkim, is this related to any of the samples in this repo?

That said, the results you're seeing are based on search, not on the SQL query that you're using for ingesting content. This means, that the order of results will be determined by their relevance for your search query rather than one of the properties. If you'd like to use a custom order, then it would have to be a part of your query.

gretchunkim commented 11 months ago

@waldekmastykarz
This is regarding all Graph Connectors, regardless of samples. I can provide another sample example ,here:

How can we override or modify relevance of search query modified without being as a pat of query?

Expect: Since Ipad is in query, then show Ipad (1st result), then show other items order by number in asc order.

image

waldekmastykarz commented 11 months ago

Thanks for clarifying. Issues in this repo are meant only for issues and questions about the samples in this repo, not generic connectors functionality. For generic questions, please post them on support forums such as Microsoft Q&A, Stack Overflow or on social.

gretchunkim commented 11 months ago

Okay. I'll go ahead and do that. Thanks