on 05-12-2006 8:38 AM
Hi Experts,
I have the following problem:
I am trying to find out which tasks are accomplished in a specific period. In an R/3 table the data of different tasks are stored including the date of the task.
What I am trying is to get all tasks which are accomplished from f.e. 01/05/2006 to f.e. 31/05/2006.
Therefore I have added in an input form two Date Pickers (for "from" and for "to").
In order to get that list I think I have to go for dynamic expressions. I have already tried to use boolean expressions and operators like "<=" and ">=" but it didn´t work that way. But to be honest I am also not sure about the syntax for this specific scenario.
I would appreciate any idea. Perhaps anybody could give me an example of the syntax.
Thanks very much
Thomas
Let me see if I get it what u want.
U want to get the data of tasks from a R/3 backend system in a determinated time.
if so, u dont need to get involved with dinamic expression, u only have to make a function in R3 with attribute accesss remote (RFC).
If the dates are input by the user, make two input parameters ( fromDate and toDate ) put the estructure of the table that u wanna output in the table tabs. If the dates r constants dont put any input parameters.
And in the code, construct your SELECT in the WHERE put the dates ( input or constants) so u have in the table that u defined in Table tab the data that u need. Test it in R/3 and then u only have to use that RFC function in VC.
if this solution works for u, but u have problems implementing the program let me know.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rodrigo,
Here is the link to the document integrating SQL in Visual Composer:
Cheers
Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rodrigo,
Sorry for my late reply. That´s a very good idea. However I have also found another way of doing this. You can also do that by using SQL. I have found a document integrating SQL in VC with an example of filtering between 2 values.
I think that is also a very interesting approach.
Cheers
Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.