Posts by Amin Mousavi

Hi David, I have a report control that is displaying the results that an API returns. I would like to write an SQL query on the results. I know how to read the JSON objects and manipulate them in a loop at the success event of HTTPCLIENT, but I was looking for using some SQL at the client side if possible. My queries on the server side are becoming more and more complicated and pushing some of the processing pressure to the client side would be nice.

Hi David, It works exactly as expected, thanks a million as always for the great support. Regards,

Hi David, I have an API that is sending more than 100 rows of data to the report control to display. So I have limit the API to send 50 rows at each request and there are back and forward buttons controlling that. Now the issue I could not overcome is that, when you are reading the line 50, you hit the next button, HTTP client loads the next 50 rows into the report control and now because report control has been strolled to the very bottom you will see the row 100. What I need is a syntax to be used for scrolling the report control all the way up any time next/previous buttons are hit. Thanks in advance

Hi Tin, With the sticky headers, I know it may sound very unprofessional but I think one way could be using some labels or images on top of the table. For the same problem I followed a different method, I was going to display more than 3 fields and even scrolling was not a good solution for me so I re-arranged the table display altogehter. so instead of this in the html: <td>[Record.F1]</td> <td>[Record.F2]</td> <td>[Record.F3]</td> I used this: <td> <div>[Record.F1]</div> <div class="what_ever_class">Category: [Record.F2] - Published at: [Record.F3]</div> </td> with some CSS you can control how your fields appear in the report control

Hi David, For the App that we are combining with the old Phonegap app we hit another issue. Now we will need to have a home button in the AB part to close the iframe and return back to the page that has opened it. Phone's back button does that already but we have got stuck on how to close an iframe from inside of it, appreciate any help on that.

Hi David,

Thanks for your great support, got it sorted! It just needed one more line of code! So because Space bar was firing the click event instead of spacing, I had to add the space when it was pushed manually, like below:

If "[View1.Event.keyCode]" "==" "32" SetVar "[TextArea.Value]" "[TextArea.Value] " "String" Exit EndIf

Hi David,

In one of the Views I have put an some lines of code on the click event of the view itself. In fact I have a button that appears in some situations and I wanted to allow user to click elsewhere to hide it and I did it by writing the code on view's click event. This part works great, the issue it causes though is that space bar also acts as click now, so when in the inputs available in the view a space is needed, instead of having a white space, click event is fired, I was wondering is there away that I can read the space bar event and perhaps put an exception in the click event? something like below:

I assume like this space bar gets back to do what it was doing?

If (space bar is not hit) hide "button1" EndIf

Thanks a mill

Hi David, You are right, I had put that container there before I had a link there so I can get rid of it, sure thanks! Will try ng-show and ng-hide as well. Thanks a lot as always for your great support and the extra steps you always take! It is very much appreciated!

Hi David, Thanks a lot for your help. With a small modification it worked for me. So because I have used "ng-if" in a "span" outside the "div" my link was in "class" had been read differently. So my code turned into below: <span ng-if="Record.X" class="do-the-job"><a href="#" onclick="return false;" id="[Record.ID]">[Record.Title]</a></span> ----- If "[Report1.Event.target.parentElement.className]" "==" "do-the-job ng-scope" Alert "" "You tap into the link with ID: [Report1.Event.target.parentElement.id]" EndIf

Hi David, I am actually enjoying using the "ng-if" and "ng-class" and the links you sent are also very helpful. Thank you. I have two other questions here though, in the table that I am creating users are able to rate some comments and not the others, I have used "ng-if" to enable and disable the "rate this" link for each record. Now my problem is that I can not call the relevant AB view using the link like this <a href="app\rating.html">rate this</a> Another issue that I have is that, when user clicks on a row in the report control, we can read [ReportControl.Record.Fieldname] variable at report's click event to find out what record has been clicked. Would the same work if user has clicked on a link in a row rather than the row itself? Thanks.

Hi David,

Thanks a lot for your great support.

I just finished implementing the piece I was working on using like below:

<td ng-class="{when_NOT_NULL_CSS_Class: Record.ID}"></td>

There is only one thing in your comment that was not working for my case, "Record.ID 1" as the statement was not working and was throwing errors, so instead I handled the statement at server side and returned 0 and 1 based on what I needed. Again I had an issue which was "Record.ID" datatype I assume, so instead of working with datatypes, in return I returned null/else from server and now it works just like expected.

I agree with you that it is better to handle the data at the server side, however sometimes like in this case it is not matter of data manipulation but it is data presentation. I wanted certain records of the same table to be presented in a different style than the others. I could separate them with a Boolean field in the data but at the end server would export the data all together and I needed to differ them at the client side. All that being said, once in a while I like to put some of the processing pressure on to the client to reduce server's workload.

All in all, ng-class worked for me, now lets say similar to stack over flow, my users can respond to a question and other users can respond to the previous responses and during the presentation process client device can differ the level of responses and display them appropriately.

Thanks a mill for your help David

Hi David,

I will need to display each row in the report control in a specific way. I thought I might be able to write some JS in the report control Html but it seems like it does not accept it. I appreciate if you can assist me on that.So below is what I would need, I wrote an IF statement in upper case that if I could have it in the below example my problem was solved:

<td> [Record.ID] </td> <td if [record.name] == 0 class="CLASS1" else=""> [Record.Name] </td>

Thanks

Hi David,

That's fantastic! this helps a lot some times!

Hi David,It is something I wanted to ask from the beginning but I hoped that I find the answer for it but could not. So in AB we can use // to comment a line, what about bulk commenting? I could not find any thing in the AB like /* */ in php for instance. Helps a lot some times!

Hi David,

You are awesome! Just managed to test it and it is working great now, quick and smooth, THANKS A MILL