Is it possible to search tickets with ticket number on Portal home search.?

Mad3
Tera Expert

Hello community!

 

Requirement is to search for the tickets, catalog items, and record producers and tickets with short description on portal home search.

If possible give an example to make it possible to search for items.

 

Thanks in advance!

 

2 ACCEPTED SOLUTIONS

SatyakiBose
Mega Sage

Hello @Mad3 

To do this, you need to:

  1. Navigate to the sp_portal table, and the specific portal.
  2. Scroll down to the Search Sources related list, and click on new.
    SatyakiBose_1-1678339603782.png
  3. You need to configure a new source, example - incident. The config can look like the one below. You can add scripted search as well to refine the results.
    SatyakiBose_0-1678339581151.png
  4. Now if you search on portal with incident numbers, it will give the desired results.
    SatyakiBose_2-1678339659308.png
  5. Similarly, you can configure other tables as well to show the desirde results.

View solution in original post

@Mad3 

You can use the OOB portal or a custom portal. The search does not depend on which portal you are using.

The load time cannot be reduced.

Performing a search depends on multiple factors:

  • size of the table
  • is the table indexed
  • is there a scripted search added in the search source
  • any business rule or acls running in the backend.

View solution in original post

4 REPLIES 4

SatyakiBose
Mega Sage

Hello @Mad3 

To do this, you need to:

  1. Navigate to the sp_portal table, and the specific portal.
  2. Scroll down to the Search Sources related list, and click on new.
    SatyakiBose_1-1678339603782.png
  3. You need to configure a new source, example - incident. The config can look like the one below. You can add scripted search as well to refine the results.
    SatyakiBose_0-1678339581151.png
  4. Now if you search on portal with incident numbers, it will give the desired results.
    SatyakiBose_2-1678339659308.png
  5. Similarly, you can configure other tables as well to show the desirde results.

Hello @SatyakiBose ,

Thanks for the reply!

 

Created custom Portal.

1. I can add incident table in search sources and able to search with number and short description.

2. The same thing done for catalo items, added sc_cat_item table in search sources, cursor is loading and not             abale to find catalog items with name. still loading.

   And also let me know how to reduce the timing for the search item on home search.search_cat_item.png

@Mad3 

You can use the OOB portal or a custom portal. The search does not depend on which portal you are using.

The load time cannot be reduced.

Performing a search depends on multiple factors:

  • size of the table
  • is the table indexed
  • is there a scripted search added in the search source
  • any business rule or acls running in the backend.

@SatyakiBose ,

I am able to search incidents, cat items even with short description.

Thank you.