CA Service Management

Hi,

I'm very new to CA SDM api.

I'm trying to search for requests irrespective of status(open, closed...).

If I do an interactive search I get a screen that looks like:

I want to search using a url  using fields equivalent to on the screen of "Summary" and "Description".

I think the url would look like:

https://mysite/CAisd/pdmweb.exe?OP=SEARCH+FACTORY=cr+QBE.IN. summary=%finance%

but this does not work as "summary" is the wrong name for the attribute.

Is the wildcard for search a percent sign(%)?

What is the equivalent of of on screen fields "Summary" and "Description" for a url?

Is there a table with all the attributes? I've tried to search for a full list but google does not come up with anything useful.

HI Phillip,

I dont believe you can pass those two fields in the URL.  The query is generated based on the values entered into the search filter - which is then sent to the domsrvr to forumlate the query and send it to the virtdb process to go ahead and run that query against SQL.  Can you give us a better idea of what you are looking to from a bigger picture standpoint?  What is the requirement or goal that needs to be attained, and for what purpose?  This way I can better help you get what you need.  We do have a true API using webservices - both REST and SOAP api's are available in the product.  You can write custom web services apps to perform certain searches or queries.  

For the URL piece - check out this post:  CA SDM::. Where can I find SDM operations documentation using link/URL? Everthing do you need know. 

It will give you some info about using URLs directly, but note that its not the best way to utilize the prodcut as there are limitations on it.

Thanks,
Jon I.

Hi,

you need to escape % sign to URI standard: %25, try this one:

http://casdm/CAisd/pdmweb.exe?OP=SEARCH+FACTORY=cr+QBE.IN.summary=%25test%25

But I agree with Jon, searching over text fields not an optimal way to achieve the goals

Regards,

cdtj

Thanks to all.

With the REST %25 works as the wildcard character.

I found that "summary" should be "Summary" and the full url is:

https://mysite/CAisd/pdmweb.exe?OP=SEARCH+FACTORY=cr+QBE.IN.Summary=%25mytext%25

Jon l. reference has some good examples but is not a "full" list of all search fields.