LSCS returning only max=50 records (296 Views)
Reply
Highlighted
N/A
Posts: 25
Registered: ‎08-26-2014
Accepted Solution

LSCS returning only max=50 records

we are populating a dropdown in teamsite Datacapture.cfg from LSCS using a Java Service inline call and getting the only the first 50 items from the 77 present in the lscs store,  running the query on the browser returns all 77 records. 

The java service is running the query returning a max value = 1000. 

 

something is overwriting the Java service when returning the records to fill the dropdown.

 

=================

datacapture.cfg code

=================

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE data-capture-requirements SYSTEM "datacapture6.0.dtd">

<data-capture-requirements name="service">
<ruleset name="service">
<description>Service Template</description>


<root-container name="service" location="service">

<item name="organization" pathid="organization" rowcontinue="t">
<label>Organization</label>
<select required="t">
<inline command='Datasource:executeComponent:MdcDCTDatasource:Type=organization:Field.1=county:Value.1=dadeSmiley Tongueroject=dade:FieldValidation=0' />
</select>
</item>

<item name="subOrganization" pathid="subOrganization">
<label>Sub-Organization</label>
<select required="f"></select>
</item>

 

==================================================================================

Query getting logged on server.log

==================================================================================

 

http://localhost:8080/lscs/v1/document/$?q=%28TeamSite%2FMetadata%2Fcounty%3Adade%29+AND+%28TeamSite%2FTemplating%2FDCR%2FType%3A%3D%22data-types%2Forganization%22%29&sort=%2BTeamSite%2FMetadata%2Fname&start=0&max=50&project=//s1234567/BETA/main/dade&context=//s1234567/BETA/main/dade/WORKAREA/wa1&format=json

 

 

N/A
Posts: 25
Registered: ‎08-26-2014

Re: LSCS returning only max=50 records

when running a simple query i get only 50, anyone know how / where to change the default lscs value from 50?

 

http://s01234567.dade.com:8080/lscs/v1/document/$TeamSite/Metadata/Name,TeamSite/Metadata/MDUniqueId...

 

Results:

 

results xsi:schemaLocation="http://www.interwoven.com/schema/iwrr iwrr.xsd" total="50" included="50" start="0" status="200">

N/A
Posts: 11,194
Registered: ‎08-19-2002

Re: LSCS returning only max=50 records

[ Edited ]
.../LiveSiteCSRT/runtime/webapps/lscs/WEB-INF/classes/lscs-conf.properties
paginationAbsoluteMax=500
Andy Knipp

If it solves your problem, mark it as the solution.
N/A
Posts: 25
Registered: ‎08-26-2014

Re: LSCS returning only max=50 records

Hello Nipper,

i have that as 500 already, this is the whole API entry, but i see that the project name is different

 

#API Settings
maxURILength=1000
paginationMax=10
paginationAbsoluteMax=500
defaultResponseFormat=xml
date.format=MM/dd/yyyy
allowHTTPMethodTunneling=true
cleanupAfterImport=true
defaultProjectName=/default/main

N/A
Posts: 11,194
Registered: ‎08-19-2002

Re: LSCS returning only max=50 records

[ Edited ]

 

 

Are you certain there are more that 50 valid for your query ? 

 

Try this one

 

http://s01234567.dade.com:8080/lscs/v1/document/?q=*&project=//s01234567/BETA/main/dade&format=xml

 

How do you mean the project name is different ? 

 

What does 

 

http://s01234567.dade.com:8080/lscs/v1/projects 

 

return

 

Andy Knipp

If it solves your problem, mark it as the solution.
N/A
Posts: 25
Registered: ‎08-26-2014

Re: LSCS returning only max=50 records

it is weird, i get no projects found, but i do have and running the above query works.

 

<results total="0" included="0" start="0" status="404">
<error>No such resource: /lscs/v1/projects</error>
</results>
N/A
Posts: 11,194
Registered: ‎08-19-2002

Re: LSCS returning only max=50 records

 

 

OK I assume this is LSCSAT,  maybe it doesn't return a list of projects. 

 

the main question is that, are you certain there are more tham 50 objects in this query.  Much easier to test on the runtime,  I do not use LSCSAT all too often.  

Andy Knipp

If it solves your problem, mark it as the solution.
N/A
Posts: 25
Registered: ‎08-26-2014

Re: LSCS returning only max=50 records

we have teamsite and livesite authoring in one server  and LSCS node in another server where content gets deploy, running query to get number of project there returns values:

 

http://s01234567.dade.com:8080/lscs/v1/projects

 

<?xml version="1.0" encoding="UTF-8"?>
-<projects xsi:schemaLocation="http://www.interwoven.com/schema/iwrr iwrr.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.interwoven.com/schema/iwrr"><project name="//01234567/migr/main/component-guide" id="//01234567/migr/main/component-guide"/><project name="//01234567/BETA/main/mdcTeamSiteExtensionsTestData" id="//01234567/BETA/main/mdcTeamSiteExtensionsTestData"/><project name="//01234567/iwadmin/main/livesite/template" id="//01234567/iwadmin/main/livesite/template"/><project name="//01234567/BETA/main/dade" id="//01234567/BETA/main/dade"/><project name="//01234567/iwadmin/main/livesite/component" id="//01234567/iwadmin/main/livesite/component"/></projects>

N/A
Posts: 11,194
Registered: ‎08-19-2002

Re: LSCS returning only max=50 records

OK,  run your query on the LSCS runtime.  How many are returned ? 

 

If only 50, then run an open ended query (like the one I posted before) 

 

 

Also,  I didn't see but are you using max in the URL ? Even if you use max=20000 it will only return 500 which is your max-max.  :-)

Andy Knipp

If it solves your problem, mark it as the solution.
N/A
Posts: 25
Registered: ‎08-26-2014

Re: LSCS returning only max=50 records

the query on runtime returns 50 with or without max value:

 

http://s0144261:1876/lscs/v1/document/$TeamSite/Metadata/Name,TeamSite/Metadata/MDUniqueId?q=TeamSite/Templating/DCR/Type:=data-types/organization&project=//s01234567/BETA/main/dade&format=xml&start=0&max=1000