You are here: Reference Guide > Table Structures > System > SY_SearchQueries

SY_SearchQueries

Purpose    

Records the query SQL statements for the various search options in each search window attached to each form

Name

Type

Linked To/Supplied

SearchQueryID char (36)

 

SearchTypeID char (36)

 

Name varchar (255)

 

FromString varchar (2000)  
WhereString varchar (1000)  
OrderByString varchar (1000)  
GroupByString varchar (1000)  
DisplayOrder int  

Copyright © 2012 Jiwa Financials. All rights reserved.