Skip to Content
author's profile photo Former Member
0
Former Member

How do I refer to a user defined field in a query (using $ notation) ?

Posted on Jun 03, 2005 at 03:14 AM 234 Views

if i have a user defined field in Invoice header called U_Test, and if I need to read it using a query (to be used on a formatted search).

I am not quite sure of the syntax. can anyone help please?

I tried

$[$U_Test.0.0] which is the accepted way with fields with numerical ids such as $[$8.0.0] etc.

appreciate any help,

Indika.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Alexey Grebennikov
    Alexey Grebennikov
    Posted on Jun 03, 2005 at 05:06 AM
    2

    Hi!

    You should use Table.Field notation. In your case it'll probably be <b>SELECT OINV.U_Test</b>...

    I suppose you are going to implement an universal query for all the forms, but... tehere is no trick for that issue, you have to develop unique query for every form.

    Hope, it helps

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Alexey Grebennikov
      Jul 28, 2006 at 03:43 PM

      Hi everyone,

      I am new to this forum and this is my 1st time posting. I'm here because I basically am trying to do exactly what Indika is trying to do.

      But I have tried all suggestion made in this thread, with no luck. Has anyone actually got this to work?

      James

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 02:24 PM
    0

    Hi Indika, Try typing "N" before the "$" character in your formatted search query like this .... N$[OWOR.U_Test] . This works for me when referencing UDFs on Header

    Add a comment
    10|10000 characters needed characters exceeded

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.