Golden Arrow In Query

[Former Member]

How to get Golden Arrow In Query for a particular field

Regards

Pawan

[Former Member]

Hi Pawan ,

You need to use "FOR BROWSE" at the end of the query to receive golden arrow .In some complicated query , you will not get it .

Hope this helps

Bishal

[Former Member]

Hi Pawan,

Check the Thread

*Close the thread if issue solved.

Regards

Jambulingam.P

[Former Member]

If your queries are not too complicated and there are key fields in the query, you will find those arrows by default. Please give the exact query that you want to have arrows but not available.

Thanks,

Gordon

[Former Member]

Hi Pawan,

It is not possible in SAP B1 and Query.

Orange Arrow is a Link button, it is link to other fieds and No way for get a Link Button(Orange Arrow).

example:

Select DocNum from oinv Document number and Orange Arrow will come and you can put this query

Select Comments from oinv Comments(Remarks) will come but Orange Arrow will not come, because Document number based on other fields but Remarks is not a base field.

Thanks,

Madhan.

[Former Member]

when write Select DocNum from oinv then golden arrow was not showing.

[former_member197621]

Hai Pawan Kumar Agarwal

In SAP B1 there is no specific code for get link button ,its possible for only simple query. for example

your query have Union all means arrow will not come,correct me if am miss under stand your question

[former_member376683]

please people at least read the query

Select DocNum From OINV

is that a complicated query ?????

How do you get DocNum to have Golden arrow is a very simple question....

[former_member376683]

my simple answer wold be to add the key field "DocEntry"

so Select DocEntry, DocNum From OINV

the golden arrow would be on DocEntry that is the key field