cancel
Showing results for 
Search instead for 
Did you mean: 

SPML searchrequest doesn't returns any values on query using lastmodifydate

Former Member
0 Kudos

Hi,

I'm searching list of users who are modified by lastmodifydate using SPML.

I've genrated the below request through SPML 1.0 and the below request is executing without any error but not returning any values:

Request

-


<spml:searchRequest xmlns:spml='urn:oasis:names:tc:SPML:1:0' xmlns:dsml='urn:oasis:names:tc:DSML:2:0:core'>

<spml:searchBase type='urn:oasis:names:tc:SPML:1:0#GUID'>

<spml:id>sapuser</spml:id>

</spml:searchBase>

<dsml:filter>

<dsml:and>

<dsml:equalityMatch name='datasource'>

<dsml:value>DATASOURCE_NAME</dsml:value>

</dsml:equalityMatch>

<dsml:greaterOrEqual name='lastmodifydate'>

<dsml:value>20111031000000Z</dsml:value>

</dsml:greaterOrEqual>

</dsml:and>

</dsml:filter>

<spml:attributes>

<dsml:attribute name='lastname'/>

<dsml:attribute name='firstname'/>

</spml:attributes>

</spml:searchRequest>

Response

-


<?xml version="1.0" encoding="UTF-8"?>

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">

<SOAP-ENV:Header/>

<SOAP-ENV:Body>

<searchResponse result="urn:oasis:names:tc:SPML:1:0#success"/>

</SOAP-ENV:Body>

</SOAP-ENV:Envelope>

Note: I made changes in both UME and backend db.

Please help me to figure out this issue. If you have any sample searchrequest to fetch user based on lastmodifydate, please post it.

Regards,

Chellappan S

Accepted Solutions (0)

Answers (1)

Answers (1)

stefan_grube
Active Contributor
0 Kudos

I have no idea, what you are talking about, but it seems you are searching for changes in the future:

> <dsml:greaterOrEqual name='lastmodifydate'>

> <dsml:value>20111031000000Z</dsml:value>

lastmodifydate >= 31.10.2011

Former Member
0 Kudos

Hi Stefan,

I have generated the above spml request through spml toolkit.

My requirement is, i've to get list of users who are modified by given date. So, i've generated a request who are modified by Jan 27, 2011 but it doesnt returns any value eventhough there was 10 users details updated through in ABAP and UME.

Regards,

Chellappan S

Former Member
0 Kudos

Hi Sampath

Are you able to resolve this issue? I am facing the same issue(not fetching the data) for following search request. Here i am trying to get all users modified after date 20120506062034Z

<?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><spml:searchRequest xmlns:spml="urn:oasis:names:tc:SPML:1:0" xmlns:dsml="urn:oasis:names:tc:DSML:2:0:core">

<spml:searchBase type="urn:oasis:names:tc:SPML:1:0#GenericString"><spml:id>sapuser</spml:id></spml:searchBase>

          <dsml:filter>

                    <dsml:and>

                              <dsml:present name="logonname"><dsml:value>*</dsml:value></dsml:present>

                              <dsml:greaterOrEqual name="lastmodifydate">                

                        <dsml:value>20120506062034Z</dsml:value>

             </dsml:greaterOrEqual>

                    </dsml:and>

          </dsml:filter>

</spml:searchRequest></soapenv:Body></soapenv:Envelope>

Your help is greatly appreciated

Thanks,

Srinu