Skip to Content
author's profile photo Former Member
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 181 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.

SAP Business One Extensibility
Add comment
10|10000 characters needed characters exceeded

2 Answers

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

    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 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

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

    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 comment
    10|10000 characters needed characters exceeded