![]() $event_date_condition_description = "ALL events in the future and past are shown. Here is a short snippet of the code - if ( = "item_6") One advantage working with a submenu instead of buttons is that the code is placed in one place - event -> onexecute. Not every menu item is working at the moment but that is only “extra work” Instead of Buttons I use a “submenu” since I have a lot of “predefined searches” or “filters” for the ladies in the office This is NOT working, must be a Typo, where is it?įor me this task is solved - unfortunately i cannot change the titel by myself - …Īnyway probably someone is interested in my solution - thanks for the help guys. Sc_redir( 'grid_event', date_condition = 'start_date BETWEEN (CURDATE() - INTERVAL 1 MONTH) and (CURDATE() + INTERVAL 2 MONTH)') With a button “all” and it also works like a charm Sc_redir( 'grid_event', date_condition = 'TRUE') I also had some troubles with in/out settimg of the global variable but finally it works fine!! ![]() It prevents problems like these and it allows a better documentation in code." in the logon application if you have one. " … useually advise to create all global variables in one spot, i.e. I set the default value of in the MAINMENU, because I read this in the forum WORKS!! I’m asked to define and It works with both - “TRUE” and “start_date BETWEEN (CURDATE() - INTERVAL 1 MONTH) and (CURDATE() + INTERVAL 2 MONTH)” would the solutions also work for forms?.can I assign the search to a button that is display at the top of the grid so even if user changed it he can jump again to today pressing the button.would that be first in grid not last? that would be ok - i could do “start_date > “today” - 10 days” or so.To make it even more complicated, unfortunately not every day an event is started -Ĭan I do someting like a predefined search? that is executed the firs time the grid is opend like with the criteria start_date > “today”. It is more likly that the user will have to work on an event that is in the next future - let’s say the next two month - so when the grid is opend i would like to jump to an event thatn has the startrdate “today” an the schould be last event in the grid - so the users sees the “next” 20 events. ![]() I have a grid that shows all of the events - some are in the future (until dez 2015) and a lot are in the past - the grid shows 20 events - and is sorted by start_date - you can see it here The command needs to have the following structure: SELECT keyfield, displayfield FROM table The value of the keyfield will be stored in the table field. I’m still new to SC and hopefully there is a simple solution for my problem
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |