Custom Report Using Query

[FMDO]

Tried to create Custom Report using Query. But can’t make it using WHERE clause.

SELECT
h.item_name as ‘Item Name’,
FROM tabItem h,
WHERE
h.country = “US” as ‘Country’;

I don’t know what is wrong.

any help guys. Thanks

[NCP]

Hi @FMDO,

If the country is available in Item doctype then apply it.

SELECT
    `tabItem`.`name` AS `Item:Link/Item:200`,
    `tabItem`.`item_name` AS `Item Name:Data:200`
FROM
    `tabItem`
WHERE
    `tabItem`.`country` = "US"

Reference:

Create scripts report error

Hi @Zeeshan_Naeem, I think You should check the documentation of the server script report and also check the video. Query Report for please check it. [Reports II - Query Report] Script Report for please check it. [Reports III - Script Report] I hope this helps. Thank You!

Thank You!

[FMDO]

I appreciate. But when I tried it doesn’t work. @NCP

I’m using latest ERP system.

[NCP]

Hi @FMDO,

We already said like please check this.

@NCP

If the country is available in Item doctype then apply it.

And also check the reference.

Thank You!

[yosef]

SELECT
    h.item_name as 'Item Name',
    h.country as 'Country'
FROM
    tabItem h
WHERE
    h.country = 'US';

if it didn’t work please show what kind of error it give you