Jump to: navigation, search

Building Searches

1,336 bytes removed, 22:55, 15 September 2013
no edit summary
==Using Prompt==__NOEDITSECTION__
When the prompt function is used in Advanced searches the re-usability and user-friendliness are greatly increased. For example, if a user wants to find all progress reports submitted by the "XYZ" organization and another user wants to have the same search but for the "ABC organisation, it better to save one search and prompt on Organisation.
==SQL criteria==__NOEDITSECTION__
{{note| We strongly recommended to develop and test the SQL query with a SQL tool before pasting it into the SQL criteria since {{IMSMANG}} does not provide SQL debugging support. }}
==Using Search ParametersSaved Searches==__NOEDITSECTION__When a search is designed, it can be given a name and description and then saved for later use. Saving a search saves the criteria of the search rather than the search results. This means that searches are automatically updated when additional data is added to the system, ensuring that searches return the most up-to-date data. For example, an information manager can build a search called “Open Lands” that finds 25 lands with a status of “Open.” If 10 additional lands are entered into the system with a status of “Open,” returning results using the search would find 35 records when it is run again. In this way, searches are dynamically updated as data is added to the system, allowing information managers to assess data trends over time using consistent search criteria. Information managers can also use an existing search as a template to create other searches by using the “Save as” functionality. Search parameters allow users to change one or more search criteria when running a search. For example, if a user wants to find all progress reports submitted by “XYZ” organisation, they can build a search for “XYZ progress reports.” If another user wants to search for progress reports submitted by “ABC” organisation, they can build another search for “ABC Progress Reports.” Alternatively, an information manager can build one search with a parameter for “Organisation” that allows users to provide different values for the organisation when running the search. This makes one search, for example, “Progress Reports by Organisation,” available for multiple purposes. The ability to build dynamic searches allows information managers to customise search capabilities to meet the needs of various stakeholders within their programmes. {{note|Searches can include geospatial data as a parameter which allows users to define a geospatial extent to search within. For the purposes of searching, records without geospatial data are defined as “outside” the geospatial extent}}   
==Description Pre-populated Saved Searches==__NOEDITSECTION__
{{IMSMANG}} version 6.0 database is pre-populated with the following data quality Saved searches:
* duplicates
* no geographical data
* no links
* different locations
* task
* mine action process quality
{{NavBox Getting started with IMSMA}}

Navigation menu