Struggling with JSON from database field

Wappler General
1

I have some JSON saved in a database field

{"1":{"part":"O\/S\/F Wingxxx","replace":"0","repair":"0","paint":"0"},"2":{"part":"Rear Bumper","replace":"0","repair":"1","paint":"1"},"3":{"part":"O\/S\/F Repeater","replace":"0","repair":"1","paint":"0"},"4":{"part":"Chassis Leg NS","replace":"0","repair":"0","paint":"0"},"5":{"part":"gsfh sfgh","replace":"0","repair":"0","paint":"0"},"6":{"part":"vhgj gdhjg","replace":"0","repair":"0","paint":"0"},"7":{"part":"","replace":"0","repair":"0","paint":"0"},"8":{"part":"","replace":"0","repair":"0","paint":"0"},"9":{"part":"","replace":"0","repair":"0","paint":"0"},"10":{"part":"","replace":"0","repair":"0","paint":"0"}}

Then in my Action Step I do a json_decode() to put the data into a variable

Set Value TEST12 = {{sa_ad_job_q.meth_json.json_decode()}}

And this is then output on the page

<div id="myRepeat" is="dmx-repeat" dmx-bind:repeat="sc_ad_job_q.data.TEST12">
  <div id="myConditional" is="dmx-if" dmx-bind:condition="(part != '')">
	$index  : {{$index}} || 
	$key    : {{$key}} || 
	Replace : {{replace}} || 
	Part    : {{part}} || 
  </div>
</div>

So far this works well.

My problem is trying to count the total number of records (which in t6his example would be ‘10’) and the number of records by condition (which would be ‘6’).

Total number of records : {{number of records}}
Number of records by condition : {{number of condition records}}

I cannot work out for the life of me how to return these two figures. Everything I have tried fails.

I am happy for someone to tell me I am doing it all wrong, I just want to be able to make it work :smile:

Please help.

2

You have
{{sa_ad_job_q.meth_json.json_decode()}}

In your post, should it be sc_ad_job_q?

3

My Server Actions start sa_ and
my Server Connects start sc_ so it is correct.
Thanks for looking so carefully :smile:

1 Like
4

Ah ok.
So the number of records should be

sc_ad_job_q.data.TEST12.count()

And the condition one should be

sc_ad_job_q.data.TEST12.where('part','','!=').count()

Does part return as an empty string or null?
'' will look for an empty string but will not match for null,
whereas sc_ad_job_q.data.TEST12.where('part',null,'!=').count() will not match the empty string.
To do both you could use sc_ad_job_q.data.TEST12.where('part.length()',1,'>=').count()

5

Thanks for the clear answers Ben but unfortunately I am getting no results

This is what I have used

<div id="repeat3" is="dmx-repeat" dmx-bind:repeat="sc_ad_job_q.data.TEST12">
  <div id="conditional6" is="dmx-if" dmx-bind:condition="(part != '')">
    $index  : {{$index}} || 
    $key    : {{$key}} || 
    Replace : {{replace}} || 
    Part    : {{part}} ||
    <br>
  </div>
</div>
<br>
1: {{sc_ad_job_q.data.TEST12.where('part','','!=').count()}}<br>
sc_ad_job_q.data.TEST12.where('part','','!=').count()
<br><br>
2: {{sc_ad_job_q.data.TEST12.count()}}<br>
sc_ad_job_q.data.TEST12.count()
<br><br>
3: {{sc_ad_job_q.data.TEST12.where('part.length()',1,'>=').count()}}<br>
sc_ad_job_q.data.TEST12.where('part.length()',1,'>=').count()
<br><br>

And this is the result

image

6

What do you get with:

1: {{sc_ad_job_q.data.TEST12[0]}}<br>

You could also try:

repeat3.items.count()

and

repeat3.items.where('part.length()',1,'>=').count()
7

OK tried that and the last two showed some results…

image

8

Are you using NodeJS?
If so you might just need to adjust
sc_ad_job_q.data.TEST12
to

content.sc_ad_job_q.data.TEST12
9

No, PHP

10

is it on a route page?

11

Yes

12

try
routename.sc_ad_job_q.data.TEST12

13

You can check the data binding path using dmx.app.data in console in the Chrome developer tools

14

Using dmx.app.data I got the following on line 2.

image

Don’t actually need the routing :smile:

15

Aha. So it was missing the ‘report_AD_new’ reference…
Add that to the start of the count statements and it’ll probably calculate then.

16

You’ve been a great help Ben, I just needed that extra brain (mine had fizzled out!) :smile:

Hopefully this will be enough to enable me to finish this piece.

1 Like