How to search/search limitations
Hi All.
I'm having some issues in searching for the records that I want in RAM 7.5.0.2.
We have the following (custom) Asset type that represents an Environment, examples of the name are:
ENV SYT-WEB
ENV SIT-WEB
ENV UAT-WEB
ENV UAT-WEB2
ENV PRD-WEB
All environment records start with ENV. Then we have region, and then platform (WEB or WEB2 (for a second stream of web)).
I am having issues with search for all of the ENV WEB records.
Ideally, I'd expect a search of:
"ENV*WEB*"
to work.
However, that's not what I'm seeing.
"ENV*" does not work, as it also returns other records that reference or are related to the ENV records.
"name:(ENV)" at least returns all of the records starting with ENV, but it also returns the non-web ones as well.
"name:(ENV) && name:(WEB)" does not return all of the ENV WEB records, and it too, also returns records that reference ENV records, not just those that start with ENV.
So, how is the search envisaged to work?
Or, put another way, what is the equivalent of "ENV*WEB*"?
Also, it seems to only display the first 25 records only.
How do i tell it to return all records, irrespective of the number? I am happy for it to keep going down the page for as long as it needs too.
-Chris
I'm having some issues in searching for the records that I want in RAM 7.5.0.2.
We have the following (custom) Asset type that represents an Environment, examples of the name are:
ENV SYT-WEB
ENV SIT-WEB
ENV UAT-WEB
ENV UAT-WEB2
ENV PRD-WEB
All environment records start with ENV. Then we have region, and then platform (WEB or WEB2 (for a second stream of web)).
I am having issues with search for all of the ENV WEB records.
Ideally, I'd expect a search of:
"ENV*WEB*"
to work.
However, that's not what I'm seeing.
"ENV*" does not work, as it also returns other records that reference or are related to the ENV records.
"name:(ENV)" at least returns all of the records starting with ENV, but it also returns the non-web ones as well.
"name:(ENV) && name:(WEB)" does not return all of the ENV WEB records, and it too, also returns records that reference ENV records, not just those that start with ENV.
So, how is the search envisaged to work?
Or, put another way, what is the equivalent of "ENV*WEB*"?
Also, it seems to only display the first 25 records only.
How do i tell it to return all records, irrespective of the number? I am happy for it to keep going down the page for as long as it needs too.
-Chris
2 answers
If they're asset types and not asset names, try
type:(env) type:(web)
You could also build up an OR query such as
type:("env sit-web") || type:("env syt-web")
Each page in the web has a limit of 25 results before you have to click next. Using the API or eclipse client you can fetch more results (up to 1000) with a single request.
type:(env) type:(web)
You could also build up an OR query such as
type:("env sit-web") || type:("env syt-web")
Each page in the web has a limit of 25 results before you have to click next. Using the API or eclipse client you can fetch more results (up to 1000) with a single request.
Not quite.
The type of of the record/asset is Environment, and the WEB or SIT/UAT etc are simply names of Environment asset records.
So:
type:(Environment) *WEB*
is what gave me the environment types that I required.
Thanks for the tip!
-Chris
The type of of the record/asset is Environment, and the WEB or SIT/UAT etc are simply names of Environment asset records.
So:
type:(Environment) *WEB*
is what gave me the environment types that I required.
Thanks for the tip!
-Chris
If they're asset types and not asset names, try
type:(env) type:(web)
You could also build up an OR query such as
type:("env sit-web") || type:("env syt-web")
Each page in the web has a limit of 25 results before you have to click next. Using the API or eclipse client you can fetch more results (up to 1000) with a single request.