Date validation along with year in LSCS
is there any particular format for date validation in LSCS queries? We have a below query in which year validation is not happening. If we update day and month, results are updating. But if we change year, results are not updating.
http://server name/lscs context name/v1/document$?format=xml&q=((TeamSite/Templating/DCR/Type:CategoryArticle/Articles)AND(categoryType:Experiences)AND(isFeatured:Yes)AND(displayDate:<12-09-2014))
0
Comments
-
All LSCS fields are String format by default, so here you're doing a string comparison, not a date comparison.
You can make them date fields via FieldMappings.xml, but the easier solution is to use a format that actually sorts as strings properly (i.e. yyyy-MM-dd).
0
Categories
- All Categories
- 108 Developer Announcements
- 53 Articles
- 106 General Questions
- 145 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 899 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 120 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
TeamSite Developer Resources
If you are interested in gaining full access to the content, you can register for a My Support account here.
- Docker Automation
- LiveSite Content Services (LSCS) REST API
- Single Page Application (SPA) Modules
- TeamSite Add-ons
If you are interested in gaining full access to the content, you can register for a My Support account here.