Condition in a Query

(0) Share

Report

Posted on by DARRA

Hi Experts

I am having issues trying to create a conditional inside a query.
I have a date column ("LastModifiedDate"), which is sometimes null, in the case it is null I want to get the following date “01/01/1900”
Could you please help me ?

query 70639802 "Sales. Inv. Line"
{
QueryType = Normal;

elements
{
    dataitem(SalesInvoiceLine; "Sales Invoice Line")
    {
        column(DocumentNo; "Document No.")
        {
        }
        column(LineNo; "Line No.")
        {
        }
        column(AmountIncludingVAT; "Amount Including VAT")
        {
        }
        column(LastModifiedDate; "LastModifiedDate")

{
}

I have the same question (0)

All responses (2)

Answers (0)

DARRA 40 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the response Josh!

Was this reply helpful? Yes No
Suggested answer

JAngle 137 on at

Like (0)

Report
Copy link

Link copied!

If you use the query to present data some where like a report or page then you can do a replacement value. In the case of the query object itself there are no options, properties or triggers that would do as you need. This resource might be helpful: thinkaboutit.be/.../

Was this reply helpful? Yes No