This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi Again, How may utilize server side query functions like CONCAT, LEN, UPPER, etc. As always thank you, Kavan |
|
|
Hi Kavan, You cannot directly do this with LightSpeed at this stage. You can, however, utilize the underlying connection to execute custom queries as desired but these will not return LightSpeed entities. John-Daniel Trask |
|
|
Hi Kavan, You can't currently use these server side functions. We currently have a backlog item for a find by SQL capability which would obviously help with this. Additionally, I will take a look at supporting these through the LS query syntax. Cheers, Andrew. |
|