[web2py] Re: Appadmin sort not working

2016-12-11 Thread SimonD
Hello,
Thanks that all works now. This would be classed as a "schoolboy error" on 
my part :-)
Thank you again
Simon

On Sunday, December 11, 2016 at 1:14:47 PM UTC, Anthony wrote:
>
> It has nothing to do with share.js. What you have done results in a 
> Javascript error on the page, which causes the Javascript code to stop 
> working. By commenting out the src URL of the script tag, that is 
> equivalent to setting the URL to that of the current page. So, it reloads 
> the entire HTML page as if it is a Javascript file, which of course results 
> in an error, as it is not Javascript. If you want to comment out some HTML, 
> use HTML comments, or just delete the entire line.
>
> Anthony
>
> On Sunday, December 11, 2016 at 6:27:15 AM UTC-5, SimonD wrote:
>>
>> DaveS, thanks for advising and taking the time to look at this.
>>
>> After further diags, I think I have figured out what was causing this. 
>> Because I wanted to remove the little share icon at the bottom right, In 
>> my layout.html, I had disabled js/share.js by inserting a comment hash:
>> script src="{{#=URL(
>> Which I thought was an OK way to do that.
>>
>> But - disabling the share.js breaks the sorting.
>> When enabled - I can sort the data by click the id column (i.e. 
>> ascending, then descending etc...) in appadmin
>> When disabled - I cannot sort the data in this way. It is particularly 
>> noticeable when you have many pages of records.
>>
>> So - it seems share.js is required for appadmin to sort the data.
>> I thought share.js was only for social sharing - which I don't need in my 
>> app. I guess I could just have a different layout file just for appadmin, 
>> but is begs the questions though:
>> 1) Do we know why share.js is necessary for appadmin data sorting?  
>> 2) Can I disabled social sharing in another way (i.e. retaining share.js)?
>>
>> If not, maybe one of the project team can advise.
>>
>>
>>
>> On Saturday, December 10, 2016 at 7:35:26 PM UTC, SimonD wrote:
>>>
>>> Hello, I recently upgraded from 2.9.5 to 2.14.6
>>> I also moved from SQLite to mysql along the way as well as bootstrap 2 
>>> to 3
>>>
>>> In 2.9.5 - in appadmin, I could sort an entire table either ascending or 
>>> descending by clicking on the column header.
>>> I have a few big tables and its useful for testing etc (i.e. I can 
>>> easily see the last record by sorting-descending)
>>>
>>> In the install of 2.14.6, the ability to "sort descending" does not 
>>> work.It will only sort ascending, so e.g. finding the last record in a 
>>> table means knowing the record ID or lots of clicking "next 100 rows"
>>>
>>> When I upgraded I copied appdmin.py and its view from the welcome app
>>>
>>> Does 2.14.6 appadmin no longer sort like 2.9.5 or have I messed up the 
>>> upgrade?
>>>
>>> Thanks!
>>>
>>>
>>>
>>>
>>>
>>>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: Appadmin sort not working

2016-12-11 Thread Anthony
It has nothing to do with share.js. However, what you have done results in 
a Javascript error on the page, which causes the Javascript code to stop 
working. By commenting out the src URL of the script tag, that is 
equivalent to setting the URL to that of the current page, so it reloads 
the entire HTML page as if it is a Javascript file, which of course results 
in an error, as it is not Javascript. If you want to comment out some HTML, 
use HTML comments, or just delete the entire line.

Anthony

On Sunday, December 11, 2016 at 6:27:15 AM UTC-5, SimonD wrote:
>
> DaveS, thanks for advising and taking the time to look at this.
>
> After further diags, I think I have figured out what was causing this. 
> Because I wanted to remove the little share icon at the bottom right, In 
> my layout.html, I had disabled js/share.js by inserting a comment hash:
> script src="{{#=URL(
> Which I thought was an OK way to do that.
>
> But - disabling the share.js breaks the sorting.
> When enabled - I can sort the data by click the id column (i.e. ascending, 
> then descending etc...) in appadmin
> When disabled - I cannot sort the data in this way. It is particularly 
> noticeable when you have many pages of records.
>
> So - it seems share.js is required for appadmin to sort the data.
> I thought share.js was only for social sharing - which I don't need in my 
> app. I guess I could just have a different layout file just for appadmin, 
> but is begs the questions though:
> 1) Do we know why share.js is necessary for appadmin data sorting?  
> 2) Can I disabled social sharing in another way (i.e. retaining share.js)?
>
> If not, maybe one of the project team can advise.
>
>
>
> On Saturday, December 10, 2016 at 7:35:26 PM UTC, SimonD wrote:
>>
>> Hello, I recently upgraded from 2.9.5 to 2.14.6
>> I also moved from SQLite to mysql along the way as well as bootstrap 2 to 
>> 3
>>
>> In 2.9.5 - in appadmin, I could sort an entire table either ascending or 
>> descending by clicking on the column header.
>> I have a few big tables and its useful for testing etc (i.e. I can easily 
>> see the last record by sorting-descending)
>>
>> In the install of 2.14.6, the ability to "sort descending" does not 
>> work.It will only sort ascending, so e.g. finding the last record in a 
>> table means knowing the record ID or lots of clicking "next 100 rows"
>>
>> When I upgraded I copied appdmin.py and its view from the welcome app
>>
>> Does 2.14.6 appadmin no longer sort like 2.9.5 or have I messed up the 
>> upgrade?
>>
>> Thanks!
>>
>>
>>
>>
>>
>>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: Appadmin sort not working

2016-12-11 Thread SimonD
DaveS, thanks for advising and taking the time to look at this.

After further diags, I think I have figured out what was causing this. 
Because I wanted to remove the little share icon at the bottom right, In my 
layout.html, I had disabled js/share.js by inserting a comment hash:
script src="{{#=URL(
Which I thought was an OK way to do that.

But - disabling the share.js breaks the sorting.
When enabled - I can sort the data by click the id column (i.e. ascending, 
then descending etc...) in appadmin
When disabled - I cannot sort the data in this way. It is particularly 
noticeable when you have many pages of records.

So - it seems share.js is required for appadmin to sort the data.
I thought share.js was only for social sharing - which I don't need in my 
app. I guess I could just have a different layout file just for appadmin, 
but is begs the questions though:
1) Do we know why share.js is necessary for appadmin data sorting?  
2) Can I disabled social sharing in another way (i.e. retaining share.js)?

If not, maybe one of the project team can advise.



On Saturday, December 10, 2016 at 7:35:26 PM UTC, SimonD wrote:
>
> Hello, I recently upgraded from 2.9.5 to 2.14.6
> I also moved from SQLite to mysql along the way as well as bootstrap 2 to 3
>
> In 2.9.5 - in appadmin, I could sort an entire table either ascending or 
> descending by clicking on the column header.
> I have a few big tables and its useful for testing etc (i.e. I can easily 
> see the last record by sorting-descending)
>
> In the install of 2.14.6, the ability to "sort descending" does not 
> work.It will only sort ascending, so e.g. finding the last record in a 
> table means knowing the record ID or lots of clicking "next 100 rows"
>
> When I upgraded I copied appdmin.py and its view from the welcome app
>
> Does 2.14.6 appadmin no longer sort like 2.9.5 or have I messed up the 
> upgrade?
>
> Thanks!
>
>
>
>
>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: Appadmin sort not working

2016-12-10 Thread Dave S


On Saturday, December 10, 2016 at 11:35:26 AM UTC-8, SimonD wrote:
>
> Hello, I recently upgraded from 2.9.5 to 2.14.6
> I also moved from SQLite to mysql along the way as well as bootstrap 2 to 3
>
> In 2.9.5 - in appadmin, I could sort an entire table either ascending or 
> descending by clicking on the column header.
> I have a few big tables and its useful for testing etc (i.e. I can easily 
> see the last record by sorting-descending)
>
> In the install of 2.14.6, the ability to "sort descending" does not 
> work.It will only sort ascending, so e.g. finding the last record in a 
> table means knowing the record ID or lots of clicking "next 100 rows"
>

Clicking the column header worked for me, toggling up and down.  I tried it 
on two different tables (in different apps): the first was a one page table 
and the sorted column was an integer representing a year (not really a date 
field).  The other was a multipage table and the sorted column was an 
actual date field.  I am running 2.14.6.


 

> When I upgraded I copied appdmin.py and its view from the welcome app
>
> Does 2.14.6 appadmin no longer sort like 2.9.5 or have I messed up the 
> upgrade?
>
> Thanks!
>
>
Good luck!

Dave
/dps
 

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.