SDL Trados Studio
SDL Trados GroupShare
SDL Trados Business Manager
SDL Trados Live
SDL MultiTerm
SDL Passolo
SDL Speech to Text
SDL Managed Translation - Enterprise
SDL MultiTrans
SDL TMS
SDL WorldServer
Translation Management Connectors
SDL LiveContent S1000D
SDL Contenta S1000D
SDL XPP
SDL Tridion Docs
SDL Tridion Sites
SDL Content Assistant
SDL Machine Translation Cloud
SDL Machine Translation Connectors
SDL Machine Translation Edge
Language Developers
Tridion Developers
Tridion Docs Developers
Xopus Developers
Community Help
SDL User Experience
Language Products - GCS Internal Community
SDL Community Internal Group
SDL Access Customer Portal
SDL Professional Services
SDL Training & Certification
Style Guides
Language Technology Partner Group
SDL Academic Partners
SDL Approved Trainers
SDL Enterprise Technology Partners
XyUser Group
ETUG (European Trados User Group) Public Information
Machine Translation User Group
Nordic SDL Tridion Docs User Group
SDL Tridion UK Meetup
SDL Tridion User Group New England
SDL Tridion West Coast User Group
SDL WorldServer User Group
Tridion Docs Europe & APAC User Group
Tridion User Group Benelux
Tridion User Group Ohio Valley
SDL MultiTerm Ideas
SDL Passolo Ideas
SDL Trados GroupShare Ideas
SDL Trados Studio Ideas
SDL Machine Translation Cloud Ideas
SDL Machine Translation Edge Ideas
SDL Language Cloud TMS Ideas
SDL Language Cloud Terminology Ideas
SDL Language Cloud Online Editor Ideas
SDL Managed Translation - Enterprise Ideas
SDL TMS Ideas
SDL WorldServer Ideas
SDL Tridion Docs Ideas
SDL Tridion Sites Ideas
SDL LiveContent S1000D Ideas
SDL XPP Ideas
Events & Webinars
To SDL Documentation
To SDL Support
What's New in SDL
Detecting language please wait for.......
I'm trying to harness the power of Freeform SQL on the WorldServer, but I can't get the query right.Is there any documentation available for this?The only SDL source I've found so far is this post:https://gateway.sdl.com/apex/communityknowledge?articleName=000011827
This helps, but it only lists some very basic portion of the syntax. I'm looking for something more complete.
To be concrete: How do I search on a date range?I've tried a lot of variations of this code, but to no avail:
[Created on] > '2020-01-01'
Thanks for any suggestions.
You can find the info in the WorldServer Online Help, under "Using Translation Memories and Terminology Databases" > "Translation Memories" > "Individual Translation Memory Page" > "Searching for TM Entries…
We have someone in our organization that works with this quite often. He gave the response below to address your issue. I do not know where he got the information though.
Use:
[Created On] > {1/1/2020…
Thank you Eric and Ryan for your extremely helpful responses. Based on your feedback, I have taken several actions:
1- I have submitted a Jira ticket for our development team asking them to review our…
[Created On] > {1/1/2020}
You have to put the date in curly braces for WS to recognize that it’s a date and treat it accordingly.
The individual was Ryan Lee btw.
You can find the info in the WorldServer Online Help, under "Using Translation Memories and Terminology Databases" > "Translation Memories" > "Individual Translation Memory Page" > "Searching for TM Entries" > "The procedure for searching for TM entries" > point #4:
"4. If you chose the Freeform SQL search mode, type your query (see rules and samples below) and click the Search button () to perform the search.
Freeform SQL queries have the following rules:
I don't know if this is documented anywhere in the API documentation, but in my opinion it REALLY should be.
1- I have submitted a Jira ticket for our development team asking them to review our online documentation (SDL Documentation center) and include information about Freeform SQL.
2- I have enhanced article https://gateway.sdl.com/apex/communityknowledge?articleName=000011827 to include the information from the Online Help as pointed out by Ryan.
3- I have created a new article about Arjan's question and Ryan and Eric's answer: https://gateway.sdl.com/apex/communityknowledge?articleName=000013006
4- Both articles link to each other. I hope your customers can now find the information they need about Freeform SQL.
Thanks again for your precious input.
Thanks! This worked. Splendid.
Thanks! I have found the entry in the help section. Not at the exact same location, but by searching for "Freeform SQL". The data there will keep me busy for a while. Going to integrate it in an Autohotkey script.