Skip to Content
author's profile photo Barbara Michnia
0
Barbara Michnia

Dynamic syntax - how to add text and other value?

Posted on Aug 09, 2016 at 02:00 PM 172 Views

Hi. I try to add text to my dynamic syntax.

For example I want to use formatted search in Sales Order document in Ref field to have Customer number + text + Document number ("C00001 text 45/2016").

I can make query to get customer number: SELECT $[$4.0.0]

But i have syntax error, when i try to add text: SELECT $[$4.0.0] + 'text' (i also tried || ).

When I'm using query like this: SELECT T0.[CardCode] + '-' + CAST(T0.[DocNum] AS VARCHAR) FROM ORDR T0

there are no errors, but when I add document, the values for first customer and document are taken, not for selected customer and I must look for correct value under magnificant glass.

How can I add text and other values to dynamic syntax for current document?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Agustin Marcos Cividanes
    Agustin Marcos Cividanes
    Posted on Aug 10, 2016 at 07:09 AM
    3

    Hi

    try this FMS:

    SELECT T0.[CardCode] + '-' + CAST(T0.[DocNum] AS VARCHAR) FROM ORDR T0 where T0.docnum = $[$8.0.0] and T0.series = $[$88.0.0]

    with this configuration.

    Kind regards

    Agustín Marcos Cividanes


    foro.png (11.3 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.