Hi all,
Is there anywhere in the database where I can find these 2 values?
Best answer by Tomas Ruderfelt
View originalHi all,
Is there anywhere in the database where I can find these 2 values?
Best answer by Tomas Ruderfelt
View originalI’m not sure if the System Info plugin shows info for dialogs, but you can try.
RMB on the bottom toolbar to show it, then click in a field.
Looking at the code the values are hardcoded to 1 in the client if you open the dialog from places like “Inventory Part In Stock”, “Receive inventory Part” etc.
That means that you can not change the values.
Ok, I did not make myself clear.
I am not looking for the default values, but values the user type in when printing the labels.
Her is some horrible code that nearly do it. There most be a cleaner way?
select
print_job_api.Get_User_Name(con.print_job_id) as user_name,
extractvalue(xmltype(xmlData.data), '//BARCODE_LINES/BARCODE_LINE[1]/ORIGIN_PACK_SIZE/text()') as pack_size,
extractvalue(xmltype(xmlData.data), '//BARCODE_LINES/BARCODE_LINE[1]/PART_NO/text()') as par_no,
extractvalue(xmltype(xmlData.data), '//BARCODE_LINES/BARCODE_LINE[1]/LOT_BATCH_NO/text()') as lot_batch_no,
extractvalue(xmltype(xmlData.data), '//BARCODE_LINES/BARCODE_LINE[1]/WAIV_DEV_REJ_NO/text()') as waiv_dev_rej_no,
extractvalue(xmltype(xmlData.data), '//BARCODE_LINES/BARCODE_LINE[1]/CONFIGURATION_ID/text()') as configuration_id,
extractvalue(xmltype(xmlData.data), '//BARCODE_LINES/BARCODE_LINE[1]/PROJECT_ID/text()') as project_id,
extractvalue(xmltype(xmlData.data), '//BARCODE_LINES/BARCODE_LINE[1]/SERIAL_NO/text()') as serial_no,
regexp_substr(client_sys.Get_Key_Reference_Value(con.instance_attr,'OPTIONS'),'\d+') as no_of_copies,
regexp_count(data, '?</BARCODE_ID>?') as no_of_labels_in_total
from print_job_contents con inner join xml_report_data xmlData on con.result_key= xmlData.result_key
where con.result_key= 95680
Aha, you need to se the parameters the user entered.
Here is another SQL you can use:
SELECT MIN(origin_pack_size) pack_size,
COUNT(DISTINCT barcode_id) number_of_labels,
COUNT(*) / COUNT(DISTINCT barcode_id) number_of_copies
FROM inventory_part_barcode_rep
WHERE result_key = 15503
Since the pack size is same on all lines in the report you can use min or max to get one of them.
inventory_part_barcode_rep... just in front of me
Thanks.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.