Entity Screen Header Formatting

V5 Request
1

Sure someone else will back the idea…

What about entity header display format field?

I would like to make say a subtitle for a open tickets count.
So using something like;
<size 24>{0}</size><linebreak/><size 24>{SomeFunctionForOpenTicketCountForListedEntities}</size>

Might need something new for easily getting ticket count of entity screen listed entities but not thought too much into that part yet as cant format entity screen header yet…

2

What do you mean by Entity Header?

EDIT: Nevermind I see it in the title now. This confused me: [quote=“JTRTech, post:1, topic:9091”]
What about entity header display format field?
[/quote]

Couldnt you get the same thing with a Label Widget placed at top without header showing?

3

This ternary would give you an idea.

[=(TN('{REPORT TICKET COUNT:(TS.Status=Unpaid)}') > 0 ? '<linebreak/><italic>Open Tickets:</italic> ' + TN('{REPORT TICKET COUNT:(TS.Status=Unpaid)}') : '')]

You would use Entity States… open tickets would have Entity State Status= New Orders. So you can filter that report by Entity State Status and Entity Type for correct Entity Type.Of course Unpaid would be open tickets.

EDIT: thinking about it this should work just fine: {REPORT TICKET COUNT:(TS.Status=Unpaid) AND (TCET=Customers)}

4

Label widget was the backup plan/plan in the mean time :smile:

As for counting the tickets it would be more complex that that as if you split tables into screens by room - in my case bar, restaurant, conservatory and garden.
They would all be table entities but would want to have the number of tickets open for entities in each room/screen.

5

How are you filtering them to the screens? Static assignment?

6

Yes, static assignment, 25 in bar, 14 in conserve, 16 in restaurant and 12 in garden.

7

so this should work then.

@Table 1,Table2,Table3,Table4
{REPORT TICKET COUNT:(TS.Status=Unpaid) AND (TEN.Tables=$1)}

You could be even more dynamic than that by using a script call after @ to select specific tables.

An alternative is to use SQL script for it… this is a basic one for all tickets but you would customize it for those specific entities and for open tickets only.

Select count(*) from Tickets where Date > '{Start}' and Date < '{End}'

8

Hmmm, your using @list with report tag, and that would work in a widget label would it?

Just had a thought for posible simpler solution…
We can use entity cueld as an expression right? So could add a entity field of dining area and filter report based on the entity field = bar etc.

9

Several ways to do it yes.