I have a need of knowing how much money I put in the cash register before I open the work period, and then of course knowing how much money I have when I close the work period… Without entering into accounts (far too complicated for me at this point). I decided to save all these CASH ??? (I dont know how to name them) into Entities…
Small suggestion for your Query, so that it is more universal for others to use without needing to know the [EntityTypeId], since it will be different than 6 for most people…
WHERE [EntityTypeId] = (SELECT [Id] FROM [EntityTypes] WHERE [Name]='CAJA')
Full Query:
SELECT
[Name]
,[CustomData] as [Apertura]
,[CustomData] as [Cierre]
,[CustomData] as [Tarjetas]
FROM [Entities]
WHERE [EntityTypeId] = (SELECT [Id] FROM [EntityTypes] WHERE [Name]='CAJA') -- set Entity Type
[Reporte de Cajas:2, 2, 2, 2]
>Caja - Fecha|:Apertura|:Cierre|:Tarjetas
@@ReporteCajas
SQL Script should look like the following and have Handler called @@ReporteCajas:
SELECT
[Name]
,[CustomData] as [Apertura]
,[CustomData] as [Cierre]
,[CustomData] as [Tarjetas]
FROM [Entities]
WHERE [EntityTypeId] IN (SELECT [Id] FROM [EntityTypes] WHERE [Name]='CAJA') -- set Entity Type
The Template calls Handler @@ReporteCajas which contains the SQL Script. The SQL Script should not be in the Template.
[Reporte de Cajas:2, 2, 2, 2]
>Caja - Fecha|:Apertura|:Cierre|:Tarjetas
@@ReporteCajas
This template reads custom fields named Apertura, Cierre custom fields. Headers starting with : char defines that. As @shuhain_ismail used field names as Opening, Clojure, Cards headers should match custom field names.
@emre@QMcKay
i am using the Spanish filed now but when i use English filed some value comes in report
report show no value… as i use filed name as defined in tutorial
will be helpful sample db provide
@shuhain_ismail you can drag drop images just inside the post edtior. No need to upload somewhere else. Can you try uploading them again? These are too small for my vision