Hello!
Please estimate how many hours of revision:
1. Filter in the process of date interval (selection of dates from and to). It is necessary to filter the products of the process by these dates (interval).
2. Calculation of the total for the numerical fields of the products of the process in a given interval.
Hello! Please estimate how many hours of revision: 1. Filter in the process of date interval (selection of dates from and to). It is necessary to filter the products of the process by these dates (interval). 2. Calculation of the total for the numerical fields of the products of the process in a given interval.
Ustimenko Igor OneBox Corp. OneBox CTO wrote: it is not at all clear what and by what fields to filter
1. There are additional fields in the process with the "date" type. Select dates from and to. 2. Process products have creation dates. It is necessary to filter (select) products in a given interval in order to form process documents based on this data.
[quote]
Ustimenko Igor
OneBox Corp.
OneBox CTO wrote:
it is not at all clear what and by what fields to filter
[/quote]
1. There are additional fields in the process with the "date" type. Select dates from and to.
2. Process products have creation dates.
It is necessary to filter (select) products in a given interval in order to form process documents based on this data.
[file]14910[/file]
Ustimenko Igor OneBox Corp. OneBox CTO wrote: Do you want to filter the table of process products on the basis of two additional fields with the date type and put these products into the document?
Yes
[quote]
Ustimenko Igor
OneBox Corp.
OneBox CTO wrote:
Do you want to filter the table of process products on the basis of two additional fields with the date type and put these products into the document?
[/quote]
Yes
not the crutches you came up with do through action then in the documents display the table according to the parameters and then you will have what you want
not the crutches you came up with
do through action
then in the documents display the table according to the parameters and then you will have what you want
[file]14926[/file]
Ustimenko Igor OneBox Corp. OneBox CTO wrote: not the crutches you came up with do through action then in the documents display the table according to the parameters and then you will have what you want
So I couldn't apply this action to execution :( What needs to be solved by the date filter: 1. There is a list of tasks in the "Product Table" of the process. Each task (product) has its own date and quantity 2. Tasks (products) are transferred to this table from subprocesses. 3. In the parent process, tasks (products) are accumulated for different dates. 4. Responsible for the parent.process selects the date period from and to. Let's say from 01/01/2022 to 01/23/2022. 5. The table filters out products that have an entry on these dates. 6. Based on them, you can start the summation of the number 7. Based on the filtered products, documents can be generated in this way. Ideally, the action is based on the principle as in the filtering panel "Date of creation-Selection of processes that are within the specified period of time. The condition is formed: "Date of creation from" (cdate [>=]) and "Date of creation to" (cdate [<=]) "
[quote]
Ustimenko Igor
OneBox Corp.
OneBox CTO wrote:
not the crutches you came up with
do through action
then in the documents display the table according to the parameters and then you will have what you want
[file]14926[/file]
[/quote]
So I couldn't apply this action to execution :(
What needs to be solved by the date filter:
1. There is a list of tasks in the "Product Table" of the process. Each task (product) has its own date and quantity
2. Tasks (products) are transferred to this table from subprocesses.
3. In the parent process, tasks (products) are accumulated for different dates.
4. Responsible for the parent.process selects the date period from and to. Let's say from 01/01/2022 to 01/23/2022.
5. The table filters out products that have an entry on these dates.
6. Based on them, you can start the summation of the number
7. Based on the filtered products, documents can be generated in this way.
Ideally, the action is based on the principle as in the filtering panel "Date of creation-Selection of processes that are within the specified period of time. The condition is formed: "Date of creation from" (cdate [>=]) and "Date of creation to" (cdate [<=]) "
I can offer easier. option. you can, on the basis of dates, by the action of checking the conditions, put down the selected column for the goods that fall under the condition, and already in the action to write out a document or block there is a checkbox to generate a document according to the selected
I can offer easier. option.
you can, on the basis of dates, by the action of checking the conditions, put down the selected column for the goods that fall under the condition, and already in the action to write out a document or block there is a checkbox to generate a document according to the selected
I checked the options, does not filter the selection.
Or writes a condition (test) in an additional field to all products of the process.
Please tell me how to solve this problem?
Actions on the procedure: https://segorwork.1b.app/app/workflow/3/procedure/35/
Test process in tab https://segorwork.1b.app/98/?tabid=4
Ustimenko Igor OneBox production OneBox CTO wrote: Why didn't you set several conditions by date in the 1st action? where do you make items selected ?
Dates are selected in the tab https://segorwork.1b.app/98/?tabid=4 Block "Shaping" fields with dates for filtering products: Start date, End date
[quote]
Ustimenko Igor
OneBox production
OneBox CTO wrote:
Why didn't you set several conditions by date in the 1st action?
where do you make items selected ?
[/quote]
Dates are selected in the tab https://segorwork.1b.app/98/?tabid=4
Block "Shaping" fields with dates for filtering products: Start date, End date
[file]15113[/file]
Ustimenko Igor OneBox production OneBox CTO wrote: Why didn't you set several conditions by date in the 1st action? where do you make items selected ?
What needs to be solved by this filter. By actions: 1. In the process, a date period is selected. 2. Based on this period, the date in the Process Products is filtered and compared, and if the dates are within the specified period, a numeric value should be recorded. 3. Numerical values are summed up. 4. A document is issued where products are entered that have a numerical value and the sum of these values. Date checks do not fit the value. Point 1.2 is not fulfilled. How to properly configure this action?
[quote]
Ustimenko Igor
OneBox production
OneBox CTO wrote:
Why didn't you set several conditions by date in the 1st action?
where do you make items selected ?
[/quote]
What needs to be solved by this filter.
By actions:
1. In the process, a date period is selected.
2. Based on this period, the date in the Process Products is filtered and compared, and if the dates are within the specified period, a numeric value should be recorded.
3. Numerical values are summed up.
4. A document is issued where products are entered that have a numerical value and the sum of these values.
Date checks do not fit the value.
Point 1.2 is not fulfilled.
How to properly configure this action?
[file]15141[/file]
[quote]
Ustimenko Igor
OneBox production
OneBox CTO wrote:
I lost my notification on this topic, let me set it up for you to test
[/quote]
I reproduced the procedure in my Box:
process https://olmonic.crm-onebox.com/1982/
procedure https://olmonic.crm-onebox.com/app/workflow/46/procedure/44/
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Donate
You don't have enough funds in your account Top up