SQL validation Default logic return no value

57 views
Skip to first unread message

loghes...@konnectbi.com

unread,
Sep 17, 2018, 6:21:57 AM9/17/18
to iDempiere
@SQL=SELECT(@SQL=SELECT QtyEntered FROM C_Orderline WHERE C_Orderline_ID=@C_Orderline_ID@)-(@SQL=SELECT SUM(QtyEntered) FROM PP_Order WHERE C_Orderline_ID=@C_Orderline_ID@ and AD_Client_ID=@AD_Client_ID@)

Default logic return no value from this sql validation.where did i mistake..some one find me please..


Thanks in Advance
Loghes

Abraham Sulaeman

unread,
Sep 17, 2018, 6:37:31 AM9/17/18
to idem...@googlegroups.com
Format Default Logic :

@SQL=query_return_single_value

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/e7484707-8ecc-4335-872b-1370a5adf613%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Logheswaran S

unread,
Sep 17, 2018, 6:53:17 AM9/17/18
to idem...@googlegroups.com
Is there any possible to get sum of qty from multiple records for default logic

On Mon, Sep 17, 2018 at 4:07 PM, Abraham Sulaeman <abraham....@gmail.com> wrote:
Format Default Logic :

@SQL=query_return_single_value

On Mon, Sep 17, 2018, 17:21 <loghes...@konnectbi.com> wrote:
@SQL=SELECT(@SQL=SELECT QtyEntered FROM C_Orderline WHERE C_Orderline_ID=@C_Orderline_ID@)-(@SQL=SELECT SUM(QtyEntered) FROM PP_Order WHERE C_Orderline_ID=@C_Orderline_ID@ and AD_Client_ID=@AD_Client_ID@)

Default logic return no value from this sql validation.where did i mistake..some one find me please..


Thanks in Advance
Loghes

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+unsubscribe@googlegroups.com.

--
You received this message because you are subscribed to a topic in the Google Groups "iDempiere" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/idempiere/JfoPkg4zNJU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to idempiere+unsubscribe@googlegroups.com.
 To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/CAG_whJwJjeT6ONpCckvK1vuOGjm-vTm0hMkBrEsnsBj%2BLgqm%3DA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.



--
Logheswaran.S
Software Engineer - Jnr

Konnect Analytics
3rd Floor,S.S.Towers,
Kalapatti Main Road,
Civil Aerodrome Post,
Coimbatore-14.
M:+91 8939112133

Abraham Sulaeman

unread,
Sep 17, 2018, 7:06:19 AM9/17/18
to idem...@googlegroups.com
Yes, you can using any aggregate function such as SUM, MAX, COUNT etc, as long as your query return single value.

If it is complex query, you can create view to make you query simple and easy to understand and use it for your default logic query.

Rgds
Abraham

On Mon, Sep 17, 2018 at 5:53 PM Logheswaran S <loghes...@konnectbi.com> wrote:
Is there any possible to get sum of qty from multiple records for default logic
On Mon, Sep 17, 2018 at 4:07 PM, Abraham Sulaeman <abraham....@gmail.com> wrote:
Format Default Logic :

@SQL=query_return_single_value

On Mon, Sep 17, 2018, 17:21 <loghes...@konnectbi.com> wrote:
@SQL=SELECT(@SQL=SELECT QtyEntered FROM C_Orderline WHERE C_Orderline_ID=@C_Orderline_ID@)-(@SQL=SELECT SUM(QtyEntered) FROM PP_Order WHERE C_Orderline_ID=@C_Orderline_ID@ and AD_Client_ID=@AD_Client_ID@)

Default logic return no value from this sql validation.where did i mistake..some one find me please..


Thanks in Advance
Loghes

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.

--
You received this message because you are subscribed to a topic in the Google Groups "iDempiere" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/idempiere/JfoPkg4zNJU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/CAG_whJwJjeT6ONpCckvK1vuOGjm-vTm0hMkBrEsnsBj%2BLgqm%3DA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.



--
Logheswaran.S
Software Engineer - Jnr

Konnect Analytics
3rd Floor,S.S.Towers,
Kalapatti Main Road,
Civil Aerodrome Post,
Coimbatore-14.
M:+91 8939112133

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/CAK%2BSrK2zuLoJ3DALx5b_T1nxmZjhgGY5xJCHachnbA0gp0n%3D2Q%40mail.gmail.com.
Reply all
Reply to author
Forward
0 new messages