Hello Xiaofeng,

In your script, not sure if it is the indented behavior, but when looping through the loaded AVPs, you are pushing in cache the same key ("domain") for all the values -> this will overwrite any previous value and you will end up storing only the last value.

The second "while" loop has no sense, as a key (in cache) has only one value (cannot be multiple).

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 21.09.2016 12:09, xiaofeng wrote:

On Tue, Sep 20, 2016 at 7:25 PM, Bogdan-Andrei Iancu <bog...@opensips.org <mailto:bog...@opensips.org>> wrote:
>
> Hello,
>
> The avp_db_query() stores the DB result (multiple rows with multiple columns) into a set of AVPs (kind of an array). See > http://www.opensips.org/html/docs/modules/2.2.x/avpops.html#id293973 <http://www.opensips.org/html/docs/modules/2.2.x/avpops.html#id293973>
>
> Using a while loop (see http://www.opensips.org/Documentation/Script-Statements-2-2#toc3 <http://www.opensips.org/Documentation/Script-Statements-2-2#toc3>), you can iterate throw all the rows, by checking the if $(avp(xxx)[$var(idx)]) is NULL or not (where $var(idx) is the variable in the while loop).
>
> Inside the loop, simply store the row (all the AVPs with that index) into cache DB .
>
Just a example, if I understand what you mean:
https://gist.github.com/was4444/ef203d871d5ed3b32144d41787862ac0 <https://gist.github.com/was4444/ef203d871d5ed3b32144d41787862ac0>

It seems that we cannot fetch AVPs use `cache_fetch("local", "attribute", $avp(values))` according to the document https://www.opensips.org/Documentation/Script-CoreFunctions-2-2#toc4 <https://www.opensips.org/Documentation/Script-CoreFunctions-2-2#toc4>


Regards,

xiaofeng

--
gpg key fingerprint:
2048R/5E63005B
C84F 671F 70B7 7330 4726  5EC8 02BC CBA2 5E63 005B
--
_______________________________________________
Users mailing list
Users@lists.opensips.org <mailto:Users@lists.opensips.org>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users <http://lists.opensips.org/cgi-bin/mailman/listinfo/users>



--
xiaofeng

--
gpg key fingerprint:
2048R/5E63005B
C84F 671F 70B7 7330 4726  5EC8 02BC CBA2 5E63 005B
--
trans-zh_cn mailing list
trans-zh...@lists.fedoraproject.org <mailto:trans-zh...@lists.fedoraproject.org>
https://admin.fedoraproject.org/mailman/listinfo/trans-zh_cn

_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Reply via email to