The recommended method of customizing your AppGini-generated application is through hooks. But sometimes you might need to add functionality not accessible through hooks. You can discuss this here.
-
pfrumkin
- Veteran Member
- Posts: 157
- Joined: 2020-02-18 17:58
- Location: Albuquerque, New Mexico USA
Post
by pfrumkin » 2020-07-08 21:56
Hi,
It seems that the Options List is always sorted alphabetically. Anyone know if there is a way to get the Options List to display in the order I provide (and not sort it alphabetically for me)? I found
viewtopic.php?t=1586 was going along this line but there was not enough information there, and maybe not the same use case so I created separate post.
I exactly have the Payment Type Options List
Cash;;Credit Card;;Check;;Other
but it displays
- Cash
- Check
- Credit Card
- Other
not what I want.
Thanks.
~Paul
AppGini 5.82
-
D Oliveira
- AppGini Super Hero
- Posts: 348
- Joined: 2018-03-04 09:30
- Location: David
Post
by D Oliveira » 2020-07-10 02:11
on mobile devices you're hopeless, seems to be default and fixed, in tableview if thats what you're looking for (desktop only) go to your tablename_view.php file and find:
Code: Select all
$x->ColCaption = array( "colname1", "colname2", "colname3");
$x->ColFieldName = array('kcal', 'fat', 'carbs');
$x->ColNumber = array(12, 14, 16);
-
pbottcher
- AppGini Super Hero
- Posts: 1638
- Joined: 2018-04-01 10:12
Post
by pbottcher » 2020-07-10 06:14
Hi,
can you please post a screenshot. I was not able to reproduce your case. On my system it shows the option list in the order I provide in the option list defintion.
- option_list.png (5.86 KiB) Viewed 7049 times
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
-
pfrumkin
- Veteran Member
- Posts: 157
- Joined: 2020-02-18 17:58
- Location: Albuquerque, New Mexico USA
Post
by pfrumkin » 2020-07-10 15:52
- OptionsList.png (15.52 KiB) Viewed 7026 times
-
D Oliveira
- AppGini Super Hero
- Posts: 348
- Joined: 2018-03-04 09:30
- Location: David
Post
by D Oliveira » 2020-07-10 17:59
oh in that case you might wanna check tablename_dml.php
Code: Select all
$combo_statusp->ListItem = explode('||', entitiesToUTF8(convertLegacyOptions("option1;;option2;;option3")));
or list it like that:
-
pbottcher
- AppGini Super Hero
- Posts: 1638
- Joined: 2018-04-01 10:12
Post
by pbottcher » 2020-07-10 18:25
What version of AppGini are you using?
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
-
pfrumkin
- Veteran Member
- Posts: 157
- Joined: 2020-02-18 17:58
- Location: Albuquerque, New Mexico USA
Post
by pfrumkin » 2020-07-10 22:56
@D Oliveira
$combo_Payment_Type->ListItem = explode('||', entitiesToUTF8(convertLegacyOptions("Cash;;Credit Card;;Check;;Other")));
@pböttcher
AppGini 5.82 Revision 1101
-
pbottcher
- AppGini Super Hero
- Posts: 1638
- Joined: 2018-04-01 10:12
Post
by pbottcher » 2020-07-11 11:12
Are you using any other script or is that native?
Can you create a small nativ test app and see if it has the same issue?
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
-
pfrumkin
- Veteran Member
- Posts: 157
- Joined: 2020-02-18 17:58
- Location: Albuquerque, New Mexico USA
Post
by pfrumkin » 2020-07-12 17:05
Sorry I don't understand. There is a dv.js file. Otherwise this is out of the box AppGini. I also did this with a .csv file, same result. It seems that it is alphabetizing the result.
-
pbottcher
- AppGini Super Hero
- Posts: 1638
- Joined: 2018-04-01 10:12
Post
by pbottcher » 2020-07-12 17:19
Can you post your dv.js file (or rename it and see if it still happens)
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
-
pfrumkin
- Veteran Member
- Posts: 157
- Joined: 2020-02-18 17:58
- Location: Albuquerque, New Mexico USA
Post
by pfrumkin » 2020-07-13 14:54
I was wrong, there is no JS files. There is a one line format statement (added recently, after we'd seen this sorting) in the _dv hook, otherwise nothing in the hooks file either.
We had prefixed the options with spaces to "encourage" the sorting I wanted, but we found it wasn't saving the data that way so we had to remove the spaces.
-
zibrahim
- Veteran Member
- Posts: 137
- Joined: 2020-01-28 18:30
- Location: Malaysia
Post
by zibrahim » 2020-07-14 00:10
Hi Guys,
I am having similar issue as well.
- Screen Shot 2020-07-14 at 8.06.30 AM.png (143.91 KiB) Viewed 6884 times
- Screen Shot 2020-07-14 at 8.07.24 AM.png (43.96 KiB) Viewed 6884 times
Any help is appreciated.
Thanks.
Zala.
Zala.
Appgini 24.10.1579, MacOS 14.3.1 Windows 11 on Parallels.
-
pfrumkin
- Veteran Member
- Posts: 157
- Joined: 2020-02-18 17:58
- Location: Albuquerque, New Mexico USA
Post
by pfrumkin » 2020-07-17 16:33
Well, I did a total hack
. When I did View Source I found
Code: Select all
<script>jQuery(function(){
jQuery("#Payment_Type")
.addClass('option_list')
.select2({
minimumResultsForSearch: 5,
sortResults: AppGini.sortSelect2ByRelevence
});
})</script>
In my tablename_dv hook, I added
Code: Select all
$html = str_replace('AppGini.sortSelect2ByRelevence', ';', $html);
This effectively makes this sort a no-op. So as written, this has the unintended side effect of removing all such sorting on the form so handle with care. I had one other field on the form that has this and not sorting is ok.
-
pfrumkin
- Veteran Member
- Posts: 157
- Joined: 2020-02-18 17:58
- Location: Albuquerque, New Mexico USA
Post
by pfrumkin » 2020-07-27 17:14
Perhaps predictably (sigh) my hack didn't work. I am now experimenting with an expansion
Code: Select all
$html = str_replace('AppGini.sortSelect2ByRelevence', 'function(res, cont, qry) {
return res.sort(function(a, b) { return false; }); }', $html);
I dug into the definition of AppGini.sortSelect2ByRelevence and tweaked it to get the result I wanted. There is too much about this that I don't understand (not knowing JS very well) but I don't have time to dig further
.
-
pbottcher
- AppGini Super Hero
- Posts: 1638
- Joined: 2018-04-01 10:12
Post
by pbottcher » 2020-07-27 17:46
Hi,
can you create an app like this and tell if the sorting still happens.
- sort.png (123.11 KiB) Viewed 6736 times
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
-
zibrahim
- Veteran Member
- Posts: 137
- Joined: 2020-01-28 18:30
- Location: Malaysia
Post
by zibrahim » 2020-07-28 07:56
Hi pböttcher,
I have tried as requested and sorting is not as expected.
Please refer below images.
Thanks.
- Screen Shot 2020-07-28 at 3.54.33 PM.png (75.25 KiB) Viewed 6713 times
- Screen Shot 2020-07-28 at 3.54.12 PM.png (51.93 KiB) Viewed 6713 times
Zala.
Appgini 24.10.1579, MacOS 14.3.1 Windows 11 on Parallels.
-
pfrumkin
- Veteran Member
- Posts: 157
- Joined: 2020-02-18 17:58
- Location: Albuquerque, New Mexico USA
Post
by pfrumkin » 2020-07-28 19:33
Thanks for that follow up Zala! It was going to take me another day to get there.
-
zibrahim
- Veteran Member
- Posts: 137
- Joined: 2020-01-28 18:30
- Location: Malaysia
Post
by zibrahim » 2020-07-30 08:41
A quick update on this issue.
I found that this sorting issue happen when I run it in my XAMPP (ver 7.4.1).
It is working properly on the actual server and this is NOT Appgini problem.
I will try on other version of XAMPP later and update the outcome.
Thanks Pascal for helping.
Zala.
Zala.
Appgini 24.10.1579, MacOS 14.3.1 Windows 11 on Parallels.
-
zibrahim
- Veteran Member
- Posts: 137
- Joined: 2020-01-28 18:30
- Location: Malaysia
Post
by zibrahim » 2020-07-30 13:19
I have installed the latest XAMPP 7.4.8 and after testing, it didn’t do the sorting as expected.
I am not sure what is wrong with XAMPP but since it is not a big issue, I will leave it as it is.
As long it is working properly in the actual server, it is good for me.
Hope this clear the issue that it is not Appgini problem.
Thank you and have a nice day.
Zala.
Zala.
Appgini 24.10.1579, MacOS 14.3.1 Windows 11 on Parallels.
-
pfrumkin
- Veteran Member
- Posts: 157
- Joined: 2020-02-18 17:58
- Location: Albuquerque, New Mexico USA
Post
by pfrumkin » 2020-08-02 17:48
Thanks for that additional follow up Zala, and Pascal.