Forum

Hello, I have created a custom query,but it did't works.Can you help me

SEL ECT

CatalogCashiers.LastName,
CatalogCashiers.FirstName,

CASE

WHEN CatalogCashiers.Gender = "Female"
THEN "Mrs. ," + SUBSTRING(CatalogCashiers.LastName, 1, 1) + "," +
                       SUBSTRING(CatalogCashiers.FirstName, 1, 1)
WHEN CatalogCashiers.Gender = "Male"
       THEN
              "Mr. ," + SUBSTRING(CatalogCashiers.LastName, 1, 1) + "," +
                       SUBSTRING(CatalogCashiers.FirstName, 1, 1)
       ELSE
      SUBSTRING(CatalogCashiers.LastName, 1, 1) + "," +
                      SUBSTRING(CatalogCashiers.FirstName, 1, 1)
END

FR OM
Catalog.Cashiers AS CatalogCashiers

Hello Mesut,

i copied your code and it works absolutely correctly - see screenshots 1 and 2 pls.

By the way, it's not quite the right decision to store gender as a String. It's better to use an enumeration for this. After that the application structure will look like in scr. 3, and the query:

SELECT
   CatalogCashiers.LastName AS LastName,
   CatalogCashiers.FirstName AS FirstName,
   CASE
      WHEN CatalogCashiers.Gender = VALUE(Enum.Gender.Female)
         THEN "Mrs. ," + SUBSTRING(CatalogCashiers.LastName, 1, 1) + "," + SUBSTRING(CatalogCashiers.FirstName, 1, 1)
      WHEN CatalogCashiers.Gender = VALUE(Enum.Gender.Male)
         THEN "Mr. ," + SUBSTRING(CatalogCashiers.LastName, 1, 1) + "," + SUBSTRING(CatalogCashiers.FirstName, 1, 1)
      ELSE SUBSTRING(CatalogCashiers.LastName, 1, 1) + "," + SUBSTRING(CatalogCashiers.FirstName, 1, 1)
   END AS Field1
FROM
   Catalog.Cashiers AS CatalogCashiers

it works Thank you Aleksandr Biryukov!

I have also a simple question.
User enter a number and amountpaid that is greater than the number is showed.
My code below;

SEL ECT
Sales.Number AS Number,
Sales.Date AS Date,
Sales.AmountPaid AS AmountPaid,
Sales.PaymentMethod AS PaymentMethod
FR OM
Document.Sales AS Sales

WHERE AmountPaid > What I need to write here
ORDER BY AmountPaid DESC

Mesut,

unfortunately, I didn't quite understand your question

Do you want to select payments above a certain amount?

In this case, the query code will be like this:

WHERE AmountPaid > &Number

Mesut,

You need to pass the minimum amount as a parameter as is shown in this episode of the course. Please, watch it once again.

Konstantin

Thank you , it works

Thank you , it works