Not show empty tables

[Stanko]

Hello, I want to hide all the users where the tables are empty.
I tried to put where the red arrow is ::{0}:,}

I checked also this post because I thought the problem were the same, but I seem to turn around and can’t find a solution.

Reports Question - Not Show null tables

I am in the process of building a well documented discount and void setup. I am pretty much done I was just wondering if there is a simple way to not show null tables of Managers that did not have any void activity? I know one way for sure would be to check which admin has void activity in sql and only have my script return those users… I dont know SQL well and was wondering if there is a simpler way that I can think of? [image]

Thanks for any help

[JTRTech]

It’s hard to say without knowing what your calling in the script.
Looks like your gathering all data within the script so if that’s the case you would need to drop the irrelevent data within that.

It would be good if you better explained your situation.
Looks like your working on some form of time clock?

Show your script so everyone can understand what is happening as from what you posted all we know is your calling a script and rendering the response…

[Stanko]

The users() function only calls a list of all users from sambapos.

function users(){
var query = “SELECT [Name] FROM [MB].[dbo].[Users]”;
var result = sql.Query(query).Join(‘|’);
return result;
}

Then there is User:X which checks for every user if there is data in the Program setting column.

declare @Test varchar(20) = [at]1
SELECT SUBSTRING([Value], 0, CHARINDEX(‘;’, [VALUE]) ) as Name
,SUBSTRING([Value], CHARINDEX(‘;’, [VALUE])+1, 10 ) as DateBegin
,SUBSTRING([Value], CHARINDEX(‘;’, [VALUE])+11, 6 ) as TimeBegin
,SUBSTRING([Value], CHARINDEX(‘;’, [VALUE])+25, 10 ) as DateEnd
,SUBSTRING([Value], CHARINDEX(‘;’, [VALUE])+35, 6 ) as TimeEnd
,CASE WHEN SUBSTRING([Value], CHARINDEX(‘;’, [VALUE])+25, 10 ) = ‘’ THEN NULL ELSE CONVERT(varchar(10),DATEDIFF(minute,CONVERT(DATETIME,SUBSTRING([Value], CHARINDEX(‘;’, [VALUE])+1, 10 )+SUBSTRING([Value], CHARINDEX(‘;’, [VALUE])+11, 13 ),105),CONVERT(DATETIME,SUBSTRING([Value], CHARINDEX(‘;’, [VALUE])+25, 10 )+SUBSTRING([Value], CHARINDEX(‘;’, [VALUE])+35, 13 ),105))/60)+‘H’+ CONVERT(varchar(10),DATEDIFF(minute,CONVERT(DATETIME,SUBSTRING([Value], CHARINDEX(‘;’, [VALUE])+1, 10 )+SUBSTRING([Value], CHARINDEX(‘;’, [VALUE])+11, 13 ),105),CONVERT(DATETIME,SUBSTRING([Value], CHARINDEX(‘;’, [VALUE])+25, 10 )+SUBSTRING([Value], CHARINDEX(‘;’, [VALUE])+35, 13 ),105)) % 60)+‘min’ END AS ‘Temps’
FROM [MB].[dbo].[ProgramSettingValues]
Where SUBSTRING([Value], 0, CHARINDEX(‘;’, [VALUE]) ) = @Test

I think this is quite messy and could be made nicer with functions and variables…

Here is the example of one record:

Administrator;04-11-2019 08:52:42.020;04-11-2019 08:54:20.405

[JTRTech]

Either use tasks or even better would be Jesse’s 7shifts intergration.
Program settings is not the place to store mass info like that…
Also you will have report expressions for tasks which will be cleaner and easier than breaking apart all those values.

[Stanko]

Thanks I am now trying to make it with Tasks. This seems amazing and is much easier Thanks!

[Stanko]

Is there a list with constraints to be used with {REPORT TASK DETAILS:X} ?

I found this but there is no clue about Tasks… probably at the time it was not yet implemented…

Custom Report Tags in detail

We can prepare any type of reports with SQL and display results as a Custom Report. Alternatively we can use Custom Report Tags to prepare reports. If you need more information about preparing a custom report you can review this tutorial. ###Introduction Basically there are four types of tags. DETAILS TAGS: These tags contains DETAILS keyword in it and allows us to prepare table reports. TOTAL TAGS: If a tag contains TOTAL keyword in it we can use this tag read sum of a value. COUNT TAGS C…

[JTRTech]

Thats a v4 topic, are you using v4?
There was allot of dev for tasks around the implementation time of v5.

See here for some ideas.

Time Clock & Punch Editor - Custom Navigation Flow: Uses Employee Entities not Users

I have included only the configuration task as it is easy to update and it helps me keep this tutorial current Configuration Task Configuration Tasks: Time Clock + Punch Editor https://gist.github.com/kendash/35688644368ef581dc2d/raw/ Standalone Punch Editor https://gist.github.com/kendash/9a887f61097f1690b285/raw/ Copy the URL and navigate to Settings > Local Settings > Online Services and paste that URL in the box then go to Settings > Configuratio…

But not Jesse has retired this method in favour of the 7shifts intergration which offers allot of advantages. So be sure to check that out before spending too much time just looking at tasks to find you might actually prefer the 7shifts method.
I think his topic on that is in the beta section so you may not be able to see it.
For more info contact @Jesse for more details.

[Stanko]

Thanks. The aim of what I am doing is to have a very basic time tracking which is universal in the idea that there is no need to create entities for each user and so…

[JTRTech]

OK, well tasks should do the job, shouldnt need entities for the tasks side, depends what else your doing with it.