Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Search Stored Procedure

web-app

What stored procedure is used to do text searching of issues?  I need to customize it to include some searching of custom fields.

jedgett
· 1
jedgett
Replies (7)
helpful
0
not helpful

Gemini is using Nhibernate for data access therefore there is no stored procedure for this.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

So, is there a way to modify the search method?  Or is all of this contained within a compiled library?


jedgett
· 1
jedgett
helpful
0
not helpful

It is all compiled. What are you trying to do?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

We have a custom lookup table or two that are tied to custom fields. 

For the purposes of this example lets say one of the dropdowns is a list of types of Apples.  As an issue editor I can specify the kind of apple that is tied to the specific issue. 

Now, when I type Red Delicious in the search box I want it to return records that have Red Delicious selected in that custom field.


jedgett
· 1
jedgett
helpful
0
not helpful

I see. The keyword search does search within custom fields as well, but I suppose you'd like searching only custom fields.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Hmmm, doesn't seem to be on ours but maybe because we are using a lookup table?


jedgett
· 1
jedgett
helpful
0
not helpful

Yes, you will have to enter the ids...

Please add this to our list: http://gemini.countersoft.com

 


Saar Cohen
· 5000
Saar Cohen